You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by db...@apache.org on 2018/01/04 19:17:45 UTC
[1/2] trafodion git commit: Add Syntax Descriptions of HBase Options
for *Trafodion SQL Reference Manual*
Repository: trafodion
Updated Branches:
refs/heads/master 925e44d73 -> ff6ce5af2
Add Syntax Descriptions of HBase Options for *Trafodion SQL Reference Manual*
Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/045fce49
Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/045fce49
Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/045fce49
Branch: refs/heads/master
Commit: 045fce49658c65f31c85012d86df578c773b354b
Parents: 51935dc
Author: liu.yu <yu...@esgyn.cn>
Authored: Fri Dec 29 17:10:59 2017 +0800
Committer: liu.yu <yu...@esgyn.cn>
Committed: Fri Dec 29 17:10:59 2017 +0800
----------------------------------------------------------------------
.../src/asciidoc/_chapters/sql_statements.adoc | 118 ++++++++++---------
1 file changed, 60 insertions(+), 58 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/trafodion/blob/045fce49/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc
----------------------------------------------------------------------
diff --git a/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc b/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc
index f8d5a6c..2f1f2d9 100644
--- a/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc
+++ b/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc
@@ -1503,46 +1503,45 @@ underlying table. For ordering (but not for other purposes), nulls are greater t
+
a list of HBase options to set for the index. These options are applied independently of any HBase options set for
the index’s table.
-
-// TODO: The Word document did not list all default values.
+
** `_hbase-option_ = '_value_'`
+
-is one of the these HBase options and its assigned value:
+is one of these HBase options and its assigned value:
+
-[cols="35%,65%",options="header"]
+[options="header"]
|===
-| HBase Option | Accepted Values^1^
-| BLOCKCACHE | 'true' \| 'false'
-| BLOCKSIZE | *'65536'( \| '_positive-integer_'
-| BLOOMFILTER | 'NONE' \| 'ROW' \| 'ROWCOL'
-| CACHE_BLOOMS_ON_WRITE | 'true' \| 'false'
-| CACHE_DATA_ON_WRITE | 'true' \| 'false'
-| CACHE_INDEXES_ON_WRITE | 'true' \| 'false'
-| COMPACT | 'true' \| 'false'
-| COMPACT_COMPRESSION | 'GZ' \| 'LZ4' \| 'LZO' \| 'NONE' \| 'SNAPPY'
-| COMPRESSION | 'GZ' \| 'LZ4' \| 'LZO' \| 'NONE' \| 'SNAPPY'
-| DATA_BLOCK_ENCODING | 'DIFF' \| 'FAST_DIFF' \| 'NONE' \| 'PREFIX'
-| DURABILITY | 'USE_DEFAULT' \| 'SKIP_WAL' \| 'ASYNC_WAL' \| 'SYNC_WAL' \| 'FSYNC_WAL'
-| EVICT_BLOCKS_ON_CLOSE | *'true'* \| 'false'
-| IN_MEMORY | *'true'* \| 'false'
-| KEEP_DELETED_CELLS | *'true'* \| 'false'
-| MAX_FILESIZE | '_positive-integer_'
-| MAX_VERSIONS | '1' \| '_positive-integer_'
-| MEMSTORE_FLUSH_SIZE | '_positive-integer_'
-| MIN_VERSIONS | '0' \| '_positive-integer_'
+| HBase Option | Accepted Values | Default Values
+| BLOCKCACHE | 'true' \| 'false' | 'true'
+| BLOCKSIZE | '1024' - '64*1024*1024' | '64*1024'
+| BLOOMFILTER | 'NONE' \| 'ROW' \| 'ROWCOL' | 'ROW'
+| CACHE_BLOOMS_ON_WRITE | 'true' \| 'false' | 'false'
+| CACHE_DATA_ON_WRITE | 'true' \| 'false' | 'false'
+| CACHE_INDEXES_ON_WRITE | 'true' \| 'false' | 'false'
+| COMPACT | 'true' \| 'false' | 'true'
+| COMPACT_COMPRESSION | 'GZ' \| 'LZ4' \| 'LZO' \| 'NONE' \| 'SNAPPY' | 'NONE'
+| COMPRESSION | 'GZ' \| 'LZ4' \| 'LZO' \| 'NONE' \| 'SNAPPY' | 'NONE'
+| DATA_BLOCK_ENCODING | 'DIFF' \| 'FAST_DIFF' \| 'NONE' \| 'PREFIX' | 'NONE'
+| DURABILITY | 'USE_DEFAULT' \| 'SKIP_WAL' \| 'ASYNC_WAL' \| 'SYNC_WAL' \| 'FSYNC_WAL' | 'SYNC_WAL'
+| EVICT_BLOCKS_ON_CLOSE | 'true' \| 'false' | 'false'
+| IN_MEMORY | 'true' \| 'false' | 'false'
+| KEEP_DELETED_CELLS | 'true' \| 'false' | 'false'
+| MAX_FILESIZE | '2*1024*1024' - '2^63^-1' | '10*1024*1024*1024'
+| MAX_VERSIONS | '1' \| '_positive-integer_' | '1'
+| MEMSTORE_FLUSH_SIZE | '1024*1024' - '2^63^-1' | '128*1024*1024'
+| MIN_VERSIONS | '0' \| '_positive-integer_' | '0'
| PREFIX_LENGTH_KEY | '_positive-integer_', which should be less than maximum length of the key for the table.
-It applies only if the SPLIT_POLICY is `KeyPrefixRegionSplitPolicy`.
-| REPLICATION_SCOPE | '0' \| *'1'*
+It applies only if the SPLIT_POLICY is `KeyPrefixRegionSplitPolicy`. | '2'
+| REPLICATION_SCOPE | '0' \| '1' | '1'
| SPLIT_POLICY | 'org.apache.hadoop.hbase.regionserver. +
ConstantSizeRegionSplitPolicy' \| +
'org.apache.hadoop.hbase.regionserver. +
IncreasingToUpperBoundRegionSplitPolicy' \| +
'org.apache.hadoop.hbase.regionserver. +
KeyPrefixRegionSplitPolicy'
-| TTL | '-1' (forever) \| '_positive-integer_'
+|'org.apache.hadoop.hbase.regionserver. +
+IncreasingToUpperBoundRegionSplitPolicy'
+| TTL | '-1' (forever) \| '_positive-integer_' | '-1'
|===
-+
-^1^ Values in boldface are default values.
* `SALT LIKE TABLE`
+
@@ -2774,40 +2773,43 @@ a list of HBase options to set for the table.
** `_hbase-option_ = '_value_'`
+
-is one of the these HBase options and its assigned value:
+is one of these HBase options and its assigned value:
+
-[cols="35%,65%",options="header"]
+[options="header"]
|===
-| HBase Option | Accepted Values^1^
-| BLOCKCACHE | 'true' \| 'false'
-| BLOCKSIZE | '65536' \| '_positive-integer_'
-| BLOOMFILTER | 'NONE' \| 'ROW' \| 'ROWCOL'
-| CACHE_BLOOMS_ON_WRITE | 'true' \| 'false'
-| CACHE_DATA_ON_WRITE | 'true' \| 'false'
-| CACHE_INDEXES_ON_WRITE | 'true' \| 'false'
-| COMPACT | 'true' \| 'false'
-| COMPACT_COMPRESSION | 'GZ' \| 'LZ4' \| 'LZO' \| 'NONE' \| 'SNAPPY'
-| COMPRESSION | 'GZ' \| 'LZ4' \| 'LZO' \| 'NONE' \| 'SNAPPY'
-| DATA_BLOCK_ENCODING | 'DIFF' \| 'FAST_DIFF' \| 'NONE' \| 'PREFIX'
-| DURABILITY | 'USE_DEFAULT' \| 'SKIP_WAL' \| 'ASYNC_WAL' \| 'SYNC_WAL' \| 'FSYNC_WAL'
-| EVICT_BLOCKS_ON_CLOSE | *'true'* \| 'false'
-| IN_MEMORY | *'true'* \| 'false'
-| KEEP_DELETED_CELLS | *'true'* \| 'false'
-| MAX_FILESIZE | '_positive-integer_'
-| MAX_VERSIONS | '1' \| '_positive-integer_'
-| MEMSTORE_FLUSH_SIZE | '_positive-integer_'
-| MIN_VERSIONS | '0' \| '_positive-integer_'
-| PREFIX_LENGTH_KEY | '_positive-integer_', which should be less than maximum length of the
-key for the table. It applies only if the SPLIT_POLICY is `KeyPrefixRegionSplitPolicy`.
-| REPLICATION_SCOPE | '0' \| '1'
-| SPLIT_POLICY | 'org.apache.hadoop.hbase.regionserver.ConstantSizeRegionSplitPolicy' \|
-'org.apache.hadoop.hbase.regionserver.IncreasingToUpperBoundRegionSplitPolicy' \|
-'org.apache.hadoop.hbase.regionserver.KeyPrefixRegionSplitPolicy'
-| TTL | '-1' (forever) \| '_positive-integer_'
+| HBase Option | Accepted Values | Default Values
+| BLOCKCACHE | 'true' \| 'false' | 'true'
+| BLOCKSIZE | '1024' - '64*1024*1024' | '64*1024'
+| BLOOMFILTER | 'NONE' \| 'ROW' \| 'ROWCOL' | 'ROW'
+| CACHE_BLOOMS_ON_WRITE | 'true' \| 'false' | 'false'
+| CACHE_DATA_ON_WRITE | 'true' \| 'false' | 'false'
+| CACHE_INDEXES_ON_WRITE | 'true' \| 'false' | 'false'
+| COMPACT | 'true' \| 'false' | 'true'
+| COMPACT_COMPRESSION | 'GZ' \| 'LZ4' \| 'LZO' \| 'NONE' \| 'SNAPPY' | 'NONE'
+| COMPRESSION | 'GZ' \| 'LZ4' \| 'LZO' \| 'NONE' \| 'SNAPPY' | 'NONE'
+| DATA_BLOCK_ENCODING | 'DIFF' \| 'FAST_DIFF' \| 'NONE' \| 'PREFIX' | 'NONE'
+| DURABILITY | 'USE_DEFAULT' \| 'SKIP_WAL' \| 'ASYNC_WAL' \| 'SYNC_WAL' \| 'FSYNC_WAL' | 'SYNC_WAL'
+| EVICT_BLOCKS_ON_CLOSE | 'true' \| 'false' | 'false'
+| IN_MEMORY | 'true' \| 'false' | 'false'
+| KEEP_DELETED_CELLS | 'true' \| 'false' | 'false'
+| MAX_FILESIZE | '2*1024*1024' - '2^63^-1' | '10*1024*1024*1024'
+| MAX_VERSIONS | '1' \| '_positive-integer_' | '1'
+| MEMSTORE_FLUSH_SIZE | '1024*1024' - '2^63^-1' | '128*1024*1024'
+| MIN_VERSIONS | '0' \| '_positive-integer_' | '0'
+| PREFIX_LENGTH_KEY | '_positive-integer_', which should be less than maximum length of the key for the table.
+It applies only if the SPLIT_POLICY is `KeyPrefixRegionSplitPolicy`. | '2'
+| REPLICATION_SCOPE | '0' \| '1' | '1'
+| SPLIT_POLICY | 'org.apache.hadoop.hbase.regionserver. +
+ConstantSizeRegionSplitPolicy' \| +
+'org.apache.hadoop.hbase.regionserver. +
+IncreasingToUpperBoundRegionSplitPolicy' \| +
+'org.apache.hadoop.hbase.regionserver. +
+KeyPrefixRegionSplitPolicy'
+|'org.apache.hadoop.hbase.regionserver. +
+IncreasingToUpperBoundRegionSplitPolicy'
+| TTL | '-1' (forever) \| '_positive-integer_' | '-1'
|===
-1. Values in boldface are default values.
-
* `LOAD IF EXISTS`
+
loads data into an existing table. Must be used with AS _select-query_.
[2/2] trafodion git commit: Merge [TRAFODION-2867] PR 1362 Add
HBASE_OPTIONS syntax to SQL Ref Manual
Posted by db...@apache.org.
Merge [TRAFODION-2867] PR 1362 Add HBASE_OPTIONS syntax to SQL Ref Manual
Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/ff6ce5af
Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/ff6ce5af
Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/ff6ce5af
Branch: refs/heads/master
Commit: ff6ce5af286ae98dcea043f46ae38fa5a6b6e3de
Parents: 925e44d 045fce4
Author: Dave Birdsall <db...@apache.org>
Authored: Thu Jan 4 19:16:57 2018 +0000
Committer: Dave Birdsall <db...@apache.org>
Committed: Thu Jan 4 19:16:57 2018 +0000
----------------------------------------------------------------------
.../src/asciidoc/_chapters/sql_statements.adoc | 118 ++++++++++---------
1 file changed, 60 insertions(+), 58 deletions(-)
----------------------------------------------------------------------