carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ravindra Pesala (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (CARBONDATA-1002) Results order does not display same as hive in Carbon data .
Date Mon, 08 May 2017 17:50:05 GMT

     [ https://issues.apache.org/jira/browse/CARBONDATA-1002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Ravindra Pesala resolved CARBONDATA-1002.
-----------------------------------------
    Resolution: Duplicate

duplicated to 
https://issues.apache.org/jira/browse/CARBONDATA-1010

> Results order does not display same as hive in Carbon data . 
> -------------------------------------------------------------
>
>                 Key: CARBONDATA-1002
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-1002
>             Project: CarbonData
>          Issue Type: Bug
>          Components: data-query
>         Environment: Spark 2.1
>            Reporter: Vinod Rohilla
>            Priority: Minor
>         Attachments: Employee1.csv, Result.png
>
>
> Result order does not display same as hive in Carbondata.
> Steps to reproduces:
> 1: CARBONDATA:
> a):Create table in CarbonData
> create table employee (Id int,Name String,Salary int,Designation String,Dept String)
STORED BY 'org.apache.carbondata.format';
> b):Load data in table
> LOAD DATA INPATH 'hdfs://localhost:54310/Employee1.csv' into table employee;
> c): select * from employee;
> +----------+-------+----------+------------------------+----------------------------+--+
> |    Id    | Name  |  Salary  |      Designation       |            Dept            |
> +----------+-------+----------+------------------------+----------------------------+--+
> | 1000001  | Zoe   | 8567816  | J BUSH & CO            | Warehouse/Equipment Agent
 |
> | 900001   | Zoe   | 6380353  | J C MALONE ASSOCIATES  | Water Services Technician  |
> | 800001   | Zoe   | 2937793  | J C P & L CO           | Websphere Consultant   
   |
> | 700001   | Zoe   | 9237710  | J C PENNEY             | Wedding Consultant         |
> | 600001   | Zoe   | 2663980  | J C PENNEY CO          | Wedding Coordinator        |
> | 500001   | Zoe   | 6355842  | J C PENNEY CO INC      | Wedding Sales Manager      |
> | 400001   | Zoe   | 3966825  | J C PENNEY COMPANY     | Weight Loss Consultant     |
> | 300001   | Zoe   | 7679689  | J D CHADNEY MD         | Welder                     |
> | 200001   | Zoe   | 9589193  | J DOMANISH ARCHT       | Welding Engineer           |
> | 100001   | Zoe   | 7958183  | J F K HIGH SCHOOL      | Wheelchair agent           |
> | 1        | Zoe   | 3640571  | J GRAHAM BROWN CANCER  | Yachting                   |
> +----------+-------+----------+------------------------+----------------------------+--+
> 2:HIVE
> a):Create table in CarbonData
> create table employeeH (Id int,Name String,Salary int,Designation String,Dept String)
ROW FORMAT DELIMITED FIELDS TERMINATED BY ",";
> b):Load data in table
> LOAD DATA LOCAL INPATH '/home/vinod/Desktop/AllCSV/Employee1.csv'OVERWRITE INTO TABLE
employeeH;
> c: select * from employeeH;
> +----------+-------+----------+------------------------+----------------------------+--+
> |    Id    | Name  |  Salary  |      Designation       |            Dept            |
> +----------+-------+----------+------------------------+----------------------------+--+
> | 1        | Zoe   | 3640571  | J GRAHAM BROWN CANCER  | Yachting                   |
> | 100001   | Zoe   | 7958183  | J F K HIGH SCHOOL      | Wheelchair agent           |
> | 200001   | Zoe   | 9589193  | J DOMANISH ARCHT       | Welding Engineer           |
> | 300001   | Zoe   | 7679689  | J D CHADNEY MD         | Welder                     |
> | 400001   | Zoe   | 3966825  | J C PENNEY COMPANY     | Weight Loss Consultant     |
> | 500001   | Zoe   | 6355842  | J C PENNEY CO INC      | Wedding Sales Manager      |
> | 600001   | Zoe   | 2663980  | J C PENNEY CO          | Wedding Coordinator        |
> | 700001   | Zoe   | 9237710  | J C PENNEY             | Wedding Consultant         |
> | 800001   | Zoe   | 2937793  | J C P & L CO           | Websphere Consultant   
   |
> | 900001   | Zoe   | 6380353  | J C MALONE ASSOCIATES  | Water Services Technician  |
> | 1000001  | Zoe   | 8567816  | J BUSH & CO            | Warehouse/Equipment Agent
 |
> +----------+-------+----------+------------------------+----------------------------+--+



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message