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) |
Free forum by Nabble | Edit this page |