Uploaded image for project: 'Tajo'
  1. Tajo
  2. TAJO-1690

Create table using text file fails in HiveCatalogStore.

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: 0.11.0
    • Component/s: Catalog
    • Labels:
      None

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                blrunner Jaehwa Jung
                Reporter:
                blrunner Jaehwa Jung
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: