Your quotation marks around the location string seem to be wrong Daniel
> On 26 במרץ 2015, at 22:10, bitsofinfo <bitsofinf...@gmail.com> wrote: > > 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
