[jira] [Created] (CARBONDATA-1028) Null displays while using limit with order by clause in sort_column

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (CARBONDATA-1028) Null displays while using limit with order by clause in sort_column

Akash R Nilugal (Jira)
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)