Support Questions

Find answers, ask questions, and share your expertise

CSV file to Hive using Nifi

avatar
Explorer

I want to send my csv file to hive external table, i'm using this processor

InferAvroSchema -> UpdateAttribute (with add properties 'inferred.avro.schema') -> ConvertCSVToAvro -> PutHDFS -> UpdateHive3Table

but when in UpdateHive3Table the processor just read 8kb and in my table just 1 row.

How can i do to fix this?

1 REPLY 1

avatar
Expert Contributor

Perhaps the connection you set between PutHDFS and UpdateHive3Table doesn't send the original file? I am a bit confused by your flow in general.. why convert to avro? Where are you reading files from? Why do you PutHDFS and then UpdateHiveTable instead of just using PutHiveQL?