Chetan Bhat created CARBONDATA-4135:
---------------------------------------
Summary: insert in partition table should fail from presto side
but insert into select * in passing in partition table with single column
partition table from presto side
Key: CARBONDATA-4135
URL: https://issues.apache.org/jira/browse/CARBONDATA-4135
Project: CarbonData
Issue Type: Bug
Components: presto-integration
Affects Versions: 2.1.0
Environment: Spark 2.4.5, Presto 316
Reporter: Chetan Bhat
Presto 316 version used.
*Steps :-*
>From Spark beeline execute the queries -
0: jdbc:hive2://10.20.254.208:23040/default> drop table
uniqdata_Partition_single;
+---------+
| Result |
+---------+
+---------+
No rows selected (0.454 seconds)
0: jdbc:hive2://10.20.254.208:23040/default> CREATE TABLE
uniqdata_Partition_single (CUST_ID int,CUST_NAME String, DOB timestamp, DOJ
timestamp, BIGINT_COLUMN1 bigint,BIGINT_COLUMN2 bigint,DECIMAL_COLUMN1
decimal(30,10), DECIMAL_COLUMN2 decimal(36,36),Double_COLUMN1 double,
Double_COLUMN2 double,INTEGER_COLUMN1 int) partitioned by (ACTIVE_EMUI_VERSION
string)stored as carbondata
tblproperties('COLUMN_META_CACHE'='CUST_ID,CUST_NAME,DECIMAL_COLUMN2,DOJ,Double_COLUMN2,BIGINT_COLUMN2','local_dictionary_enable'='true','local_dictionary_threshold'='1000','local_dictionary_include'='ACTIVE_EMUI_VERSION')
;
+---------+
| Result |
+---------+
+---------+
No rows selected (0.202 seconds)
0: jdbc:hive2://10.20.254.208:23040/default> LOAD DATA INPATH
'hdfs://hacluster/chetan/2000_UniqData_partition.csv' into table
uniqdata_Partition_single OPTIONS('FILEHEADER'='CUST_ID,CUST_NAME
,ACTIVE_EMUI_VERSION,DOB,DOJ,
BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,
Double_COLUMN2,INTEGER_COLUMN1','BAD_RECORDS_ACTION'='FORCE');
+---------+
| Result |
+---------+
+---------+
No rows selected (3.471 seconds)
0: jdbc:hive2://10.20.254.208:23040/default>
>From prestocli the query is executed -
presto:ranjan> insert into uniqdata_Partition_single select * from
uniqdata_Partition_single;
*Issue : - insert in partition table should fail from presto side but insert
into select * in passing in partition table with single column partition table
from presto side.*
presto:ranjan> insert into uniqdata_Partition_single select * from
uniqdata_Partition_single;
INSERT: 2002 rows
Query 20210223_044320_00000_ggkxh, FINISHED, 1 node
Splits: 45 total, 45 done (100.00%)
0:05 [2K rows, 206KB] [431 rows/s, 44.4KB/s]
presto:ranjan> desc uniqdata_Partition_single;
Column | Type | Extra | Comment
---------------------+----------------+---------------+---------
cust_id | integer | |
cust_name | varchar | |
dob | timestamp | |
doj | timestamp | |
bigint_column1 | bigint | |
bigint_column2 | bigint | |
decimal_column1 | decimal(30,10) | |
decimal_column2 | decimal(36,36) | |
double_column1 | double | |
double_column2 | double | |
integer_column1 | integer | |
active_emui_version | varchar | partition key |
(12 rows)
Query 20210223_044344_00001_ggkxh, FINISHED, 1 node
Splits: 19 total, 19 done (100.00%)
0:00 [12 rows, 1.07KB] [50 rows/s, 4.53KB/s]
presto:ranjan>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
