Member since
01-30-2017
4
Posts
0
Kudos Received
0
Solutions
07-07-2017
09:09 AM
Hi SIndhu i added them now i am able to create thanks for the help
... View more
07-07-2017
05:38 AM
CREATE EXTERNAL TABLE BOOKDATA (TITLE STRING, PRICE FLOAT)
ROW FORMAT SERDE 'com.ibm.spss.hive.serde2.xml.XmlSerDe'
WITH SERDEPROPERTIES (
"column.xpath.TITLE"="/BOOK/TITLE/text()",
"column.xpath.PRICE"="/BOOK/PRICE/text()")
STORED AS
INPUTFORMAT 'com.ibm.spss.hive.serde2.xml.XmlInputFormat'
OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat'
LOCATION '/home/airflow/swagat/sample.xml'
TBLPROPERTIES ("xmlinput.start"="<BOOK","xmlinput.end"= "</BOOK>"); getting below error FAILED: SemanticException Cannot find class 'com.ibm.spss.hive.serde2.xml.XmlInputFormat'
... View more
Labels:
- Labels:
-
Apache Hive