topic Re: Hive error in QlikView

Hive error

perumal_41 — Wed, 19 Nov 2014 07:03:30 GMT

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'

Re: Hive error

Wed, 19 Nov 2014 07:05:52 GMT

Hi Permula,

are you getting the data without using any other function?

Regards

Harshita Gaur

Re: Hive error

maleksafa — Wed, 19 Nov 2014 07:08:02 GMT

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.

Re: Hive error

Wed, 19 Nov 2014 07:13:01 GMT

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.

Re: Hive error

perumal_41 — Wed, 19 Nov 2014 07:27:53 GMT

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

Re: Hive error

Wed, 19 Nov 2014 07:32:29 GMT

did you try precceding load?

Re: Hive error

Tue, 10 Feb 2015 21:18:22 GMT

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