[summary] Hive table-building statements in various data formats
Xml format
CREATE EXTERNAL TABLE Gateway_pmsarisoap (
BookingSoapLogID STRING
GuidNo STRING
SoapType STRING
SoapContent STRING
InsertDate STRING
SourceOpsType STRING)
PARTITIONED BY (
`dt` string)
ROW FORMAT SERDE 'com.ibm.spss.hive.serde2.xml.XmlSerDe'
WITH SERDEPROPERTIES (
"column.xpath.BookingSoapLogID" = "/ HWSoapBase/BookingSoapLogID/text ()"
"column.xpath.GuidNo" = "/ HWSoapBase/GuidNo/text ()"
"column.xpath.SoapType" = "/ HWSoapBase/SoapType/text ()"
"column.xpath.SoapContent" = "/ HWSoapBase/SoapContent/*"
"column.xpath.InsertDate" = "/ HWSoapBase/InsertDate/text ()"
"column.xpath.SourceOpsType" = "/ HWSoapBase/SourceOpsType/text ()"
)
STORED AS
INPUTFORMAT 'com.ibm.spss.hive.serde2.xml.XmlInputFormat'
OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat'
LOCATION 'hdfs://ns1/wh/source/hw/Gateway/PmsARISoap'
TBLPROPERTIES (
"xmlinput.start" = "