Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
perumal_41
Partner
Partner

Hive error

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'

6 Replies
Not applicable

Hi Permula,

are you getting the data without using any other function?

Regards

Harshita Gaur

maleksafa
Specialist
Specialist

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.

Not applicable

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
Partner
Partner
Author

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

Not applicable

did you try precceding load?

Not applicable

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