Issue with Oracle Hive Metastore (SEQUENCE_TABLE)

2013-07-03 Thread Raj Hadoop
Hi,   When I installed Hive earlier on my machine I used a oracle hive meta script. Please find attached the script. HIVE worked fine for me on this box with no issues.   I am trying to install Hive on another machine in a different Oracle metastore. I executed the meta script but I am having

Re: Issue with Oracle Hive Metastore (SEQUENCE_TABLE)

2013-07-03 Thread Darren Yin
you can get the hive 0.9 oracle script here: https://github.com/apache/hive/blob/trunk/metastore/scripts/upgrade/oracle/hive-schema-0.9.0.oracle.sql On Wed, Jul 3, 2013 at 1:22 PM, Raj Hadoop hadoop...@yahoo.com wrote: Hi, When I installed Hive earlier on my machine I used a oracle hive meta