[
https://issues.apache.org/jira/browse/SPARK-21010?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sean Owen resolved SPARK-21010.
-------------------------------
Resolution: Not A Problem
Fix Version/s: (was: 2.1.1)
Target Version/s: (was: 2.1.1)
> Spark-Sql Can't Handle char() type Well
> ----------------------------------------
>
> Key: SPARK-21010
> URL: https://issues.apache.org/jira/browse/SPARK-21010
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 1.6.1, 2.1.0, 2.1.1
> Environment: spark1.6.1 hadoop-2.6.0-cdh5.4.2
> Reporter: fengchaoge
>
> we create table in spark-sql like this :
> 1. create table cid_test (name string,id char(20)) ROW FORMAT DELIMITED
> FIELDS TERMINATED BY ' ' stored as textfile;
> 2. LOAD DATA LOCAL INPATH '/home/hadoop/id.txt' OVERWRITE INTO TABLE
> cid_test;
> content for id.txt:
> fengchaoge 413022199908088888
> 3. select * from cid_test where id='413022199908088888';
> 4. select * from cid_test where id='413022199908088888 ';
> In third step,we got nothing ,but in four step we got the right ring. we must
> add two spaces in id if we want the right value.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
