Hi all,
I'm using ValidateRecord processor to validate the csv and convert it into Avro. Later, I convert this avro to orc using ConvertAvroToORC processor and write it to hdfs and create a hive table on the top of it. When I query the table, it displays null, though the record count is matching. Flow - ValidateRecord -> ConvertAvroToORC -> PutHDFS -> CreateHiveTable To debug, I also tried to write the avro data to hdfs and created the hive table on the top of it. It is also displaying null results. Flow - ValidateRecord -> ConvertCSVToAvro -> PutHDFS I manually created hive table with avro format. When I use ValidateRecord + ConvertCSVToAvro, it is working fine. Flow - ValidateRecord -> ConvertCSVToAvro -> ConvertAvroToORC -> PutHDFS -> CreateHiveTable Is there anything I'm doing wrong? Thanks, Mohit
