Hello Friends, am very new to Nifi and have a following question.
I will have to read content file (have 25 columns) and 10 columns in this file are numeric columns and have to go into 10 different lookup file to get the descriptions.. have to concatenate all the description columns and have to load into a Hive table.
for example 3rd column in the content file have value 25 and have to look for country description in country lookup file and have to write country name along with other columns (that i have read from content file).
please advice with examples.
Lookup tables are a bit of work.
It may be best to load into Hive as ORC and then
Are the lookup tables in Hive or elsewhere?
lookup's are files, have to get the description from lookup file and will have to load HIVE table along with content file data.