I have a ORC storage file and I am creating External table in HIVE using the below query. CREATE EXTERNAL TABLE mytable (col1 bigint,col2 bigint) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS ORC location '<ORC File location'; The external table is getting loaded but when i am trying to query in HIVE. it is showing junk data. Can you please suggest what is the mistake in the query. Also , I am using the same delimeter for ORC storage and HIVE table creation. ... View more