Re: Sqoop Oracle Import to Hive Table - Error in metadata: InvalidObjectException

2013-05-25 Thread bejoy_ks
Hi Can you try doing the import again after assigning 'DS12' the default schema for the user doing the import. Your DB admin should be able to do this in oracle . Regards Bejoy KS Sent from remote device, Please excuse typos -Original Message- From: Raj Hadoop Date: Sat, 25 May 2013

Sqoop Oracle Import to Hive Table - Error in metadata: InvalidObjectException

2013-05-25 Thread Raj Hadoop
Hi, I am trying to run the following to load an Oracle table to Hive table using Sqoop, sqoop import --connect jdbc:oracle:thin:@//inferri.dm.com:1521/DBRM25 --table DS12.CREDITS --username UPX1 --password piiwer --hive-import Note: DS12 is a schema and UPX1 is the user through which the sche

Re: Hive Server2 thrift java client

2013-05-25 Thread Ghousia
Hi Prasad, Thanks for the reply. We were looking for the storage descriptors, as our implementation based on HiveServer 1 is based on these. So does it mean, we do not have any way to access the storage and partition details when working with HiveServer2. And we need to change our implementation t