[TAJO-1690] Create table using text file fails in HiveCatalogStore.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Fix Version/s: 0.11.0
• Component/s: Catalog
• Assignee: JaeHwa Jung
• Reporter: JaeHwa Jung
• Created: 17/Jul/15 16:47
• Updated: 22/Jul/15 04:05
• Resolved: 22/Jul/15 04:05

Description

Create table using text file fails in HiveCatalogStore as follows.

• TSQL

  default> create external table supplier (S_SUPPKEY bigint, S_NAME text, S_ADDRESS text, S_NATIONKEY bigint, S_PHONE text, S_ACCTBAL double, S_COMMENT text) using text with ('textfile.delimiter'='|') location 'hdfs://localhost:9010/tpch/supplier';
  ERROR: Cannot create table "default.supplier".
  

• TajoMaster log

  2015-07-18 01:40:12,055 ERROR org.apache.tajo.catalog.CatalogServer: org.apache.tajo.common.exception.NotImplementedException: text
  org.apache.tajo.catalog.exception.CatalogException: org.apache.tajo.common.exception.NotImplementedException: text
  	at org.apache.tajo.catalog.store.HiveCatalogStore.createTable(HiveCatalogStore.java:553)
  	at org.apache.tajo.catalog.CatalogServer$CatalogProtocolHandler.createTable(CatalogServer.java:602)
  	at org.apache.tajo.catalog.AbstractCatalogClient.createTable(AbstractCatalogClient.java:406)
  	at org.apache.tajo.master.exec.DDLExecutor.createTable(DDLExecutor.java:275)
  	at org.apache.tajo.master.exec.DDLExecutor.createTable(DDLExecutor.java:211)
  	at org.apache.tajo.master.exec.DDLExecutor.execute(DDLExecutor.java:91)
  	at org.apache.tajo.master.exec.QueryExecutor.execute(QueryExecutor.java:107)
  

It seems that HiveCatalogStore just support csv file format. We need to support text file format in HiveCatalogStore.

Issue Links

• is duplicated by: TAJO-1496 Remove legacy CSVFile