Re: Oracle to HDFS through Sqoop and a Hive External Table

2013-11-03 Thread Venkat Ranganathan
If you are using Sqoop 1.4.4, you could use the hcatalog table option to bring it to Hive. That allows it to be agnostic of the hive table formats (you can use ORC for example or RCFile) and it handles the partitioning easily (including dynamic partitions). And you can directly export from a hi

Re: Sqoop Import Oracle Error - Attempted to generate class with no columns!

2013-05-22 Thread Venkat Ranganathan
Resending, as the last one bounced. You need to specify username and tablename in uppercase, otherwise the job will fail Thanks Venkat On Wed, May 22, 2013 at 4:19 PM, Venkat wrote: > You need to specify username and tablename in uppercase > > Venkat > > > On Wed, May 22, 2013 at 2:27 PM, Ra

Re: Data mismatch when importing data from Oracle to Hive through Sqoop without an error

2013-03-06 Thread Venkat Ranganathan
Hi Ajit Do you know if rest of the columns also are null when the three non null columns are null Venkat On Wed, Mar 6, 2013 at 12:35 AM, Ajit Kumar Shreevastava wrote: > Hi Abhijeet, > > > > Thanks for your response. > > If values that don’t fit in double must be getting inserted as Null is th