Member since
02-14-2019
2
Posts
0
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
795 | 12-01-2021 03:53 AM |
12-01-2021
03:53 AM
I managed to fix the problem. I needed to add quotes around the attributes like this: LOAD DATA INPATH '/user/nifi/20211115_nifi_test' INTO TABLE arcsight.`20211130_nifi_test` PARTITION (year="${year}", month="${month}", day="${day}")
... View more
12-01-2021
02:48 AM
Hey, I am using nifi to load data from hdfs to impala table. I am using ExecuteSQL with the following command: LOAD DATA INPATH '/user/nifi/20211115_nifi_test' INTO TABLE arcsight.`20211130_nifi_test` PARTITION (year=${year:toString()}, month=${month:toString()}, day=${day:toString()}) And I am getting the following error: AnalysisException: Value of partition spec (column=year) has incompatible type: 'SMALLINT'. Expected type: 'STRING' Anyone can help?
... View more
Labels:
- Labels:
-
Apache Impala
-
Apache NiFi
-
HDFS