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:[email protected]] Sent: Tuesday, December 26, 2017 12:18 PM To: [email protected]; dev <[email protected]> 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: [email protected] Date: 12/24/17 8:50 PM (GMT-06:00) To: dev <[email protected]> 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 邮箱：[email protected]
