Support Questions

Find answers, ask questions, and share your expertise

Hive Functions via ODBC Driver (QlikView)

avatar
Explorer

Hi,

I'm having some trouble executing function-based Hive queries in QlikView (ODBC connector parse error), and I'm looking to understand if the fault lies in the QV syntax, or if functions are simply not supported by the Hive ODBC driver.

Example...

The following works in Hive command line:

select distinct a_date, reverse(a_date) from a_table where a_date > '20151201';

The following fails in QV:

SQL SELECT 
	reverse("a_date")
FROM HIVE.a_db."a_table"
WHERE "a_date" > '20151201';

The QV and connector implementation is fine otherwise; substituting 'reverse' with 'max' executes happily.

Thanks,

J.

1 ACCEPTED SOLUTION

avatar
Explorer

This problem has been resolved. Errors were caused by QV syntax peculiarities. Details can be viewed in the QV Community post here.

Thanks!

View solution in original post

12 REPLIES 12

avatar
Master Mentor

@Joanna Waligora are you still having issues with this? Can you accept best answer or provide your own solution?

avatar
Explorer

The QV support team is currently investigating this problem. I will provide an update / closure once I receive their feedback.

Also, I want to correct my initial statement - max, and length functions work fine, but reverse, instr, and regexp_extract don't.

avatar
Explorer

This problem has been resolved. Errors were caused by QV syntax peculiarities. Details can be viewed in the QV Community post here.

Thanks!