Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

shree909
Valued Contributor II

How to use the sql commands in hadoop hive database

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

2 Replies
MVP
MVP

Re: How to use the sql commands in hadoop hive database

Hi shree,

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

https://cwiki.apache.org/confluence/display/Hive/LanguageManual

However, this is not a QlikView topic..

- Ralf

shree909
Valued Contributor II

Re: How to use the sql commands in hadoop hive database

Thanks for the Information...

Community Browser