Whiletryingtoexecutethecreatetablestatementinhivegettingthebelowerror.CREATEEXTERNALTABLEBOOKDATA(>TITLEVARCHAR(40),>PRICEINT>)ROWFORMATSERDE'com.ibm.spss.hive.serde2.xml.XmlSerDe'>WITHSERDEPROPERTIES(>"column.xpath.TITLE"="/CATALOG/BOOK/TITLE/",>"column.xpath.PRICE"="/CATALOG/BOOK/PRICE/")>STOR

下面是我输入的XMLAEY000977645000977645AEY我需要解析此数据并使用具有4列(ProviderID、PAID、PID、message_reason)的hivexmlserde创建一个Hive表。由于所有值都在标签内，因此很难解析数据。下面是我的表DDL。CREATEEXTERNALTABLExml_testing(provider_idString,paidString,pidString,message_reasonString)ROWFORMATSERDE'com.ibm.spss.hive.serde2.xml.XmlSerDe'WITHSERDEPROPE