You are viewing a plain text version of this content. The canonical link for it is here.
Posted to common-dev@hadoop.apache.org by "Namit Jain (JIRA)" <ji...@apache.org> on 2008/09/24 19:33:44 UTC
[jira] Created: (HADOOP-4265) [Hive] error when user specifies the
delimiter
[Hive] error when user specifies the delimiter
----------------------------------------------
Key: HADOOP-4265
URL: https://issues.apache.org/jira/browse/HADOOP-4265
Project: Hadoop Core
Issue Type: Bug
Components: contrib/hive
Reporter: Namit Jain
Assignee: Namit Jain
When the user specifies the delimiter (which is different from the default delimiter), the data is not processed correctly. Consider the test case:
CREATE TABLE INPUT4_CB(KEY STRING, VALUE STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\002' LINES TERMINATED BY '\012';
LOAD DATA LOCAL INPATH '../data/files/kv1_cb.txt' INTO TABLE INPUT4_CB;
SELECT INPUT4_CB.VALUE, INPUT4_CB.KEY FROM INPUT4_CB;
DROP TABLE INPUT4_CB
where kv1_cb.txt contains data seperated by Ctrl-B (\002) - the results are not as expected
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (HADOOP-4265) [Hive] error when user specifies the
delimiter
Posted by "Ashish Thusoo (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-4265?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ashish Thusoo resolved HADOOP-4265.
-----------------------------------
Resolution: Fixed
Fix Version/s: 0.19.1
Fixed as part of JIRA-4230
> [Hive] error when user specifies the delimiter
> ----------------------------------------------
>
> Key: HADOOP-4265
> URL: https://issues.apache.org/jira/browse/HADOOP-4265
> Project: Hadoop Core
> Issue Type: Bug
> Components: contrib/hive
> Reporter: Namit Jain
> Assignee: Namit Jain
> Fix For: 0.19.1
>
>
> When the user specifies the delimiter (which is different from the default delimiter), the data is not processed correctly. Consider the test case:
> CREATE TABLE INPUT4_CB(KEY STRING, VALUE STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\002' LINES TERMINATED BY '\012';
> LOAD DATA LOCAL INPATH '../data/files/kv1_cb.txt' INTO TABLE INPUT4_CB;
> SELECT INPUT4_CB.VALUE, INPUT4_CB.KEY FROM INPUT4_CB;
> DROP TABLE INPUT4_CB
> where kv1_cb.txt contains data seperated by Ctrl-B (\002) - the results are not as expected
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HADOOP-4265) [Hive] error when user specifies the
delimiter
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-4265?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HADOOP-4265:
-------------------------------
Fix Version/s: (was: 0.19.1)
0.19.0
> [Hive] error when user specifies the delimiter
> ----------------------------------------------
>
> Key: HADOOP-4265
> URL: https://issues.apache.org/jira/browse/HADOOP-4265
> Project: Hadoop Core
> Issue Type: Bug
> Components: contrib/hive
> Reporter: Namit Jain
> Assignee: Namit Jain
> Fix For: 0.19.0
>
>
> When the user specifies the delimiter (which is different from the default delimiter), the data is not processed correctly. Consider the test case:
> CREATE TABLE INPUT4_CB(KEY STRING, VALUE STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\002' LINES TERMINATED BY '\012';
> LOAD DATA LOCAL INPATH '../data/files/kv1_cb.txt' INTO TABLE INPUT4_CB;
> SELECT INPUT4_CB.VALUE, INPUT4_CB.KEY FROM INPUT4_CB;
> DROP TABLE INPUT4_CB
> where kv1_cb.txt contains data seperated by Ctrl-B (\002) - the results are not as expected
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.