Hi there,
I'm looking for help with the following error: I keep receiving an error
'Parse Error: line 40:4 cannot recognize input near '-' 'Platform' STRING
column type. '
It looks to be a problem with my JSON deserializer OR Hive not recognizing
the - in the field names. So far I've tried commenting it out with / and
//, and tried wrapping single and double quotes around the field name.
Nothing has worked so far.
My code looks like this:
add jar s3://sa/hive-json-serde-0.3.jar;
DROP TABLE IF EXISTS viewstream;
CREATE EXTERNAL TABLE IF NOT EXISTS viewstream(
cl STRING,
pid STRING,
vp STRING,
ar STRING,
UArm STRING,
dc STRING,
host STRING,
Blocked STRING,
UA-Platform STRING,
UA-Browser STRING,
UA-Version STRING,
UA-Language STRING
)
ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.JsonSerde'
LOCATION 'hdfs:///repo/viewstream/';
Anybody run into similar errors? I can't find anything on this problem
online, strangely enough.
Thanks all,
Alex