<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 <[email protected]<mailto:[email protected]>> Reply-To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Date: Thursday, July 21, 2016 at 2:43 AM To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> 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 <[email protected]<mailto:[email protected]>> 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<http://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
