hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Edward Capriolo <edlinuxg...@gmail.com>
Subject Re: Sqoop import to HDFS and then Hive table - Issue with data type
Date Tue, 04 Mar 2014 22:30:23 GMT
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 <hadoopraj@yahoo.com> 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
>

Mime
View raw message