配置单元xml服务器：失败，出现异常java.io.ioexception:java.lang.nullpointerexception

a9wyjsp7 于 2021-06-26 发布在 Hive

关注(0)|答案(1)|浏览(305)

我使用配置单元（hive2.1.1-mapr-1703）从带有xmlserde的xml文件创建了一个外部表。该文件是来自w3c联盟的xml示例。
这是我创建表的代码：

add jar /mapr/localpath/hivexmlserde-1.0.5.3.jar;
USE my_db;
CREATE EXTERNAL TABLE frank_books (
category STRING,
title STRING,
language STRING,
year BIGINT
)
ROW FORMAT SERDE 'com.ibm.spss.hive.serde2.xml.XmlSerDe'
WITH SERDEPROPERTIES (
"column.xpath.category" = "/book/@category",
"column.xpath.title"    = "/book/title/text()",
"column.xpath.language" = "/book/title/@lang",
"column.xpath.year"     = "/book/year/text()"
)
STORED AS
INPUTFORMAT 'com.ibm.spss.hive.serde2.xml.XmlInputFormat' 
OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat'
LOCATION '/mapr/localpath/database_files/xml_example'
TBLPROPERTIES (
"xmlinput.start" = "<book category",
"xmlinput.stop" = "</book>"
)

表本身存在，因为DESCRIPE语句不会导致错误：

describe frank_books;

类似以下的简单select语句会导致nullpointerexception：

select * from my_db.frank_books;

这是输出：

OK
Failed with exception java.io.IOException:java.lang.NullPointerException
Time taken: 1.117 seconds

谁能帮我解释一下错误吗？
谢谢，弗兰克

Hive xml hive-serde

来源：https://stackoverflow.com/questions/45158949/hive-xml-serde-failed-with-exception-java-io-ioexceptionjava-lang-nullpointere

1条答案

按热度按时间

exdqitrt1#

可能是mapr特有的？

hive> DROP TABLE IF EXISTS xml_45158949;
OK
Time taken: 0.977 seconds
hive> 
    > CREATE  TABLE xml_45158949(
    > category STRING,
    > title STRING,
    > language STRING,
    > year BIGINT
    > )
    > ROW FORMAT SERDE 'com.ibm.spss.hive.serde2.xml.XmlSerDe'
    > WITH SERDEPROPERTIES(
    > "column.xpath.category" = "/book/@category",
    > "column.xpath.title"    = "/book/title/text()",
    > "column.xpath.language" = "/book/title/@lang",
    > "column.xpath.year"     = "/book/year/text()"
    >   )
    > STORED AS 
    > INPUTFORMAT 'com.ibm.spss.hive.serde2.xml.XmlInputFormat' 
    > OUTPUTFORMAT    'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat' 
    > TBLPROPERTIES (
    > "xmlinput.start"="<book category",
    > "xmlinput.end"="</book>"
    > );
 OK
 Time taken: 0.243 seconds
 hive> 
  > load data local inpath '/Users/dvasilen/Misc/XML/45158949.xml'        OVERWRITE into table xml_45158949;
 Loading data to table default.xml_45158949
 OK
 Time taken: 0.153 seconds
 hive> 
  > select * from xml_45158949;
  OK
 cooking     Everyday Italian   en  2005
 children   Harry Potter    en  2005
 web     XQuery Kick Start  en  2003
 web     Learning XML   en  2003
 Time taken: 0.08 seconds, Fetched: 4 row(s)
 hive>

似乎对我有用。

赞(0）回复(0）举报 2021-06-26

我来回答

配置单元xml服务器：失败，出现异常java.io.ioexception:java.lang.nullpointerexception

1条答案

相关问题

热门标签

最新问答