hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bitsofinfo <bitsofinf...@gmail.com>
Subject 0.14 parse exception, row format question
Date Thu, 26 Mar 2015 20:10:39 GMT
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

Mime
View raw message