About jwaligora

jwaligora · ‎02-16-2016

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

jwaligora · ‎02-03-2016

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.

jwaligora · ‎12-11-2015

Thanks. It's unchecked by default. I played with that setting before; setting it to 'on' does cause my previously functional syntax to fail. Right now (native unchecked), doing a select on [a_date] works, but Hive functions like reverse([a_date]) fail.

jwaligora · ‎12-10-2015

Does confirmation of jdbc functionality conclusively exclude odbc driver as the culprit? I read the QV community thread earlier, but since the item was unresolved, I started my own. Subsequently it occurred to me that QV folks won't be able to help me if it's a driver limitation.

jwaligora · ‎12-10-2015

Correct.

jwaligora · ‎12-10-2015

It works in 'hive (a_db)>', but I also checked in beeline (i.e. without using ODBC driver).

jwaligora · ‎12-10-2015

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.

Online	Offline
Last Visited	‎05-02-2016 08:19 PM

Member Since	‎12-10-2015 08:58 PM
Last Visited	‎05-02-2016 08:19 PM
Posts	7
Kudos received	7

Cloudera Community

Re: Hive Functions via ODBC Driver (QlikView)

Re: Hive Functions via ODBC Driver (QlikView)

Re: Hive Functions via ODBC Driver (QlikView)

Re: Hive Functions via ODBC Driver (QlikView)

Re: Hive Functions via ODBC Driver (QlikView)

Re: Hive Functions via ODBC Driver (QlikView)

Re: Hive Functions via ODBC Driver (QlikView)

Hive Functions via ODBC Driver (QlikView)