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
