Cloudera Community
Gil
user rank
New Contributor
My Accepted Solutions
Show All

Re: loading data using nifi to impala table

by New Contributor in Support Questions
‎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

loading data using nifi to impala table

by New Contributor in Support Questions
‎12-01-2021 02:48 AM
‎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:
Contact Me
Online
Offline
Last Visited
‎02-10-2022 07:20 AM
Community Statistics
Member Since ‎02-14-2019 03:00 AM
Last Visited ‎02-10-2022 07:20 AM
Posts 2