hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vineet Garg (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-20910) Insert in bucketed table fails due to dynamic partition sort optimization
Date Tue, 13 Nov 2018 23:41:00 GMT

     [ https://issues.apache.org/jira/browse/HIVE-20910?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Vineet Garg updated HIVE-20910:
-------------------------------
    Status: Open  (was: Patch Available)

> Insert in bucketed table fails due to dynamic partition sort optimization
> -------------------------------------------------------------------------
>
>                 Key: HIVE-20910
>                 URL: https://issues.apache.org/jira/browse/HIVE-20910
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 4.0.0
>            Reporter: Vineet Garg
>            Assignee: Vineet Garg
>            Priority: Major
>         Attachments: HIVE-20910.1.patch, HIVE-20910.2.patch
>
>
> *Repro*
> {code:sql}
> CREATE TABLE tbl_lbodor_1 (ca_address_sk int, ca_address_id string, ca_street_number
string, ca_street_name string,
>     ca_street_type string, ca_suite_number string, ca_city string, ca_county string,
ca_state string,
>     ca_zip string, ca_country string, ca_gmt_offset decimal(5,2))
>     PARTITIONED BY (ca_location_type string)
>     CLUSTERED BY (ca_state) INTO 50 BUCKETS STORED AS ORC TBLPROPERTIES('transactional'='true');
> INSERT INTO TABLE tbl_lbodor_1 PARTITION (ca_location_type) VALUES (5555, 'AAAAAAAADLFBAAAA',
'126',
>                 'Highland Park', 'Court', 'Suite E', 'San Jose', 'King George County',
'VA', '28003', 'United States',
>                 '-5', 'single family');
> {code}
> {noformat}
> Caused by: java.lang.ClassCastException: org.apache.hadoop.hive.ql.exec.vector.Decimal64ColumnVector
cannot be cast to org.apache.hadoop.hive.ql.exec.vector.BytesColumnVector
> 	at org.apache.hadoop.hive.ql.io.orc.WriterImpl.setColumn(WriterImpl.java:184)
> 	at org.apache.hadoop.hive.ql.io.orc.WriterImpl.setColumn(WriterImpl.java:237)
> 	at org.apache.hadoop.hive.ql.io.orc.WriterImpl.addRow(WriterImpl.java:308)
> 	at org.apache.hadoop.hive.ql.io.orc.OrcRecordUpdater.addSimpleEvent(OrcRecordUpdater.java:423)
> 	at org.apache.hadoop.hive.ql.io.orc.OrcRecordUpdater.addSplitUpdateEvent(OrcRecordUpdater.java:431)
> 	at org.apache.hadoop.hive.ql.io.orc.OrcRecordUpdater.insert(OrcRecordUpdater.java:483)
> 	at org.apache.hadoop.hive.ql.exec.FileSinkOperator.process(FileSinkOperator.java:995)
> 	at org.apache.hadoop.hive.ql.exec.vector.VectorFileSinkOperator.process(VectorFileSinkOperator.java:111)
> 	at org.apache.hadoop.hive.ql.exec.Operator.vectorForward(Operator.java:965)
> 	at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:938)
> 	at org.apache.hadoop.hive.ql.exec.vector.VectorSelectOperator.process(VectorSelectOperator.java:158)
> 	at org.apache.hadoop.hive.ql.exec.tez.ReduceRecordSource.processVectorGroup(ReduceRecordSource.java:490)
> 	... 20 more
> {noformat}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message