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,

Re: timestamp to date conversion

2015-11-02 Thread Jason Dere
Monday, November 02, 2015 11:15 AM To: 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 dat