Hive error

[perumal_41]

Hi Experts,

when i run  without any hive function in sql,it working fine me. when add hive function in the sql, qlikview throwing error .PFB sql and error message

SQL SELECT *,
SPLIT(Test,':') as Test1

FROM "HIVE"."new"."tablename" where id=1249378;

SQL##f - SqlState: S1000, ErrorCode: 35, ErrorMsg: [Cloudera][HiveODBC] (35) Error from Hive: error code: '40000' error message: 'Error while compiling statement: FAILED: ParseException line 7:5 cannot recognize input near '"new"' '.' '"tablename"' in join source'

[#2]

Hi Permula,

are you getting the data without using any other function?

Regards

Harshita Gaur

[maleksafa]

have you checked if the ODBC configuration is correct and working? try accessing HIVE server from excel using normal odbc connection and see if it works.

[#4]

yeah Malek is right, you should first check that your hive server is working properly,then you should try a simple statment. If you are getting the correct value, then you can try using preceding load, then using the function in sql statment. Because many qlikview functions dont work with SQL.

[perumal_41]

Hi Harshita and Melak,

Thanks for fast response.

  ODBC  is working with hive server  so only with out any function   ,qlikview retriving data from Hive server.

Regards,

Perumal A

[#6]

did you try precceding load?

[#7]

Hi Perumal,

Please go to ODBC Data Source Administrator (64-Bit) -> System DSN tab -> Click on the Cloudera Hive DSN Connector -> Click Configure -> Go to Advanced Options and uncheck "Use Native Query".

Let me know if this helps.

Regards,

Janaki