Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

loading data using nifi to impala table

avatar
New Contributor

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?

 

 

1 ACCEPTED SOLUTION

avatar
New Contributor

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 solution in original post

1 REPLY 1

avatar
New Contributor

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}")