carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ravindra Pesala (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (CARBONDATA-704) data mismatch between hive and carbondata after loading for bigint values
Date Wed, 10 May 2017 12:12:04 GMT

     [ https://issues.apache.org/jira/browse/CARBONDATA-704?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Ravindra Pesala resolved CARBONDATA-704.
----------------------------------------
       Resolution: Won't Fix
         Assignee:     (was: anubhav tarar)
    Fix Version/s: 1.1.0

> data mismatch between hive and carbondata after loading for bigint values
> -------------------------------------------------------------------------
>
>                 Key: CARBONDATA-704
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-704
>             Project: CarbonData
>          Issue Type: Bug
>          Components: data-load
>    Affects Versions: 1.0.0-incubating
>            Reporter: SWATI RAO
>             Fix For: 1.1.0
>
>         Attachments: Test_Data1 (4).csv
>
>
> carbondata
> 0: jdbc:hive2://localhost:10000> create table Test_Boundary (c1_int int,c2_Bigint
Bigint,c3_Decimal Decimal(38,30),c4_double double,c5_string string,c6_Timestamp Timestamp,c7_Datatype_Desc
string) STORED BY 'org.apache.carbondata.format' ;
> 0: jdbc:hive2://localhost:10000>  LOAD DATA INPATH 'hdfs://localhost:54310/Test_Data1.csv'
INTO table Test_Boundary OPTIONS                            ('DELIMITER'=',','QUOTECHAR'='','BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='');
> 0: jdbc:hive2://localhost:10000> select c2_Bigint from Test_Boundary;
> +----------------------+--+
> |      c2_Bigint       |
> +----------------------+--+
> | NULL                 |
> | NULL                 |
> | NULL                 |
> | 9223372036854775807  |
> | 9223372036854775807  |
> | 9223372036854775807  |
> | 9223372036854775807  |
> | 9223372036854775807  |
> | 9223372036854775807  |
> | 9223372036854775807  |
> | 9223372036854775807  |
> | 9223372036854775807  |
> | 9223372036854775807  |
> | 9223372036854775807  |
> | 9223372036854775807  |
> | 9223372036854775807  |
> +----------------------+--+
> but in hive
> create table Test_Boundary_hive (c1_int int,c2_Bigint Bigint,c3_Decimal Decimal(38,30),c4_double
double,c5_string string,c6_Timestamp Timestamp,c7_Datatype_Desc string)  ROW FORMAT DELIMITED
FIELDS TERMINATED BY ",";
> LOAD DATA LOCAL INPATH 'Test_Data1.csv' into table Test_Boundary_hive;
> select c2_Bigint from Test_Boundary_hive;
> +-----------------------+--+
> |       c2_Bigint       |
> +-----------------------+--+
> | 1234                  |
> | 2345                  |
> | 3456                  |
> | 4567                  |
> | 9223372036854775807   |
> | -9223372036854775808  |
> | -9223372036854775807  |
> | -9223372036854775806  |
> | -9223372036854775805  |
> | 0                     |
> | 9223372036854775807   |
> | 9223372036854775807   |
> | 9223372036854775807   |
> | NULL                  |
> | NULL                  |
> | NULL                  |
> +-----------------------+--+



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message