[
https://issues.apache.org/jira/browse/CARBONDATA-1028?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vandana Yadav closed CARBONDATA-1028.
-------------------------------------
Resolution: Invalid
this bug in not valid any more
> Null displays while using limit with order by clause in sort_column
> -------------------------------------------------------------------
>
> Key: CARBONDATA-1028
> URL: https://issues.apache.org/jira/browse/CARBONDATA-1028
> Project: CarbonData
> Issue Type: Bug
> Components: data-query
> Affects Versions: 1.1.0
> Environment: spark 2.1
> Reporter: Vandana Yadav
> Priority: Minor
> Attachments: newdata.csv
>
>
> Null displays while using limit with order by clause in sort_column
> Steps to reproduced:
> 1) Create table:
> CREATE TABLE sorttable3 (empno int, empname String, designation String, doj
> Timestamp, workgroupcategory int, workgroupcategoryname String, deptno int,
> deptname String, projectcode int, projectjoindate Timestamp, projectenddate
> Timestamp,attendance int,utilization int,salary int) STORED BY
> 'org.apache.carbondata.format' tblproperties('sort_columns'='doj')
> 2) Load data:
> LOAD DATA local inpath 'hdfs://localhost:54310/newdata.csv' INTO TABLE
> sorttable3 OPTIONS('DELIMITER'= ',', 'QUOTECHAR'= '\"');
> 3)Execute Query:
> select doj from sorttable3 order by doj limit 10;
> Actual Result:
> +-------+--+
> | doj |
> +-------+--+
> | NULL |
> | NULL |
> | NULL |
> | NULL |
> | NULL |
> | NULL |
> | NULL |
> | NULL |
> | NULL |
> | NULL |
> +-------+--+
> Expected Result:
> it should display ordered doj as per limit.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
