Member_2_7966113
asked on
Unable to Store Results from Hive Hadoop Script
Hello Experts,
I have created the following Hadoop Hive Script.
The script is attempting to store the results of a query into the following location:
LOCATION 'wasb://adfgetstarted@geog storeacct. blob.core. windows.ne t/sampleou t/';
However, I keep on getting the following error:
The Hive script is as follows:
Can someone please help figure out where I'm going wrong in the script?
Thanks
I have created the following Hadoop Hive Script.
The script is attempting to store the results of a query into the following location:
LOCATION 'wasb://adfgetstarted@geog
However, I keep on getting the following error:
FAILED: ParseException line 9:0 Failed to recognize predicate 'ROW'. Failed rule: 'identifier' in table or column identifier
18/01/30 16:08:06 [main]: ERROR ql.Driver: FAILED: ParseException line 9:0 Failed to recognize predicate 'ROW'. Failed rule: 'identifier' in table or column identifier
org.apache.hadoop.hive.ql.parse.ParseException: line 9:0 Failed to recognize predicate 'ROW'. Failed rule: 'identifier' in table or column identifier
The Hive script is as follows:
[code]DROP TABLE IF EXISTS geography;
CREATE EXTERNAL TABLE geography
(
anonid INT,
eprofileclass INT,
fueltypes STRING,
acorn_category INT,
acorn_group STRING,
acorn_type INT,
nuts4 STRING,
lacode STRING,
nuts1 STRING,
gspgroup STRING,
ldz STRING,
gas_elec STRING,
gas_tout STRING
)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
STORED AS TEXTFILE
LOCATION 'wasb://adfgetstarted@geogstoreacct.blob.core.windows.net/sampleout/'
TBLPROPERTIES ("skip.header.line.count" = "1");
Create table acorn_category_frequency
as
select acorn_category,
count(*) as acorn_categorycount
from geography
group by acorn_category,
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
STORED AS TEXTFILE
LOCATION 'wasb://adfgetstarted@geogstoreacct.blob.core.windows.net/sampleout/';
[/code]Can someone please help figure out where I'm going wrong in the script?
Thanks
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Which version of hive you are using ? Row/rows are one of the reserved words in latest versions.
Try setting below variable (for backward compatibility) prior to run the query.
Open in new window
Please share the result.