Get the App
SLTechnology News&Howtos  ›  Internet Technology  › 

[summary] Hive table-building statements in various data formats

Shulou Source: shulou.com Published: 2022-06-03 07:42:51 11月23日 Update

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" = "

Tags: Format data statement Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno vpn Shulou Information Microsoft OPPO Reno MySQL