Details
-
Documentation
-
Status: Open
-
Major
-
Resolution: Unresolved
-
2.2.0
-
None
-
None
Description
We are missing description on ALTER TABLE t ALTER HBASE_OPTIONS. See exemple bellow
— SQL operation complete.
>>create table tt (a int, b int);
— SQL operation complete.
>>showddl tt;
CREATE TABLE TRAFODION.SEABASE.TT
(
A INT DEFAULT NULL NOT SERIALIZED
, B INT DEFAULT NULL NOT SERIALIZED
)
ATTRIBUTES ALIGNED FORMAT
;
— SQL operation complete.
>>alter table tt alter hbase_options(TTL = '20');
— SQL operation complete.
>>showddl tt;
CREATE TABLE TRAFODION.SEABASE.TT
(
A INT DEFAULT NULL NOT SERIALIZED
, B INT DEFAULT NULL NOT SERIALIZED
)
ATTRIBUTES ALIGNED FORMAT
HBASE_OPTIONS
(
TTL = '20'
)
;
— SQL operation complete.
describe "TRAFODION.SEABASE.TT"
Table TRAFODION.SEABASE.TT is ENABLED
TRAFODION.SEABASE.TT, {TABLE_ATTRIBUTES =>
{coprocessor$1 => '|org.apache.hadoop .hbase.coprocessor.transactional.TrxRegionObserver|1073741823|', coprocessor$2 = > '|org.apache.hadoop.hbase.coprocessor.transactional.TrxRegionEndpoint|10737418 23|', coprocessor$3 => '|org.apache.hadoop.hbase.coprocessor.AggregateImplementa tion|1073741823|'}
COLUMN FAMILIES DESCRIPTION
{NAME => '#1', BLOOMFILTER => 'ROW', VERSIONS => '1', IN_MEMORY => 'false', KEEP _DELETED_CELLS => 'FALSE', DATA_BLOCK_ENCODING => 'NONE', COMPRESSION => 'NONE', TTL => '20 SECONDS', MIN_VERSIONS => '0', BLOCKCACHE => 'true', BLOCKSIZE => '6 5536', REPLICATION_SCOPE => '0'}{NAME => 'mt_', BLOOMFILTER => 'ROW', VERSIONS => '2', IN_MEMORY => 'true', KEEP _DELETED_CELLS => 'FALSE', DATA_BLOCK_ENCODING => 'NONE', COMPRESSION => 'NONE', TTL => 'FOREVER', MIN_VERSIONS => '0', BLOCKCACHE => 'true', BLOCKSIZE => '6553 6', REPLICATION_SCOPE => '0'}
2 row(s) in 0.0640 seconds