hive hadoop error during table creation

0
votes

I have created a table in hive as below , 

 hive> create  table engeometry(name string,shape binary)
    > ROW FORMAT SERDE 'com.esri.hadoop.hive.serde.JsonSerde'
    > row format delimited by '\n'
    > STORED AS INPUTFORMAT 'com.esri.json.hadoop.UnenclosedJsonInputFormat'
    > OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
    > ;

I get error as shown below:

FAILED: ParseException line 3:0 missing EOF at 'row' near ''com.esri.hadoop.hive.serde.JsonSerde''

I want to create table in hive with space defined between rows , when i try the same i get message as show above.

1
hivehadoop2

1 Answers

0
votes

You don't need to give row format delimited by Clause.
Below query is enough to work:

hive> create  table engeometry(name string,shape binary)
    > ROW FORMAT SERDE 'com.esri.hadoop.hive.serde.JsonSerde'
    > STORED AS INPUTFORMAT 'com.esri.json.hadoop.UnenclosedJsonInputFormat'
    > OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat';