[jira] [Comment Edited] (HIVE-21861) ClassCastException during CTAS over external table using KafkaStorageHandler

["Rajkumar Singh (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-21861?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16881737#comment-16881737 ] 

Rajkumar Singh edited comment on HIVE-21861 at 7/10/19 5:24 AM:
----------------------------------------------------------------

I noticed that for column raw_value LazySimpleSerDe create primitive object Inspector (LazyStringObjectInspector) since column type is a string.

https://github.com/apache/hive/blob/8a606abdec0f92d60653d892b2f92ff729f1c020/serde/src/java/org/apache/hadoop/hive/serde2/lazy/LazyFactory.java#L435


{code:java}
objectInspector = ObjectInspectorFactory.getStandardStructObjectInspector(columnNames, inspectors);
{code}
objectInspector has the same LazyStringObjectInspector with other inspectors for other kafka meta columns. 
so it's seem objectInspector are expected?



was (Author: rajkumar singh):
I noticed that for column raw_value LazySimpleSerDe create primitive object Inspector (LazyStringObjectInspector) since column type is a string.

https://github.com/apache/hive/blob/8a606abdec0f92d60653d892b2f92ff729f1c020/serde/src/java/org/apache/hadoop/hive/serde2/lazy/LazyFactory.java#L435


{code:java}
objectInspector = ObjectInspectorFactory.getStandardStructObjectInspector(columnNames, inspectors);
{code}
objectInspector has the same LazyStringObjectInspector with other inspectors for other kafka meta columns. 


> 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: 4.0.0
>            Reporter: Justin Leet
>            Assignee: Rajkumar Singh
>            Priority: Major
>         Attachments: HIVE-21861.patch
>
>
> 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)