liu ming created TRAFODION-3197:
-----------------------------------
Summary: showddl cannot show default hbase_options when insert cqd
values into defaults table
Key: TRAFODION-3197
URL: https://issues.apache.org/jira/browse/TRAFODION-3197
Project: Apache Trafodion
Issue Type: Bug
Reporter: liu ming
Assignee: liu ming
Make "hbase_options" as default setting and use cqd to change the default
setting when create table.
I insert cqd values into defaults table and restart dcs to make it work.
insert into defaults values('HBASE_DATA_BLOCK_ENCODING_OPTION','FAST_DIFF','add
by hfl',0);
insert into defaults values('HBASE_COMPRESSION_OPTION','SNAPPY','add by hfl',0);
insert into defaults
values('HBASE_MEMSTORE_FLUSH_SIZE_OPTION','1073741824','add by hfl',0);
Then create a table through trafci.
But showddl cannot show the default hbase_options and it is effective on hbase.
=================showddl
SQL>create table test_hbase(a int, b char(4));
--- SQL operation complete.
SQL>showddl test_hbase;
CREATE TABLE TRAFODION.TEST_HFL.TEST_HBASE
(
A INT DEFAULT NULL NOT SERIALIZED
, B CHAR(4) CHARACTER SET ISO88591 COLLATE
DEFAULT DEFAULT NULL NOT SERIALIZED
)
ATTRIBUTES ALIGNED FORMAT NAMESPACE 'TRAF_1500000'
;
-- GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON
TRAFODION.TEST_HFL.TEST_HBASE TO DB__ROOT WITH GRANT OPTION;
--- SQL operation complete.
====================hbase shell
hbase(main):003:0> desc 'TRAF_1500000:TRAFODION.TEST_HFL.TEST_HBASE'
Table TRAF_1500000:TRAFODION.TEST_HFL.TEST_HBASE is ENABLED
TRAF_1500000:TRAFODION.TEST_HFL.TEST_HBASE, {TABLE_ATTRIBUTES =>
{MEMSTORE_FLUSHSIZE => '1073741824', coprocessor$1 =>
'|org.apache.hadoop.hbase.coprocessor.tra
nsactional.TrxRegionObserver|1073741823|', coprocessor$2 =>
'|org.apache.hadoop.hbase.coprocessor.transactional.TrxRegionEndpoint|1073741823|',
coprocessor$3 =>
'|org.apache.hadoop.hbase.coprocessor.AggregateImplementation|1073741823|'}
COLUMN FAMILIES DESCRIPTION
{NAME => '[0000001|https://www.esgyn.com/mantis/view.php?id=1]', BLOOMFILTER =>
'ROW', VERSIONS => '1', IN_MEMORY => 'false', KEEP_DELETED_CELLS => 'FALSE',
DATA_BLOCK_ENCODING => 'FAST_DIFF', TTL => 'FOREVER',
COMPRESSION => 'SNAPPY', MIN_VERSIONS => '0', BLOCKCACHE => 'true', BLOCKSIZE
=> '65536', REPLICATION_SCOPE => '0'}
{NAME => 'mt_', BLOOMFILTER => 'ROW', VERSIONS => '2', IN_MEMORY => 'true',
KEEP_DELETED_CELLS => 'FALSE', DATA_BLOCK_ENCODING => 'NONE', TTL => 'FOREVER',
COMP
RESSION => 'NONE', MIN_VERSIONS => '0', BLOCKCACHE => 'true', BLOCKSIZE =>
'65536', REPLICATION_SCOPE => '0'}
2 row(s) in 0.3140 seconds
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
