Details
-
Bug
-
Status: Resolved
-
Blocker
-
Resolution: Fixed
-
Impala 1.1.1
-
None
-
None
-
centos6, sqlserver 2008R2, ODBC driver for Impala 2.5.2.1002
Description
Sorry, I didn't find ODBC driver project, so I open the bug here.
Error message when select sqlserver view "tblFactValidationErrors_viewFromImpala":
OLE DB provider "MSDASQL" for linked server "ImpalaDW" returned message "Requested conversion is not supported.".
Msg 7341, Level 16, State 2, Line 2
Cannot get the current row value of column "[MSDASQL].sessionid" from OLE DB provider "MSDASQL" for linked server "ImpalaDW".
Background:
1. One hive table "tblFactValidationErrors_view4impala", it works well since I can select it in impala-shell
2. One Linked server "ImpalaDW", based on ODBC driver for Impala v2.5.2.1002
3. create view [dbo].[tblFactValidationErrors_viewFromImpala] AS SELECT * FROM OPENQUERY(ImpalaDW, 'select * from tblFactValidationErrors_view4impala'); on SQL server 2008R2
4. select sqlserver view "tblFactValidationErrors_viewFromImpala", if select int type column, no error;
but if select varchar/text type column, with error above.
Question:
Is it a bug that ODBC driver for Impala? that means ODBC driver for impala doesn't support sqlserver 2008R2.
or Can I do anything to workaround it?
If this is a bug, then a block bug, string/varchar/text is a most basic type, we cannot move on without it.
There is also some other source about this issue:
https://groups.google.com/a/cloudera.org/forum/#!topic/impala-user/fvGRgL3lSU4
then search "a problem with strings", then find "This is only affecting SQL Server linked servers, I believe it's because it expects VARCHAR(4000) but IMPALA string size is INT_MAX (32,767 f)."
And I also post a post here:
http://community.cloudera.com/t5/Interactive-Short-cycle-SQL/ODBC-driver-for-impala-doesn-t-support-sqlserver-Requested/m-p/1763#U1763