topic How to use the sql commands in hadoop hive database in QlikView

How to use the sql commands in hadoop hive database

shree909 — Fri, 23 Aug 2013 16:30:32 GMT

Hi,

I was using oracle as data source for extracting the data and generating the qvds.

Now we have shifted to HadoopHive database so whatever the script i have written in oracle to be changed to haddop.

i used Decode function for changing the names so how to use this in hadoop and dateformats?????

like this i have many functions i used is there a way that can get the proper syntax . i searched in Google but didn't find anything useful.

if someone has used this that would be helpful..

Thanks

rbecher — Fri, 23 Aug 2013 16:35:27 GMT

Hi shree,

search for HQL (Hive Query language) and take a look here:

However, this is not a QlikView topic..

- Ralf

shree909 — Fri, 23 Aug 2013 17:18:13 GMT

Thanks for the Information...