Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

when use hive jdbc , can not query transactional table

Highlighted

Re: when use hive jdbc , can not query transactional table

Master Collaborator

If Flume was used to populate Hive (througn HiveSink) then the data should have been written properly. Can you check the Flume log to see if the data was successfully getting written to Hive? Note that ACID needs to be enabled on Hive Metastore before streaming data from Flume into Hive.

Re: when use hive jdbc , can not query transactional table

Explorer

@Deepesh. Thanks a lot for your quick response. I think data been written properly, as I can use hive CLI to query all data in my table simple4, no matter data written by flume or by SparkSQL program. The problem is when I use SparkSQL or beeline CLI to query data, only data written by SparkSQL or inserted in beeline, not those been written by Flume.

Don't have an account?
Coming from Hortonworks? Activate your account here