Re: Sqoop import to HDFS and then Hive table - Issue with data type

2014-03-04 Thread Raj Hadoop
I am surprised. So you mean to say should I keep on running the same command multiple times -] Alter table It was a timestamp and then I later changed to string. Please advise. On Tuesday, March 4, 2014 5:30 PM, Edward Capriolo wrote: No hive meta data does not change how the data is s

Re: Sqoop import to HDFS and then Hive table - Issue with data type

2014-03-04 Thread Edward Capriolo
No hive meta data does not change how the data is stored. Just keep changing until you get it right :) On Tue, Mar 4, 2014 at 5:23 PM, Raj Hadoop wrote: > All, > > I loaded data from an Oracle query through Sqoop to HDFS file. This is > bzip compressed files partitioned by one column date. > >

Sqoop import to HDFS and then Hive table - Issue with data type

2014-03-04 Thread Raj Hadoop
All, I loaded data from an Oracle query through Sqoop to HDFS file. This is bzip compressed files partitioned by one column date. I created a Hive table to point to the above location. After loading lot of data , I realized the data type of one of the column was wrongly given. When I changed