Re: insert timestamp values in Hive

Hi, If you want those properties to executed, then you need to create table in ORC format and need to change some configuration on Hive-Site.xml Regards, Srinivas T *Thanks & Regards,* *Srinivas T* On Tue, Oct 27, 2015 at 12:05 PM, Lefty Leverenz wrote: > Oh, right -- I forgot that the tabl

Re: insert timestamp values in Hive

Oh, right -- I forgot that the table has to be bucketed and use ORC format, and several configuration parameters need to be set appropriately. Have you read Hive Transactions , particularly the Limitations

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 http://unmeshasreeveni.blogspot.in/2014/11/updatedeleteinsert-in-hive-0140.html.

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

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 INTO

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

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: > >