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-586) Create table with 'Char' data type but it workes as 'String' data type
Date Wed, 10 May 2017 07:54:04 GMT

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

Ravindra Pesala resolved CARBONDATA-586.
----------------------------------------
    Resolution: Won't Fix

> Create table with 'Char' data type but it workes as 'String' data type
> ----------------------------------------------------------------------
>
>                 Key: CARBONDATA-586
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-586
>             Project: CarbonData
>          Issue Type: Improvement
>          Components: data-load
>    Affects Versions: 1.0.0-incubating
>         Environment: spark 1.6.2
> spark 2.1
>            Reporter: Anurag Srivastava
>            Assignee: QiangCai
>            Priority: Minor
>
> I am trying to use Char data type with Carbon Data latest version and it created successfully.
When I started loading data in this that time I found that it is taking data more then its
size. 
> I have checked it with hive and there it is working fine.
> EX :- 
> 1. *Carbon Data :* 
> 1.1 create table test_carbon (name char(10)) stored by 'org.apache.carbondata.format';
> 1.2 desc test_carbon;
> *Output :* 
> +-------------+--------------+----------+--+
> | col_name | data_type  | comment   |
> +-------------+--------------+--------------+
> | name        | string         |                  |
> +-------------+--------------+--------------+
> 1.3 LOAD DATA INPATH 'hdfs://localhost:54310/test.csv' into table test_carbon OPTIONS
('FILEHEADER'='name');
> 1.4 select * from test_carbon;
> *Output :* 
> +------------------------+
> |        name               |
> +------------------------+
> | Anurag Srivasrata  |
> | Robert                    |
> | james james           |
> +------------------------+
> 2. *Hive :* 
> 2.1 create table test_hive (name char(10));
> 2.2 desc test_hive;
> *Output :* 
> +-------------+--------------+-------------+
> | col_name | data_type  | comment  |
> +-------------+--------------+-------------+
> | name        | char(10)    | NULL       |
> +-------------+--------------+-------------+
> 2.3 LOAD DATA INPATH 'hdfs://localhost:54310/test.csv' into table test_hive;
> 2.4 select * from test_hive;
> *Output :* 
> +----------------+
> |    name         |
> +----------------+
> | james jame   |
> | Anurag Sri    |
> | Robert          |
> +----------------+
> So as hive truncate remaining string with Char data type in carbon data it should work
like hive.



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

Mime
View raw message