[
https://issues.apache.org/jira/browse/CARBONDATA-1094?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ravindra Pesala resolved CARBONDATA-1094.
-----------------------------------------
Resolution: Fixed
> Wrong results returned by the query in case inverted index is not created on a column
> -------------------------------------------------------------------------------------
>
> Key: CARBONDATA-1094
> URL:
https://issues.apache.org/jira/browse/CARBONDATA-1094> Project: CarbonData
> Issue Type: Bug
> Reporter: Manish Gupta
> Assignee: Manish Gupta
> Fix For: 1.2.0
>
> Time Spent: 1h
> Remaining Estimate: 0h
>
> While creating a table if a column is not specified as sort column or included as no inverted index then the column will not be sorted during data load. Unsorted data will have incorrect min/max values and inverted index will not be created for that column.
> During query, if filter exists for that column it gives incorrect results as binary search cannot be applied on the unsorted data.
> Commands to reproduce
> -----------------------------------------
> CREATE TABLE IF NOT EXISTS index1 (id Int, name String, city String) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('NO_INVERTED_INDEX'='name,city', 'DICTIONARY_EXCLUDE'='city')
> LOAD DATA LOCAL INPATH '<csv file path>' into table index1
> SELECT * FROM index1 WHERE city >= 'Shanghai'
> +---+------+----------+
> | id| name| city|
> +---+------+----------+
> | 11| James|Washington|
> | 5| John| Beijing|
> | 20| Kevin| Singapore|
> | 17| Lisa| Hangzhou|
> | 12| Maria| Berlin|
> | 2| Mark| Paris|
> | 9| Mary| Tokyo|
> | 6|Michel| Chicago|
> | 16| Paul| Shanghai|
> | 14| Peter| Boston|
> | 7|Robert| Houston|
> | 4| Sara| Tokyo|
> | 8| Sunny| Boston|
> +---+------+----------+
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
Locked
