You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@carbondata.apache.org by "Vinod Rohilla (JIRA)" <ji...@apache.org> on 2017/04/27 11:08:04 UTC
[jira] [Created] (CARBONDATA-1002) Results order does not display
same as hive in Carbon data .
Vinod Rohilla created CARBONDATA-1002:
-----------------------------------------
Summary: 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)