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".
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 v18.104.22.1682
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.
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:
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)."