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

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 ajit.shreevast...@hcl.com wrote: Hi Abhijeet, Thanks for your response. If values that don’t fit in double must be getting