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)