You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@trafodion.apache.org by "yingshuai.li@esgyn.cn" <yi...@esgyn.cn> on 2017/12/25 02:50:03 UTC

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

RE: create table with blocksize failed

Posted by Dave Birdsall <da...@esgyn.com>.

Hi,

On HDP, the minimum blocksize supported is 1K (that is, 1024). CDH on the other hand doesn't seem to impose a minimum block size.

So, I will guess that you are on an HDP distribution.

There was a Trafodion bug where the exception information from HDP was not being reported. That was fixed in incubator-trafodion about a year ago, here: https://github.com/apache/trafodion/pull/725. So, unless you are on an older version of Trafodion, you should (somewhere in the stack trace) see a message about minimum block size.

Dave
 

-----Original Message-----
From: Eric Owhadi [mailto:eric.owhadi@esgyn.com] 
Sent: Tuesday, December 26, 2017 12:18 PM
To: dev@trafodion.apache.org; dev <de...@trafodion.incubator.apache.org>
Subject: 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

回复: Re: create table with blocksize failed

Posted by "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

Re: create table with blocksize failed

Posted by Eric Owhadi <er...@esgyn.com>.

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