Peter Turcsanyi created NIFI-8996:
-------------------------------------

             Summary: PutHive*QL processors do not close JDBC statements
                 Key: NIFI-8996
                 URL: https://issues.apache.org/jira/browse/NIFI-8996
             Project: Apache NiFi
          Issue Type: Bug
            Reporter: Peter Turcsanyi
            Assignee: Peter Turcsanyi


When multiple HiveQL statements arrive in a FlowFile, PutHive*QL processors 
create and execute the statements in a loop but do not close them. It may lead 
to data loss.

Example scenario:
 * create a source table with 100 Mio records (single int column with random 
numbers)
 * create 10 target tables with the same structure
 * feed PutHive3QL with a single FF containing the following script:

{code:java}
truncate table target0;
insert into target0 select * from source;
truncate table target1;
insert into target1 select * from source;
...{code}

 * result: some target tables are empty instead of having the 100 Mio records



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to