Inserting data from one hive table to another


#1

Hi Team,

I am having a table TABLE1 with 4 columns(name string,city string,fromdate string,todate string).
In this table i saving date also in string datatype.
Now i created a new table TABLE2 like previous one but this time with different datatypes(name string,city string,fromdate TIMESTAMP,todate TIMESTAMP)
When i am trying to insert data from TABLE1 to TABLE2 using "insert into …"
i am getting NULL values for datatype changed columns.

Can anyone help me with this ?


#2

@ik009,

You can use date UDF’s in Hive to convert date format.