Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Bytes Consumed Error

Bytes Consumed Error

New Contributor

Hi , I am creating a External Table using XML file with SerDe . Table creation was successful , but while selecting getting exception "Bytes consumed error"

Query:

Using Hive View 2.0

ADD JAR hdfs:///user/rprekhi/hivexmlserde-1.0.5.3.jar; select * from iai_rprekhi.fm_test_7;

Table DDL:

ADD JAR hdfs:///user/rprekhi/hivexmlserde-1.0.5.3.jar; CREATE EXTERNAL TABLE fm_test_7( baitSet string, meanExonDepth string, nucleicAcidType string ) ROW FORMAT SERDE 'com.ibm.spss.hive.serde2.xml.XmlSerDe' WITH SERDEPROPERTIES ( "column.xpath.baitSet"="/sample/@bait-set", "column.xpath.meanExonDepth"="/sample/@mean-exon-depth", "column.xpath.nucleicAcidType"="/sample/@nucleic-acid-type" ) STORED AS INPUTFORMAT 'com.ibm.spss.hive.serde2.xml.XmlInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat' LOCATION 'hdfs://d1drlhadoop05.foobar.edu:8020/user/rprekhi/FM' TBLPROPERTIES ( "xmlinput.start"="<sample", "xmlinput.end"="/sample>" );

This is the exception:

 <small>
      org.apache.hive.service.cli.HiveSQLException: java.io.IOException: java.lang.RuntimeException: bytes consumed error!

org.apache.hive.service.cli.HiveSQLException: java.io.IOException: java.lang.RuntimeException: bytes consumed error!
	at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:264)
	at org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:250)
	at org.apache.hive.jdbc.HiveQueryResultSet.next(HiveQueryResultSet.java:373)
	at org.apache.ambari.view.hive20.actor.ResultSetItera...</small>
1 REPLY 1
Highlighted

Re: Bytes Consumed Error

Community Manager

This question was edited prior to posting in order to anonymize potentially sensitive information about the poster's organization.

Bill Brooks, Community Manager
Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.
Don't have an account?
Coming from Hortonworks? Activate your account here