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)

Reply via email to