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

2013-11-03 Thread Venkat Ranganathan
t; 4. Think about compression as well before hand, as that will govern the > data split, and performance of your queries as well. > > Regards, > Manish > > > > Sent from my T-Mobile 4G LTE Device > > > > ---- Original message ---- > From: Raj Hadoop > Dat

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

2013-11-03 Thread Raj Hadoop
39 AM (GMT-08:00) To: Hive ,Sqoop ,User Subject: Oracle to HDFS through Sqoop and a Hive External Table Hi, I am sending this to the three dist-lists of Hadoop, Hive and Sqoop as this question is closely related to all the three areas. I have this requirement. I have a big table in O

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

2013-11-03 Thread manish.hadoop.work
-08:00) To: Hive ,Sqoop ,User Subject: Oracle to HDFS through Sqoop and a Hive External Table Hi, I am sending this to the three dist-lists of Hadoop, Hive and Sqoop as this question is closely related to all the three areas. I have this requirement. I have a big table in Oracle (about 60

Oracle to HDFS through Sqoop and a Hive External Table

2013-11-03 Thread Raj Hadoop
Hi, I am sending this to the three dist-lists of Hadoop, Hive and Sqoop as this question is closely related to all the three areas. I have this requirement. I have a big table in Oracle (about 60 million rows - Primary Key Customer Id). I want to bring this to HDFS and then create a Hive exter