Member since
01-23-2020
5
Posts
0
Kudos Received
0
Solutions
10-26-2022
01:19 PM
I have a Nifi process where I create a Hive table and add a single row to the table in a separate PutHiveQL process. The 'create table' process works most of the time, but the 'insert' almost always fails with the below error. This even though I direct the issue to the RetryFlowFile processor and repeat it 5 times. Note that I can run the same insert statement in Hue without any issues. What could be the problem? Is there anything I can tweak to make this work? PutHiveQL[id=27ab3890-0b98-1ba9-8499-5c4985902ebf] Failed to update Hive for StandardFlowFileRecord[uuid=91a0e7ea-5f2d-4530-bcd8-6e650597f6c7,claim=StandardContentClaim [resourceClaim=StandardResourceClaim[id=1666794893345-1, container=default, section=1], offset=5660, length=128],offset=0,name=91a0e7ea-5f2d-4530-bcd8-6e650597f6c7,size=128] due to Error while compiling statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask; it is possible that retrying the operation will succeed, so routing to retry: java.sql.SQLException: Error while compiling statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask
... View more
Labels:
- Labels:
-
Apache Hive
-
Apache NiFi
04-15-2021
11:10 AM
I have a tar file with .csv, .xml, and .txt files that I want to unpack using the UnpackContent processor. Can I specify all three file types in the file filter?
... View more
Labels:
- Labels:
-
Apache NiFi