Details
-
Bug
-
Status: Open
-
Minor
-
Resolution: Unresolved
-
2.2.0
-
None
-
None
-
Presto 333
Description
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)