You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Anoop Sharma (JIRA)" <ji...@apache.org> on 2016/12/22 19:40:58 UTC
[jira] [Assigned] (TRAFODION-2416) HBASE OPTIONS on CREATE INDEX
have no effect
[ 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)