2 Replies Latest reply: Aug 23, 2013 1:18 PM by sree anaarasi RSS

    How to use the sql commands in hadoop hive database

    sree anaarasi

      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