[
https://issues.apache.org/jira/browse/CARBONDATA-4211?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Akash R Nilugal resolved CARBONDATA-4211.
-----------------------------------------
Fix Version/s: 2.2.0
Resolution: Fixed
> from xx Insert into select fails if an SQL statement contains multiple inserts
> ------------------------------------------------------------------------------
>
> Key: CARBONDATA-4211
> URL: https://issues.apache.org/jira/browse/CARBONDATA-4211
> Project: CarbonData
> Issue Type: Bug
> Reporter: SHREELEKHYA GAMPA
> Priority: Major
> Fix For: 2.2.0
>
> Time Spent: 1h 40m
> Remaining Estimate: 0h
>
> When multiple inserts with single query is used, it fails from SparkPlan
> with: {{java.lang.ClassCastException: GenericInternalRow cannot be cast to
> UnsafeRow}}.
> [Steps] :-
> From Spark SQL execute the following queries
> 1、create tables：
> create table catalog_returns_5(cr_returned_date_sk int,cr_returned_time_sk
> int,cr_item_sk int)ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES
> TERMINATED BY '\n' ;
> create table catalog_returns_6(cr_returned_time_sk int,cr_item_sk int)
> partitioned by (cr_returned_date_sk int) STORED BY
> 'org.apache.carbondata.format' TBLPROPERTIES ( 'table_blocksize'='64');
> 2、insert table：
> from catalog_returns_5 insert overwrite table catalog_returns_6 partition
> (cr_returned_date_sk) select cr_returned_time_sk, cr_item_sk,
> cr_returned_date_sk where cr_returned_date_sk is not null distribute by
> cr_returned_date_sk insert overwrite table catalog_returns_6 partition
> (cr_returned_date_sk) select cr_returned_time_sk, cr_item_sk,
> cr_returned_date_sk where cr_returned_date_sk is null distribute by
> cr_returned_date_sk;
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
