[
https://issues.apache.org/jira/browse/TRAFODION-2416?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15832093#comment-15832093
]
ASF GitHub Bot commented on TRAFODION-2416:
-------------------------------------------
GitHub user anoopsharma00 opened a pull request:
https://github.com/apache/incubator-trafodion/pull/921
Various TRAFODION jira fixes, details below.
TRAFODION-2416 HBASE_OPTIONS on create index are now correctly recreated
after data is removed through purgedata command.
TRAFODION-2401 a foreign key referential constraint with NOT ENFORCED
option no longer creates an index.
TRAFODION-2299 A WITH statement now displays number of rows selected
instead of 'sql operation complete'. This fix is currently only done
for sqlci commands. It still needs to be added to trafci interface.
TRAFODION-1796 During regressions run, if default schema 'SCH'
doesn't already exist, then it is automatically created and updated in
the system defaults table when the first create statement is seen.
This change was added a while back.
TRAFODION-1637 vsbb delete was incorrectly being chosen when deleting rows
from hbase tables in _ROW_ or _CELL_ format. That has been fixed.
In addition, the cqd hbase_delete_costing 'OFF' has been removed
from seabase/TEST022.
hive/TEST007 has been fixed to create a trafodion schema where non-hive
tables/views are created.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/anoopsharma00/incubator-trafodion
ansharma_traf21_fixes
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/921.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 #921
----
commit a9ce210789df5082a2fb8dd6d808937022208adf
Author: Anoop Sharma <[email protected]>
Date: 2017-01-20T16:50:52Z
Various TRAFODION jira fixes, details below.
TRAFODION-2416 HBASE_OPTIONS on create index are now correctly recreated
after data is removed through purgedata command.
TRAFODION-2401 a foreign key referential constraint with NOT ENFORCED
option no longer creates an index.
TRAFODION-2299 A WITH statement now displays number of rows selected
instead of 'sql operation complete'. This fix is currently only done
for sqlci commands. It still needs to be added to trafci interface.
TRAFODION-1796 During regressions run, if default schema 'SCH'
doesn't already exist, then it is automatically created and updated in
the system defaults table when the first create statement is seen.
This change was added a while back.
TRAFODION-1637 vsbb delete was incorrectly being chosen when deleting rows
from hbase tables in _ROW_ or _CELL_ format. That has been fixed.
In addition, the cqd hbase_delete_costing 'OFF' has been removed
from seabase/TEST022.
hive/TEST007 has been fixed to create a trafodion schema where non-hive
tables/views are created.
----
> 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)
