Hi, I have a table created by the following query
CREATE EXTERNAL TABLE IF NOT EXISTS partition_table (partkey STRING) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.binarysortable.BinarySortableSerDe' STORED AS INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveNullValueSequenceFileOutputFormat' LOCATION '<some location>' Whenever I am trying to count the number of rows in the table (using select count * from partition_table) I am getting the following exception : java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error while processing writable SEQ $org.apache.hadoop.hive.ql.io.HiveKey!org.apache.hadoop.io.NullWritable at org.apache.hadoop.hive.ql.exec.ExecMapper.map(ExecMapper.java:161) at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:50) at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:418) at org.apache.hadoop.mapred.MapTask.run(MapTask.java:333) at org.apache.hadoop.mapred.Child$4.run(Child.java:268) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:415) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1408) at org.apache.hadoop.mapred.Child.main(Child.java:262) Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error while processing writable SEQ $org.apache.hadoop.hive.ql.io.HiveKey!org.apache.hadoop.io.NullWritable at org.apache.hadoop.hive.ql.exec.MapOperator.process(MapOperator.java:539) at org.apache.hadoop.hive.ql.exec.ExecMapper.map(ExecMapper.java:143) ... 8 more Caused by:* java.lang.ClassCastException: org.apache.hadoop.io.Text cannot be cast to org.apache.hadoop.io.BytesWritable* * at org.apache.hadoop.hive.serde2.binarysortable.BinarySortableSerDe.deserialize(BinarySortableSerDe.java:172)* at org.apache.hadoop.hive.ql.exec.MapOperator.process(MapOperator.java:523) Please advise on what I should do. I am not sure why this query is failing. Thanks -- Thanks Vaibhav Jain
