Hi, What is wrong with this query? I am reading the docs and it appears that this should work no?
INSERT OVERWRITE DIRECTORY “/user/admin/mydirectory” ROW FORMAT DELIMITED FIELDS TERMINATED BY ‘\t’ select * from my_table_that_exists; Error occurred executing hive query: Error while compiling statement: FAILED: ParseException line 2:0 cannot recognize input near ‘ROW’ ‘FORMAT’ ‘DELIMITED’ in statement Version of Hue/Hive etc I am running: ———————————————- Hue 2.6.1-2041 HDP 2.2.0 Hadoop 2.6.0 Pig 0.14.0 Hive-Hcatalog 0.14.0 Oozie 4.1.0 Ambari 1.7-169 HBase 0.98.4 Knox 0.5.0 Storm 0.9.3 Falcon 0.6.0
