tajo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jinho Kim (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (TAJO-213) NULL characters in meta of csv table should be supported
Date Thu, 26 Sep 2013 15:26:03 GMT

    [ https://issues.apache.org/jira/browse/TAJO-213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13778891#comment-13778891
] 

Jinho Kim edited comment on TAJO-213 at 9/26/13 3:24 PM:
---------------------------------------------------------

ex) from hive text file
{code}
CREATE EXTERNAL TABLE null_test( A int, B text, C text) 
using csv with('csvfile.delimiter'='\001','csvfile.null'='\\N') 
location 'hdfs://localhost:9010/tajo/warehouse/null_test'; 
{code}
                
      was (Author: jhkim):
    ex) from hive text file
{code}
CREATE EXTERNAL TABLE null_test( A int, B text, C text) using csv with('csvfile.delimiter'='\001','csvfile.null'='\\N')

location 'hdfs://localhost:9010/tajo/warehouse/null_test'; 
{code}
                  
> NULL characters in meta of csv table should be supported
> --------------------------------------------------------
>
>                 Key: TAJO-213
>                 URL: https://issues.apache.org/jira/browse/TAJO-213
>             Project: Tajo
>          Issue Type: New Feature
>          Components: storage
>            Reporter: Jinho Kim
>            Assignee: Jinho Kim
>         Attachments: TAJO-213.patch
>
>
> '\N' represents default NULL value in hive. but do not get it.
> * default null value is empty string. (without text column)
> * add table option for null value.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message