Eric Owhadi created TRAFODION-2416:
--------------------------------------
Summary: HBASE OPTIONS on CREATE INDEX have no effect
Key: TRAFODION-2416
URL: https://issues.apache.org/jira/browse/TRAFODION-2416
Project: Apache Trafodion
Issue Type: Bug
Components: sql-exe
Affects Versions: 2.1-incubating, 2.2-incubating
Reporter: Eric Owhadi
create a table t,
then create an index with syntax like:
CREATE INDEX t_idx_by_a ON t
(a)
SALT LIKE TABLE
HBASE_OPTIONS (DATA_BLOCK_ENCODING = 'FAST_DIFF', COMPRESSION = 'SNAPPY');
then verify using hbase shell and notice that DATA_BLOCK_ENCODING and
COMPRESSION are set to NONE :
describe "TRAFODION.MYSCHEMA.T_IDX_BY_A"
Table TRAFODION.MYSCHEMA.T_IDX_BY_A is ENABLED
TRAFODION.MYSCHEMA.T_IDX_BY_A
COLUMN FAMILIES DESCRIPTION
{NAME => '#1', BLOOMFILTER => 'ROW', VERSIONS => '1', IN_MEMORY => 'false', KEEP
_DELETED_CELLS => 'FALSE', DATA_BLOCK_ENCODING => 'NONE', COMPRESSION => 'NONE',
TTL => 'FOREVER', MIN_VERSIONS => '0', BLOCKCACHE => 'true', BLOCKSIZE => '6553
6', 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.0220 seconds
workaround is to alter the table using hbase shell...
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
