You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@tajo.apache.org by "Jaehwa Jung (JIRA)" <ji...@apache.org> on 2015/09/06 09:43:45 UTC
[jira] [Updated] (TAJO-1727) Allow to create external table with
TableSpace
[ https://issues.apache.org/jira/browse/TAJO-1727?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jaehwa Jung updated TAJO-1727:
------------------------------
Summary: Allow to create external table with TableSpace (was: Unable to create external table on HBaseTableSpace)
> Allow to create external table with TableSpace
> ----------------------------------------------
>
> Key: TAJO-1727
> URL: https://issues.apache.org/jira/browse/TAJO-1727
> Project: Tajo
> Issue Type: Bug
> Components: SQL Parser
> Reporter: Jaehwa Jung
> Assignee: Jaehwa Jung
> Priority: Critical
> Fix For: 0.11.0, 0.12.0
>
> Attachments: TAJO-1727.patch, TAJO-1727_2.patch
>
>
> I failed to create external table on HBaseTableSpace as following:
> * HBase Shell
> {code:xml}
> 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
> {code}
> * TSQL
> {code:xml}
> 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
> {code}
> * TajoMaster Log
> {code:xml}
> 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)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)