Thank you, Eugene! On Thu, Jul 21, 2016 at 7:43 PM, Eugene Koifman <ekoif...@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.develo...@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.develo...@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 >> > >
