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 <[email protected]> wrote: 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 <[email protected]> wrote: 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 the data type of column using ALTER to the new type, it is >still showing NULL values. > > >How should I resolve this? > > >Do I need to recreate the table? If so, I have loaded lot of data and I should >not loose the data. This is an External table. > > >Please advise. > > > > > >Regards, >Raj
