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)