回复: Re: create table with blocksize failed

["yingshuai.li@esgyn.cn" <yi...@esgyn.cn>]

thanks. i found in the log that the blocksize must between 1KB and 64MB



李英帅
易鲸捷信息技术有限公司
手机：18701691214
邮箱：yingshuai.li@esgyn.cn
 
发件人： Eric Owhadi
发送时间： 2017-12-27 04:18
收件人： dev@trafodion.apache.org; dev
主题： Re: create table with blocksize failed
did you try 512 bytes or did you mean 512 KB. the number is representing bytes. So the error could be that block size this small would not work.
Eric
 
 
 
Sent from my Samsung Galaxy smartphone.
 
 
-------- Original message --------
From: yingshuai.li@esgyn.cn
Date: 12/24/17 8:50 PM (GMT-06:00)
To: dev <de...@trafodion.incubator.apache.org>
Subject: create table with blocksize failed
 
Hi all,
        when i create a table with blocksize, the following error occurred,  who knows the reason?
 
        SQL>CREATE TABLE t_hbaseoption1(c1 INT NOT NULL, c2 varchar(5)) SALT USING 2 PARTITIONS ON (c1) store BY (c1) HBASE_OPTIONS (BLOCKSIZE='512');
 
         *** ERROR[8448] Unable to access Hbase interface. Call to ExpHbaseInterface::create() returned error HBASE_CREATE_ERROR(701). Cause: java.io.IOException: createTable exception. Unable to create table TRAFODION.SEABASE.T_HBASEOPTION1
         org.apache.hadoop.hbase.client.transactional.RMInterface.createTable(RMInterface.java:594)
         org.trafodion.sql.HBaseClient.createk(HBaseClient.java:503). [2017-12-25 10:43:38]
 
 
 
李英帅
易鲸捷信息技术有限公司
手机：18701691214
邮箱：yingshuai.li@esgyn.cn