[jira] [Created] (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] [Created] (CARBONDATA-4211) from xx Insert into select fails if an SQL statement contains multiple inserts

Akash R Nilugal (Jira)
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)