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

Avoid to create external table using TableSpace

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.11.0, 0.12.0
    • Component/s: SQL Parser
    • Labels:
      None

      Description

      I failed to create external table on HBaseTableSpace as following:

      • HBase Shell
        hbase(main):002:0> desc 'blog'
        
        Table blog is ENABLED                                                                                                                                                                                                               
        blog                                                                                                                                                                                                                                
        COLUMN FAMILIES DESCRIPTION                                                                                                                                                                                                         
        {NAME => 'content', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', VERSIONS => '1', COMPRESSION => 'NONE', MIN_VERSIONS => '0', TTL => 'FOREVER', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '65536
        ', IN_MEMORY => 'false', BLOCKCACHE => 'true'}                                                                                                                                                                                      
        {NAME => 'info', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', VERSIONS => '1', COMPRESSION => 'NONE', MIN_VERSIONS => '0', TTL => 'FOREVER', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '65536', 
        IN_MEMORY => 'false', BLOCKCACHE => 'true'}                                                                                                                                                                                         
        2 row(s) in 0.2380 seconds
        
      • TSQL
        CREATE EXTERNAL TABLE hbase_blog (rowkey text, author text, register_date text, title text)  TABLESPACE hbasecluster1 USING hbase WITH ('table'='blog', 'columns'=':key,info:author,info:date,content:title');
        
        ERROR: hdfs://localhost:9010/tajo/warehouse/default/hbase_blog does not exist
        
      • TajoMaster Log
        Stack Trace:
        java.io.IOException: ERROR: hdfs://localhost:9010/tajo/warehouse/default/hbase_blog does not exist
        	at org.apache.tajo.storage.FileTablespace.createTable(FileTablespace.java:674)
        	at org.apache.tajo.master.exec.DDLExecutor.createTable(DDLExecutor.java:364)
        	at org.apache.tajo.master.exec.DDLExecutor.createTable(DDLExecutor.java:291)
        	at org.apache.tajo.master.exec.DDLExecutor.execute(DDLExecutor.java:93)
        	at org.apache.tajo.master.exec.QueryExecutor.execute(QueryExecutor.java:113)
        

        Attachments

        1. TAJO-1727_2.patch
          3 kB
          Jaehwa Jung
        2. TAJO-1727_3.patch
          4 kB
          Jaehwa Jung
        3. TAJO-1727.patch
          3 kB
          Jaehwa Jung

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: