Re: timestamp to date conversion

2015-11-02 Thread Jason Dere
: user@hive.apache.org Subject: timestamp to date conversion Hello All, I am trying to load a table in ORC format with data coming from another hive table stored in text format. Below is the hive query I am trying. both the tables are partitioned on data_date. insert overwrite table target_table

timestamp to date conversion

2015-11-02 Thread murali parimi
Hello All, I am trying to load a table in ORC format with data coming from another hive table stored in text format. Below is the hive query I am trying. both the tables are partitioned on data_date. insert overwrite table target_table partition(data_date='2015-09-30') select col1, col2, cast(