[
https://issues.apache.org/jira/browse/TRAFODION-2475?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15870182#comment-15870182
]
ASF GitHub Bot commented on TRAFODION-2475:
-------------------------------------------
GitHub user sureshsubbiah opened a pull request:
https://github.com/apache/incubator-trafodion/pull/965
[TRAFODION-2475] Improved error handling for HBASE_OPTIONS clause
Two new attributes have also been added.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/sureshsubbiah/incubator-trafodion compress1
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/965.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #965
----
commit 93b5baa16e746097a825cd60e853bf142672f7fe
Author: Suresh Subbiah <[email protected]>
Date: 2017-02-16T16:03:34Z
[TRAFODION-2475] Improved error handling for HBASE_OPTIONS clause
Two new attributes have also been added.
----
> Create table/index or alter does not work with unavailable compression options
> ------------------------------------------------------------------------------
>
> Key: TRAFODION-2475
> URL: https://issues.apache.org/jira/browse/TRAFODION-2475
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-general
> Affects Versions: any
> Reporter: Suresh Subbiah
> Assignee: Suresh Subbiah
> Fix For: 2.0-incubating
>
>
> Create table/index option with HBASE_OPTIONS (COMPRESSION = '<val>') does not
> work well when <val> is a compression option that is not installed or enabled
> for HBase on the cluster. The 5 allowed values are GZ, LZO, LZ4, NONE,
> SNAPPY. If one of the 4 allowed compression settings is either not installed
> or available to HBase, then while creating a table it can either
> a) hang or take a long time to error out OR
> b) succeed, but have problems while inserting rows later.
> Non-existent compression library should be detected early and CREATE
> statement should error out. Same is true for ALTER table.
> As suggested by Dave in review comments to the previous PR, following fixes
> are added to the JIRA
> 1) Better validation of HBASE_OPTIONS attribute values (COMPRESSION = 'SNAP'
> will now raise an error early in execution, before we get to Java)
> 2) Specifying the same attribute twice will cause an error to be raised
> 3) Error SQLCODE for incorrect attribute/value is changed from 8448 to 8449
> for all errors originating in C++ side. Value of attribute is part of message
> string
> 4) Two more attributes (CACHE_DATA_IN_L1, PREFETCH_BLOCKS_ON_OPEN) can now be
> specified in HBASE_OPTIONS. seabase/test002 has an example with all options
> that are supported.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
