[TAJO-816] NULL delimiter doesn't apply with HCatalogStore

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.9.0, 0.8.1
• Component/s: Catalog
• Assignee: JaeHwa Jung
• Reporter: JaeHwa Jung
• Created: 07/May/14 08:06
• Updated: 12/May/14 18:28
• Resolved: 12/May/14 15:38

Description

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

  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' ;
  

• Hive

  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'='|')