[
https://issues.apache.org/jira/browse/CARBONDATA-1670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vandana Yadav closed CARBONDATA-1670.
-------------------------------------
Resolution: Fixed
this issue is resolved with https://github.com/apache/carbondata/pull/1486 PR.
> Incorrect result displays while select query on presto CLI after recreating a
> table.
> ------------------------------------------------------------------------------------
>
> 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 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)
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
