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

Posted by Akash R Nilugal (Jira) on Jun 15, 2021; 3:06pm
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/jira-Created-CARBONDATA-4211-from-xx-Insert-into-select-fails-if-an-SQL-statement-contains-multiple-s-tp108924.html

SHREELEKHYA GAMPA created CARBONDATA-4211:
---------------------------------------------

             Summary: 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


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)