hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Srinivas Thunga <srinivas.thu...@gmail.com>
Subject Re: insert timestamp values in Hive
Date Tue, 27 Oct 2015 06:49:32 GMT
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 <leftyleverenz@gmail.com>
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 <
> ananthu2050@gmail.com> 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 <leftyleverenz@gmail.com>
>> 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 <
>>> ananthu2050@gmail.com> 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
>>
>
>

Mime
View raw message