[
https://issues.apache.org/jira/browse/CARBONDATA-1002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vinod Rohilla closed CARBONDATA-1002.
-------------------------------------
Issue Closed
> 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.4.14#64029)
