[jira] [Created] (TRAFODION-2042) Index shall inherit compression and data_block_encoding HBase options from Table

["Suresh Subbiah (JIRA)" <ji...@apache.org>]

Suresh Subbiah created TRAFODION-2042:
-----------------------------------------

             Summary: Index shall inherit compression and data_block_encoding HBase options from Table
                 Key: TRAFODION-2042
                 URL: https://issues.apache.org/jira/browse/TRAFODION-2042
             Project: Apache Trafodion
          Issue Type: Improvement
          Components: sql-general
    Affects Versions: 2.0-incubating
            Reporter: Suresh Subbiah
            Assignee: Suresh Subbiah


When a an index is created on a Trafodion table using the CREATE INDEX statement, users accidentally omit specifying the HBASE_OPTIONS clause. This results in the index being uncompressed and occupying more than necessary space on disk. If the table is large this can also lead to errors during bulkload as a single region may have more than 32 HFiles each of size 10 GB (default max size for HFile created by bulkload).

Having the index inherit compression and encoding options used by the table by default is reasonable and will help.
If the user wishes for the index to have a different type of compression from the base table then it can be explicitly specified in the CREATE INDEX statement.

A CQD will also be provided to disable this attribute inheritance.

An attribute inherited from the base table will take precedence over compression/encoding type obtained from
HBASE_COMPRESSION_OPTION and HBASE_DATA_BLOCK_ENCODING_OPTION cqds.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)