Vandana Yadav created CARBONDATA-1028:
-----------------------------------------
Summary: 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)
