[jira] [Created] (CARBONDATA-1002) Results order does not display same as hive in Carbon data .

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (CARBONDATA-1002) Results order does not display same as hive in Carbon data .

Akash R Nilugal (Jira)
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)