You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "Ravindra Pesala (JIRA)" <ji...@apache.org> on 2017/05/08 17:50:05 UTC
[jira] [Resolved] (CARBONDATA-1002) Results order does not display
same as hive in Carbon data .
[ 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)