PRIYESH RANJAN created CARBONDATA-4309:
------------------------------------------

             Summary: insertion with String datatype fails from Presto 333 
session
                 Key: CARBONDATA-4309
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-4309
             Project: CarbonData
          Issue Type: Bug
          Components: data-load
    Affects Versions: 2.2.0
         Environment: Presto 333
            Reporter: PRIYESH RANJAN


+*Issue 1 :- insertion of String datatype fails in presto session.*+

Queries executed from spark sql/beeline - 

drop table if exists testorders5;
CREATE TABLE testorders5(orderkey bigint, orderstatus string, totalprice 
double, orderdate date) stored as carbondata;

Queries executed from Presto cli - 


INSERT INTO testorders5 VALUES(10,'SUCCESS', 125.15, DATE'2019-05-17');


presto:ranj> INSERT INTO testorders5 VALUES(10,'SUCCESS', 125.15, 
DATE'2019-05-17');
Query 20211025_041358_00019_7gfn9, FAILED, 1 node
Splits: 51 total, 33 done (64.71%)
0:00 [0 rows, 0B] [0 rows/s, 0B/s]
Query 20211025_041358_00019_7gfn9 failed: java.lang.RuntimeException: 
java.util.concurrent.ExecutionException: java.lang.RuntimeException: 
org.apache.carbondata.processing.loading.exception.CarbonDataLoadingException: 
Error while initializing data handler :

 

+*Issue 2 :- drop table/database fail in spark session after insertion with 
String datatype fails in presto cli*+

Queries executed from spark sql/beeline - 


create database if not exists ranjan;
use ranjan;
drop table if exists testorders5;
CREATE TABLE testorders5(orderkey bigint, orderstatus string, totalprice 
double, orderdate date) stored as carbondata;

 

Queries executed from Presto cli - 
INSERT INTO testorders5 VALUES(10,'SUCCESS', 125.15, DATE'2019-05-17');

 

Queries executed from spark sql/beeline - 
drop table if exists testorders5;
drop database if exists ranjan cascade;



0: jdbc:hive2://10.20.255.153:23040/default> drop table if exists testorders5;
Error: org.apache.carbondata.core.exception.ConcurrentOperationException: 
loading is in progress for table ranj.testorders5, drop table operation is not 
allowed (state=,code=0)



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to