3 Replies Latest reply on May 18, 2021 8:13 AM by Santosh Gade

    Impala table Error by using powercenter through Impala ODBC connection

    Salman Khan New Member

      My requirement is to pull data from Hive tables and dump it into the Impala table using powercenter ODBC Connection.

      I am using Imapala  ODBC connection to write to target table.

      This is simple one to one mapping. No complex transformation involved. After running the workflow I am getting the below error like --

      It seems like Informatica is not creating the proper impala Sql by using Impala ODBC connections. In order to fix, Do I need set change some properties from session level or from the admin conole.

      any help would be appreciated.

      ================================

       

       

      Message: Database errors occurred:

       

       

      Severity Timestamp Node Thread Message Code Message

      ERROR 5/12/2021 2:00:14 PM ins01 WRITER_1_*_1 WRT_8229 Database errors occurred:

      FnName: Execute -- [Cloudera][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : ParseException: Syntax error in line 1:

      ...tl(test1,test2)  VALUES ( ?, ?)

                                   ^

      Encountered: Unexpected character

      Expected: CASE, CAST, DEFAULT, EXISTS, FALSE, IF, INTERVAL, LEFT, NOT, NULL, REPLACE, RIGHT, TRUNCATE, TRUE, IDENTIFIER

       

       

      CAUSED BY: Exception: Syntax error

      , SQLSTATE [S1000]

      FnName: Execute -- [Microsoft][ODBC Driver Manager] Function sequence error, SQLSTATE [S1010]

       

       

      ===========================================

       

      INSERT INTO default.test_temp_etl(test1,test2)  VALUES ( ?, ?)