It sure looks like a bug. Either the SQL Reference Manual is wrong or the code 
is wrong. Either way it is a bug.

Please file a JIRA.

Dave

-----Original Message-----
From: [email protected] [mailto:[email protected]] 
Sent: Tuesday, December 26, 2017 1:04 AM
To: dev <[email protected]>
Subject: question about hbase option TTL

Hi all,
      i 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:

    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();


     is this a bug?


李英帅
易鲸捷信息技术有限公司
手机:18701691214
邮箱:[email protected]

Reply via email to