我使用配置单元(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
谁能帮我解释一下错误吗?
谢谢,弗兰克
1条答案
按热度按时间exdqitrt1#
可能是mapr特有的?
似乎对我有用。