[CARBONDATA-1670] Incorrect result displays while select query on presto CLI after recreating a table.

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.3.0
• Component/s: data-query
• Environment: spark 2.1
• Assignee: Unassigned
• Reporter: Vandana Yadav
• Created: 06/Nov/17 11:11
• Updated: 24/Nov/17 07:21
• Resolved: 24/Nov/17 07:21

Description

Incorrect result displays while select query on presto CLI after recreating a table.
Steps to reproduce:
On Beeline:
1) Create Table:
CREATE TABLE list_partition_table_short(intField INT, bigintField LONG, doubleField DOUBLE, stringField STRING, timestampField TIMESTAMP, decimalField DECIMAL(18,2), dateField DATE, charField CHAR(5), floatField FLOAT) PARTITIONED BY (shortField SHORT) STORED BY 'carbondata' TBLPROPERTIES('PARTITION_TYPE'='LIST', 'LIST_INFO'='10,20,30');

2)Load Data:
load data inpath 'hdfs://localhost:54310/Data/partition_table.csv' into table list_partition_table_short options('FILEHEADER'='shortfield,intfield,bigintfield,doublefield,stringfield,timestampfield,decimalfield,datefield,charfield,floatfield');

3) Execute select Query:
select * from list_partition_table_short;

Output:

--------------------------------------------------------------------------------------------------------------------------------

intField

bigintField

doubleField

stringField

timestampField

decimalField

dateField

charField

floatField

shortField

--------------------------------------------------------------------------------------------------------------------------------

19	109	1009.0	HashPartition	NULL	19.25	NULL	W	109.01	10
11	101	1001.0	HashPartition	NULL	11.25	NULL	Z	101.01	2
21	111	1011.0	HashPartition	NULL	21.25	NULL	Z	111.01	12
10	100	1000.0	ListPartition	NULL	10.25	NULL	A	100.01	1
22	112	1012.0	ListPartition	NULL	22.25	NULL	F	112.01	13
23	113	1013.0	ListPartition	NULL	23.25	NULL	M	113.01	14
16	106	1006.0	ListPartition	NULL	16.25	NULL	Y	106.01	7
12	102	1002.0	NoPartition	NULL	12.25	NULL	F	102.01	3
15	105	1005.0	NoPartition	NULL	15.25	NULL	K	105.01	6
20	110	1010.0	NoPartition	NULL	20.25	NULL	K	110.01	11
18	108	1008.0	RangeIntervalPartition	NULL	18.25	NULL	A	108.01	9
14	104	1004.0	RangePartition	NULL	14.25	NULL	L	104.01	5
13	103	1003.0	RangePartition	NULL	13.25	NULL	M	103.01	4
17	107	1007.0	RangePartition	NULL	17.25	NULL	T	107.01	8

--------------------------------------------------------------------------------------------------------------------------------

Start presto server:
bin/launcher run

run presto CLI:
./presto --server localhost:9000 --catalog carbondata --schema newpresto

On Presto CLI:
1)Execute Queries:
a) show tables;
b) select * from list_partition_table_short;

Output: same as beeline.

intfield | bigintfield | doublefield | stringfield | timestampfield | decimalfield | datefield | charfield | floatfield | shortfield
-----------------------------------------------------------------------------------------------------------+-----------
11 | 101 | 1001.0 | HashPartition | NULL | 11.25 | NULL | Z | 101.01 | 2
21 | 111 | 1011.0 | HashPartition | NULL | 21.25 | NULL | Z | 111.01 | 12
10 | 100 | 1000.0 | ListPartition | NULL | 10.25 | NULL | A | 100.01 | 1
22 | 112 | 1012.0 | ListPartition | NULL | 22.25 | NULL | F | 112.01 | 13
23 | 113 | 1013.0 | ListPartition | NULL | 23.25 | NULL | M | 113.01 | 14
16 | 106 | 1006.0 | ListPartition | NULL | 16.25 | NULL | Y | 106.01 | 7
12 | 102 | 1002.0 | NoPartition | NULL | 12.25 | NULL | F | 102.01 | 3
15 | 105 | 1005.0 | NoPartition | NULL | 15.25 | NULL | K | 105.01 | 6
20 | 110 | 1010.0 | NoPartition | NULL | 20.25 | NULL | K | 110.01 | 11
18 | 108 | 1008.0 | RangeIntervalPartition | NULL | 18.25 | NULL | A | 108.01 | 9
14 | 104 | 1004.0 | RangePartition | NULL | 14.25 | NULL | L | 104.01 | 5
13 | 103 | 1003.0 | RangePartition | NULL | 13.25 | NULL | M | 103.01 | 4
17 | 107 | 1007.0 | RangePartition | NULL | 17.25 | NULL | T | 107.01 | 8
19 | 109 | 1009.0 | HashPartition | NULL | 19.25 | NULL | W | 109.01 | 10
(14 rows)

Now On beeline drop the table and recreate it using same commands as described and after recreating run the select query on it in presto CLI.(don't restart the server)

Output:

1)Expected Result: it should display the same result as on beeline.

2)Actual result:

intfield | bigintfield | doublefield | stringfield | timestampfield | decimalfield | datefield | charfield | floatfield | shortfield
------------------------------------------------------------------------------------------------+-----------
(0 rows)