Expert Contributor
Posts: 109
Registered: ‎05-19-2016

mysql to hive through flume





How do I read the data written through flume in hive? It is in SEQuence format, I know that because the value in the file starts with SEQ and has binary data. I tried setting file format to SEQUENCEFILE in hive for the table but it gives all nulls. Please suggest


I have tried importing it to HDFS first and then creating hive table and directly using hive sink as well. None of those helped