[
https://issues.apache.org/jira/browse/TRAFODION-2416?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anoop Sharma reassigned TRAFODION-2416:
---------------------------------------
Assignee: Anoop Sharma
> 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
> Assignee: Anoop Sharma
>
> 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)
