Support Questions

Find answers, ask questions, and share your expertise
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

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"


Using Hive View 2.0

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

Table DDL:

ADD JAR hdfs:///user/rprekhi/hivexmlserde-; CREATE EXTERNAL TABLE fm_test_7( baitSet string, meanExonDepth string, nucleicAcidType string ) ROW FORMAT SERDE '' 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 '' OUTPUTFORMAT '' LOCATION 'hdfs://' TBLPROPERTIES ( "xmlinput.start"="<sample", "xmlinput.end"="/sample>" );

This is the exception:

      org.apache.hive.service.cli.HiveSQLException: java.lang.RuntimeException: bytes consumed error!

org.apache.hive.service.cli.HiveSQLException: java.lang.RuntimeException: bytes consumed error!
	at org.apache.hive.jdbc.Utils.verifySuccess(
	at org.apache.hive.jdbc.Utils.verifySuccessWithInfo(

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

Bill Brooks, Community Moderator
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.
Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.