[
https://issues.apache.org/jira/browse/TRAFODION-2868?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Suresh Subbiah reassigned TRAFODION-2868:
-----------------------------------------
Assignee: Suresh Subbiah
> bug of hbase option TTL
> ------------------------
>
> Key: TRAFODION-2868
> URL: https://issues.apache.org/jira/browse/TRAFODION-2868
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Affects Versions: any
> Reporter: liyingshuai
> Assignee: Suresh Subbiah
>
> 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();
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
