Re: unsubscribe

Archit, to unsubscribe you have to send a message to -unsubscribe@.apache.org as described here: - https://hive.apache.org/mailing_lists.html - https://tez.apache.org/mail-lists.html -- Lefty Leverenz On Sun, Oct 25, 2015 at 3:42 AM, Archit Thakur wrote: > >

insert timestamp values in Hive

Hi, I believe my Hive version is Apache 1.2.0. I guessed it from the folder and hive-hwi.jar names. I am trying to insert values into a column of type timestamp. It does not work This is how I create the table CREATE TABLE tmp (reporttime timestamp); I tried following insert queries INSERT

Re: insert timestamp values in Hive

Your table has to support transactions (see Inserting values into tables from SQL ), so create it with the TBLPROPERTIES clause

Re: insert timestamp values in Hive

Hi, Thanks for your suggestion. I tried this and I get the following error "Attempt to do update or delete on table tmp that does not use an AcidOutputFormat or is not bucketed". I googled about it and found this link

Inverted question mark as delimiter

Hello All, How to use inverted question mark as delimiter in hive. In vi editor data file shows -? As delimiter that's why am getting dash in every column of hive table. Awaiting your reply. Thanks, Suyog