https://community.cloudera.com/t5/Support-Questions/Convert-Hive-Column-type-String-to-Hive-Column-type-struct/m-p/242787#M204586 <P>Dear community I have executed a SELECT * to fetch all the tables from a hive table using Nifi 1.6 SelectHiveQL processor. </P><P>The problem I have is the source table has a column (satellite_metadata) which is type struct&lt;record_source:string,load_time:timestamp,checksum:string,device_hash:string&gt;).</P><P>However in the flowfile returned by SelectHiveQL the type of column satellite_metadata is string.</P><P>After fetching the data, I am converting AVRO to ORC, storing the file in HDFS, extracting the HIVE DDL from the flowfile and creating the hive table.</P><P>The content of column satellite_metadata for a single record looks like this:</P><PRE>{"record_source":"RAB","load_time":"2019-01-18 03:16:26.93","checksum":"11396be4b6cfe13542d3d6708546a4a4","device_hash":"2eac97fce07480194301e482680fe05e"}</PRE><P>I tried to define the correct structure at CREATE TABLE and also afterwards using ALTER TABLE But I get the following error when I try to do SELECT * </P><PRE>ORC does not support type conversion from file type string (14) to reader type struct</PRE><P>Any ideas how can I set the proper type for this struct column?</P><P>I've tried also to store the avro file in HDFS, but later I don't know how to create an external hive table that can read the schema from the .avro file.</P> Wed, 23 Jan 2019 18:23:25 GMT mariano_billing 2019-01-23T18:23:25Z