Hi , I am using NIFI to read data from SQL and generate hive external tables on ERM (5.9 using hive 2.3.0).
ORC file is generated by NIFI ConvertAvroToOrc ( NIFI 1.4 ).Using ORC file and creating external hive ORC table.query "select * from table" returns NULLs. It works fine with hive 2.1.X and it breaks with hive 2.3. Please find all the details on the topic ( orc file is also attached ). https://community.hortonworks.com/questions/144198/hive-orc-table-returns-nulls.html?childToView=144327#answer-144327 What should be done to NIFI ConvertAvroToOrc knows to work with hive 2.3 properly? *I checked writer version of ORC:* ORC generates with NIFI *"writerVersion": "HIVE_8732"* ORC generated with HIVE 2.3 *"writerVersion": "ORC_135"* Thanks Oleg.
