Member since
02-08-2022
3
Posts
0
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
119 | 02-10-2022 07:06 AM |
02-10-2022
07:06 AM
I used MergeContent and i solved my problem. Thanks !
... View more
02-10-2022
07:02 AM
I am trying to insert mssql data into parquet table on impala using nifi. I used executesql->PutdatabaseRecord but it is so slow. Then i used attributes and replacetext processors. I sent 'INSERT INTO X VALUES (1,'XX'),(2,'YY')' to PutSQL or ExecuteSQL processors(maybe I thought it might be faster than putdatabaserecord) but it's slow. How can i insert data into parquet table more faster?
... View more
Labels:
- Labels:
-
Apache NiFi
02-08-2022
05:13 AM
I'm using ExecuteSQL,SplitAvro,ConvertAvroToJSON,EvaluateJsonPath,ReplaceText,ExecuteSQL. I am trying to replace the content in the flowfile using replaceText processor. Now, i can replace like this. -> INSERT INTO values (${id},'${name}') . ReplaceText process like this : INSERT into x values(1,'xx') INSERT into x values(2,'yy') INSERT into x values(3,'zz') I'm sending INSERT query for each line. But i want to send executesql process like this INSERT INTO x values (1,'xx'),(2,'yy'),(3,'zz')
... View more
Labels:
- Labels:
-
Apache NiFi