Hello @rohinimathursjc    The best way to get the list of Hive external tables and Managed tables is using hive metastore. yes by applying some quires on hive metastore tables we can divide both Hive external tables and Managed tables . please follow the below link to get the queries  https://askdoubts.com/question/list-of-hive-internal-tables-from-metadata/#comment-20   ... View more

@Shu_ashu Great!. With the instructions you have given me, the output file is created correctly. I also tried the option: CREATE TABLE AS scenariox_out AS SELECT select count (*) from scenariox; And the output file was created in: /user/hive/warehouse/scenariox.db/scenariox/scenariox_out/000000_0 Thank you. You have a good day ... View more

Hi All,   I am doing a similar POC.   We are trying to implement batch ingestion using NiFi.   Problem statement: I am preparing a SQL query and put the query in the processor using REST API. But, I want to stop the processor group after the ingestion is done because for the next run I will put the query with update CDC column value.   Can someone please help me with the logic of stopping the processor after the ingestion is done, because to modify the processor, it has to be stopped ... View more

Hi Vijay, Sorry, haven't able to nail down the cause yet, but can you collect EXPLAIN EXTENDED of the query and share the output as attachment to the post? EXPLAIN EXTENDED select * from tdb1.t1 where bs1_dt=2017-06-23; EXPLAIN EXTENDED select * from tdb1.t1; I would like to check how HS2 does the query plan and see if there is any clue. Cheers Eric ... View more

Found the solution!  Just needed to apply the regex  (?:"b":.\w+?)(\d+) thanks to @Shu_ashu   ... View more

Thanks a lot!  ... View more