Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-600

ODBC driver for impala doesn't support sqlserver: Requested conversion is not supported

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: Impala 1.1.1
    • Fix Version/s: None
    • Component/s: None
    • Environment:
      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

        Attachments

          Activity

            People

            • Assignee:
              justin@cloudera.com Justin Erickson
              Reporter:
              qwert a bc
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: