[TRAFODION-2868] bug of hbase option TTL

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: any
• Component/s: documentation
• Assignee: Suresh Subbiah
• Reporter: liyingshuai
• Created: 31/Dec/17 01:06
• Updated: 06/Jan/18 19:51

Description

create a table with TTL option, then an error occurred:
CREATE TABLE t_hbaseoption22(c1 INT NOT NULL, c2 varchar(5)) SALT USING 2 PARTITIONS ON (c1) store BY (c1) HBASE_OPTIONS (TTL='-1');

• • • ERROR[8448] Unable to access Hbase interface. Call to CmpSeabaseDDL::generateHbaseOptionsArray() returned error HBASE_CREATE_OPTIONS_ERROR(710). Cause: TTL. [2017-12-25 17:45:01]

as described in SQL REFERENCE MANUAL that the accepted value of TTL can be '-1' (forever) and 'positive-integer'

i found the following source code, if the value is -1 then throw an error and TTL in hbase source code -1 means forever:

CmpSeabaseDDLcommon.cpp
// 代码中设置不能等于-1
else if ((hbaseOption->key() == "TIME_TO_LIVE") || (hbaseOption->key() == "TTL"))
{
if ((str_atoi(hbaseOption->val().data(), hbaseOption->val().length()) == -1) || (!hbaseCreateOptionsArray[HBASE_TTL].empty()))
isError = TRUE;
hbaseCreateOptionsArray[HBASE_TTL] = hbaseOption->val();

Issue Links

• links to: GitHub Pull Request #1373