[jira] [Resolved] (CARBONDATA-4211) from xx Insert into select fails if an SQL statement contains multiple inserts

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Resolved] (CARBONDATA-4211) from xx Insert into select fails if an SQL statement contains multiple inserts

Akash R Nilugal (Jira)

     [ 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)