Justin Leet created HIVE-21861: ---------------------------------- Summary: ClassCastException during CTAS over external table using KafkaStorageHandler Key: HIVE-21861 URL: https://issues.apache.org/jira/browse/HIVE-21861 Project: Hive Issue Type: Bug Components: kafka integration Affects Versions: 0.3.0 Reporter: Justin Leet
To reproduce, create a table similar to the following: {code} CREATE EXTERNAL TABLE <table> (raw_value STRING) ROW FORMAT DELIMITED LINES TERMINATED BY '\n' STORED BY 'org.apache.hadoop.hive.kafka.KafkaStorageHandler' TBLPROPERTIES( "kafka.topic"="<kafka_topic>", "kafka.bootstrap.servers"="<bootstrap_servers>", "kafka.consumer.security.protocol"="PLAINTEXT", "kafka.serde.class"="org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe"); {code} Note the SerDe isn't the default SerDe. Additionally, this error occurs when vectorization is enabled. Basic queries work fine: {code} SELECT * FROM <table> LIMIT 1; {code} Doing a CTAS to bring it into a managed table fails: {code} CREATE TABLE <managed_table> AS SELECT * FROM <table>; {code} The exception is: {code} Caused by: java.lang.ClassCastException: org.apache.hadoop.hive.serde2.lazy.LazyString cannot be cast to org.apache.hadoop.io.TextCaused by: java.lang.ClassCastException: org.apache.hadoop.hive.serde2.lazy.LazyString cannot be cast to org.apache.hadoop.io.Text at org.apache.hadoop.hive.ql.exec.vector.VectorAssignRow.assignRowColumn(VectorAssignRow.java:471) at org.apache.hadoop.hive.ql.exec.vector.VectorAssignRow.assignRowColumn(VectorAssignRow.java:350) at org.apache.hadoop.hive.kafka.VectorizedKafkaRecordReader.readNextBatch(VectorizedKafkaRecordReader.java:159) at org.apache.hadoop.hive.kafka.VectorizedKafkaRecordReader.next(VectorizedKafkaRecordReader.java:113) at org.apache.hadoop.hive.kafka.VectorizedKafkaRecordReader.next(VectorizedKafkaRecordReader.java:47) at org.apache.hadoop.hive.ql.io.HiveContextAwareRecordReader.doNext(HiveContextAwareRecordReader.java:360) ... 24 more {code} A workaround to this is to disable vectorization via: {code} set hive.vectorized.execution.enabled = false; {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)