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 >
