[TAJO-1727] Avoid to create external table using TableSpace

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 0.11.0, 0.12.0
• Component/s: SQL Parser
• Assignee: JaeHwa Jung
• Reporter: JaeHwa Jung
• Created: 30/Jul/15 09:22
• Updated: 11/Sep/15 03:13
• Resolved: 11/Sep/15 03:13

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)