Hi, Thanks for the suggestions. I was planning to parquet format. I will read about transactions fully before proceeding.
Regards, Anand On Tue, Oct 27, 2015 at 12:19 PM, Srinivas Thunga <[email protected] > wrote: > 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 <[email protected]> > wrote: > >> 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 >> <https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions>, >> particularly the Limitations >> <https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions#HiveTransactions-Limitations> >> section? >> >> -- Lefty >> >> On Tue, Oct 27, 2015 at 1:02 AM, AnandaVelMurugan Chandra Mohan < >> [email protected]> wrote: >> >>> 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. >>> This suggests changing hive configurations which are not possible >>> immediately. Is there anything else which you can suggest? >>> >>> Regards, >>> Anand >>> >>> >>> On Tue, Oct 27, 2015 at 9:00 AM, Lefty Leverenz <[email protected] >>> > wrote: >>> >>>> Your table has to support transactions (see Inserting values into >>>> tables from SQL >>>> <https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML#LanguageManualDML-InsertingvaluesintotablesfromSQL>), >>>> so create it with the TBLPROPERTIES clause >>>> <https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions#HiveTransactions-TableProperties> >>>> : >>>> >>>> CREATE TABLE tmp (reporttime timestamp) TBLPROPERTIES >>>> ("transactional"="true"); >>>> >>>> Unfortunately the examples in Inserting values into tables from SQL >>>> <https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML#LanguageManualDML-InsertingvaluesintotablesfromSQL> >>>> don't >>>> show the TBLPROPERTIES clause -- that needs to be fixed in the wiki. >>>> >>>> -- Lefty >>>> >>>> >>>> On Mon, Oct 26, 2015 at 8:49 PM, AnandaVelMurugan Chandra Mohan < >>>> [email protected]> wrote: >>>> >>>>> 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 TABLE tmp VALUES(734196.3552); >>>>> >>>>> INSERT INTO TABLE tmp VALUES(734196); >>>>> >>>>> I read that values of timestamp could be integers which are >>>>> interpreted as seconds since unix epoch time or float which are >>>>> interpreted >>>>> as seconds since unix epoch time with nanasecond precision or string of >>>>> format 'YYYY-mm-dd'. I cannot use third string option as of now. So I am >>>>> trying other two options i.e. int and float. >>>>> >>>>> When I do a select query, I get null >>>>> >>>>> I tried >>>>> >>>>> select to_date(reporttime) from tmp >>>>> select reporttime from tmp >>>>> >>>>> Please help if you have any idea. >>>>> -- >>>>> Regards, >>>>> Anand >>>>> >>>> >>>> >>> >>> >>> -- >>> Regards, >>> Anand >>> >> >> > -- Regards, Anand
