FAILED: ParseException line x:y missing EOF at 'LOCATION' near ')' on Hive Query
Last updated on SEPTEMBER 18, 2013
Applies to:
Big Data Appliance Integrated Software - Version 2.0.1 and laterLinux x86-64
Symptoms
Running a Hive query like the one below raises: FAILED: ParseException line <x>:<y> missing EOF at 'LOCATION' near ')'
hive> CREATE EXTERNAL TABLE IF NOT EXISTS doctors_ext
> ROW FORMAT
> SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe'
> STORED AS
> INPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat'
> OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat'
> TBLPROPERTIES ('avro.schema.literal'='{
> "namespace": "testing.hive.avro.serde",
> "name": "doctors",
> "type": "record",
> "fields": [
> {
> "name":"number",
> "type":"int",
> "doc":"Order of playing the role"
> },
> {
> "name":"first_name",
> "type":"string",
> "doc":"first name of actor playing role"
> },
> {
> "name":"last_name",
> "type":"string",
> "doc":"last name of actor playing role"
> },
> {
> "name":"extra_field",
> "type":"string",
> "doc:":"an extra field not in the original file",
> "default":"fishfingers and custard"
> }
> ]
> }')
> LOCATION '/user/oracle/test/';
FAILED: ParseException line 35:0 missing EOF at 'LOCATION' near ')'
> ROW FORMAT
> SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe'
> STORED AS
> INPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat'
> OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat'
> TBLPROPERTIES ('avro.schema.literal'='{
> "namespace": "testing.hive.avro.serde",
> "name": "doctors",
> "type": "record",
> "fields": [
> {
> "name":"number",
> "type":"int",
> "doc":"Order of playing the role"
> },
> {
> "name":"first_name",
> "type":"string",
> "doc":"first name of actor playing role"
> },
> {
> "name":"last_name",
> "type":"string",
> "doc":"last name of actor playing role"
> },
> {
> "name":"extra_field",
> "type":"string",
> "doc:":"an extra field not in the original file",
> "default":"fishfingers and custard"
> }
> ]
> }')
> LOCATION '/user/oracle/test/';
FAILED: ParseException line 35:0 missing EOF at 'LOCATION' near ')'
Cause
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms