carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vandana Yadav (JIRA)" <j...@apache.org>
Subject [jira] [Closed] (CARBONDATA-1028) Null displays while using limit with order by clause in sort_column
Date Mon, 08 May 2017 07:26:04 GMT

     [ 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)

Mime
View raw message