Vandana Yadav created CARBONDATA-1670:
-----------------------------------------
Summary: Incorrect result displays while select query after
recreating a table on presto CLI
Key: CARBONDATA-1670
URL: https://issues.apache.org/jira/browse/CARBONDATA-1670
Project: CarbonData
Issue Type: Bug
Components: data-query
Affects Versions: 1.3.0
Environment: spark 2.1
Reporter: Vandana Yadav
Priority: Minor
Attachments: partition_table.csv
Incorrect result displays while select query after recreating a table on presto
CLI
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)
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
