Jaehwa Jung created TAJO-816:
--------------------------------

             Summary: StorageConstants.SEQUENCEFILE_NULL doesn't apply with 
HCatalogStore
                 Key: TAJO-816
                 URL: https://issues.apache.org/jira/browse/TAJO-816
             Project: Tajo
          Issue Type: Bug
          Components: catalog
    Affects Versions: 0.8.0
            Reporter: Jaehwa Jung
            Assignee: Jaehwa Jung


If we use _csvfile.null_ with HCatalogStore, it will run without some 
exceptions. But we can't find _serialization.null.format_ parameter on Hive as 
follows:

* Tajo
{code:xml}
create external table table2 (id int, name text, score float, type text) using 
csv with ('csvfile.delimiter'='|','csvfile.null'=''
> ) location 'hdfs://localhost:9010/tajo/warehouse/table2' ;
{code}

* Hive
{code:xml}
hive> show create table table2;
OK
CREATE EXTERNAL TABLE table2(
  id int COMMENT '', 
  name string COMMENT '', 
  score float COMMENT '', 
  type string COMMENT '')
ROW FORMAT DELIMITED 
  FIELDS TERMINATED BY '|' 
STORED AS INPUTFORMAT 
  'org.apache.hadoop.mapred.TextInputFormat' 
OUTPUTFORMAT 
  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
LOCATION
  'hdfs://localhost:9010/tajo/warehouse/table2'
TBLPROPERTIES (
  'csvfile.null'='', 
  'transient_lastDdlTime'='1399433333', 
  'csvfile.delimiter'='|')
{code}



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Reply via email to