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 09:43:21 GMT
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