You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Eric Owhadi (JIRA)" <ji...@apache.org> on 2018/09/08 00:21:00 UTC
[jira] [Created] (TRAFODION-3199) missing ALTER TABLE t ALTER
HBASE_OPTIONS in doc
Eric Owhadi created TRAFODION-3199:
--------------------------------------
Summary: missing ALTER TABLE t ALTER HBASE_OPTIONS in doc
Key: TRAFODION-3199
URL: https://issues.apache.org/jira/browse/TRAFODION-3199
Project: Apache Trafodion
Issue Type: Documentation
Components: documentation
Affects Versions: 2.2.0
Reporter: Eric Owhadi
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
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)