hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Konstantin Ryakhovskiy <ryakhovskiy.develo...@gmail.com>
Subject Re: Hive sink for Flume, hcatalog error: 'transactional' property is not set on Table
Date Thu, 21 Jul 2016 19:20:51 GMT
Thank you, Eugene!

On Thu, Jul 21, 2016 at 7:43 PM, Eugene Koifman <ekoifman@hortonworks.com>
wrote:

> <https://cwiki.apache.org/confluence/display/Hive/Streaming+Data+Ingest>Perhaps
> you’ve already seen this
> https://cwiki.apache.org/confluence/display/Hive/Streaming+Data+Ingest
>  and https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions
> In order to configure Hive properly to stream data into it there is some
> additional configuration that needs to be done on Hive side.
>
> Eugene
>
> From: Konstantin Ryakhovskiy <ryakhovskiy.developer@gmail.com>
> Reply-To: "user@hive.apache.org" <user@hive.apache.org>
> Date: Thursday, July 21, 2016 at 2:43 AM
> To: "user@hive.apache.org" <user@hive.apache.org>
> Subject: Re: Hive sink for Flume, hcatalog error: 'transactional'
> property is not set on Table
>
> Hi,
>
> issue is fixed by re-creating a table with property
> TBLPROPERTIES ("transactional"="true")
>
> Thanks,
> Konstantin
>
> On Thu, Jul 21, 2016 at 10:30 AM, Konstantin Ryakhovskiy <
> ryakhovskiy.developer@gmail.com> wrote:
>
>> Hi!
>>
>> I am setting up Flume with HTTP source + JSON Handler and Hive sink.
>> when I am json sending data to flume, I am receiving OK response
>> Response:
>> --- HEADERS ---
>> Transfer-Encoding: chunked
>> Server: Jetty(6.1.26.hwx)
>> --- STATUS ---
>> Code: 200
>> Description: OK
>> Version: HTTP/1.1
>>
>> However, when data is inserted into hive I am receiving following error:
>> [ERROR -
>> org.apache.hive.hcatalog.streaming.HiveEndPoint$ConnectionImpl.checkEndPoint(HiveEndPoint.java:304)]
>> 'transactional' property is not set on Table {metaStoreUri='thrift://
>> sandbox.hortonworks.com:9083', database='MYDB', table='mytable',
>> partitionVals=[] }
>>
>> Can you please advise?
>> Thanks,
>> Konstantin
>>
>> not sure that this is correct mailing list, probably it is better to
>> write to Flume Users list
>>
>
>

Mime
View raw message