How to use the sql commands in hadoop hive database

[shree909]

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]

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]

Thanks for the Information...