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)."
... View more
