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'
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.
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.