Fwd: MODERATE for dev@carbondata.apache.org

[Liang Chen <ch...@apache.org>]

First please send one mail to dev-subscribe@carbondata.apache.org
<de...@carbondata.incubator.apache.org> for joining mailing list
group.

After you join mailing list group, please send your question again to
dev@carbondata.apache.org <de...@carbondata.incubator.apache.org>

Regards

Liang

---------- Forwarded message ----------
From: <dev-reject-1494938369.5501.haapkammcpepkpmplkgj@carbondata.apache.org
>
Date: 2017-05-16 8:39 GMT-04:00
Subject: MODERATE for dev@carbondata.apache.org
To:
Cc: dev-allow-tc.1494938369.fmjhmojidcndippkammh-vinod=
knoldus.in@carbondata.apache.org



To approve:
   dev-accept-1494938369.5501.haapkammcpepkpmplkgj@carbondata.apache.org
To reject:
   dev-reject-1494938369.5501.haapkammcpepkpmplkgj@carbondata.apache.org
To give a reason to reject:
%%% Start comment
%%% End comment



---------- 已转发邮件 ----------
From: vin7149 <vi...@knoldus.in>
To: dev@carbondata.apache.org
Cc:
Bcc:
Date: Tue, 16 May 2017 05:39:27 -0700 (MST)
Subject: White Space does not trim in CarbonData
Hi Community,

I have a create a table in hive and same in CarbonData, In my CSV there is
whitespace after the data which is working fine in hive table whereas it
shows null in CarbonData table.

*In Hive*

1: Table created in Hive

create table my_user(id int, name string, address1 string, address2
string,salary double, incentive int)ROW FORMAT DELIMITED FIELDS TERMINATED
BY ",";

2: Load Data in table

LOAD DATA LOCAL INPATH '/home/vinod/Downloads/my_user2.csv' OVERWRITE INTO
TABLE my_user;

3: Select Query on hive

0: jdbc:hive2://localhost:10000> select * from my_user;
+-----+-----------+-----------+-----------+----------+------------+--+
| id  |   name    | address1  | address2  |  salary  | incentive  |
+-----+-----------+-----------+-----------+----------+------------+--+
| 1   | 'katy'    | 'london'  | 'UK'      | 5000.0   | 5000       |
| 2   | 'John'    | 'goa'     | 'goa'     | 12000.0  | 500        |
| 3   | 'Rachel'  | 'goa'     | 'goa'     | 10000.0  | 1000       |
+-----+-----------+-----------+-----------+----------+------------+--+
3 rows selected (0.122 seconds)

*In Carbon*

1: Create Table in Carbon

create table my_user_c(id int, name string, address1 string, address2
string,salary double, incentive int) stored by 'carbondata';

2: Load Data in table

load data inpath 'hdfs://localhost:54310/my_user2.csv' into table my_user_c;

3: Select Query on carbon

0: jdbc:hive2://localhost:10000> select * from my_user_c;
+-----+-----------+-----------+-----------+----------+------------+--+
| id  |   name    | address1  | address2  |  salary  | incentive  |
+-----+-----------+-----------+-----------+----------+------------+--+
| 2   | 'John'    | 'goa'     | 'goa'     | 12000.0  | 500        |
| 3   | 'Rachel'  | 'goa'     | 'goa'     | 10000.0  | NULL      |
| 1   | 'katy'    | 'london'  | 'UK'      | 5000.0   | 5000       |
+-----+-----------+-----------+-----------+----------+------------+--+
3 rows selected (0.193 seconds)


it should display 1000 instead of NULL value in CarbonData.




--
View this message in context: http://apache-carbondata-dev-
mailing-list-archive.1130556.n5.nabble.com/White-Space-
does-not-trim-in-CarbonData-tp12736.html
Sent from the Apache CarbonData Dev Mailing List archive mailing list
archive at Nabble.com.