You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@carbondata.apache.org by ch...@apache.org on 2017/02/22 09:16:02 UTC
[1/2] incubator-carbondata git commit: updated doc for ddl bucketing
section
Repository: incubator-carbondata
Updated Branches:
refs/heads/master 1bce0bc0d -> 766671c79
updated doc for ddl bucketing section
Project: http://git-wip-us.apache.org/repos/asf/incubator-carbondata/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-carbondata/commit/e98a2e89
Tree: http://git-wip-us.apache.org/repos/asf/incubator-carbondata/tree/e98a2e89
Diff: http://git-wip-us.apache.org/repos/asf/incubator-carbondata/diff/e98a2e89
Branch: refs/heads/master
Commit: e98a2e8985fc47014ac88ca6295252763d1ec37b
Parents: 1bce0bc
Author: anubhav100 <an...@knoldus.in>
Authored: Thu Feb 16 11:20:25 2017 +0530
Committer: chenliang613 <ch...@huawei.com>
Committed: Wed Feb 22 17:10:28 2017 +0800
----------------------------------------------------------------------
docs/ddl-operation-on-carbondata.md | 19 +++++++++----------
1 file changed, 9 insertions(+), 10 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/e98a2e89/docs/ddl-operation-on-carbondata.md
----------------------------------------------------------------------
diff --git a/docs/ddl-operation-on-carbondata.md b/docs/ddl-operation-on-carbondata.md
index ca2107e..38910f8 100644
--- a/docs/ddl-operation-on-carbondata.md
+++ b/docs/ddl-operation-on-carbondata.md
@@ -183,22 +183,21 @@ Bucketing feature can be used to distribute/organize the table/partition data in
that similar records are present in the same file. While creating a table, a user needs to specify the
columns to be used for bucketing and the number of buckets. For the selction of bucket the Hash value
of columns is used.
+
```
CREATE TABLE [IF NOT EXISTS] [db_name.]table_name
[(col_name data_type, ...)]
STORED BY 'carbondata'
TBLPROPERTIES(\u201cBUCKETNUMBER\u201d=\u201dnoOfBuckets\u201d,
- \u201cBUCKETCOLUMNS\u201d=\u2019\u2019columnname\u201d, \u201cTABLENAME\u201d=\u201dtablename\u201d)
-
+ \u201cBUCKETCOLUMNS\u201d=\u2019\u2019columnname\u201d)
```
-
+
## Parameter Description
| Parameter | Description | Optional |
|--------------- |------------------------------------------------------------------------------------------------------------------------------ |---------- |
| BUCKETNUMBER | Specifies the number of Buckets to be created. | No |
| BUCKETCOLUMNS | Specify the columns to be considered for Bucketing | No |
-| TABLENAME | The name of the table in Database. Table Name should consist of alphanumeric characters and underscore(_) special character. | Yes |
## Usage Guidelines
@@ -206,9 +205,11 @@ of columns is used.
- Bucketing can not be performed for columns of Complex Data Types.
-- Columns in the BUCKETCOLUMN parameter must be either a dimension or a measure but combination of both is not supported.
+- Columns in the BUCKETCOLUMN parameter must be only dimension. The BUCKETCOLUMN parameter can not be a measure or a combination of measures and dimensions.
+
## Example :
+
```
CREATE TABLE IF NOT EXISTS productSchema.productSalesTable (
productNumber Int,
@@ -220,13 +221,11 @@ of columns is used.
saleQuantity Int,
revenue Int)
STORED BY 'carbondata'
- TBLPROPERTIES ('COLUMN_GROUPS'='(productName,productCategory)',
+ TBLPROPERTIES ('COLUMN_GROUPS'='(productName,productNumber)',
'DICTIONARY_EXCLUDE'='productName',
'DICTIONARY_INCLUDE'='productNumber',
'NO_INVERTED_INDEX'='productBatch',
'BUCKETNUMBER'='4',
- 'BUCKETCOLUMNS'='productNumber,saleQuantity',
- 'TABLENAME'='productSalesTable')
-
- ```
+ 'BUCKETCOLUMNS'='productName')
+ ```
[2/2] incubator-carbondata git commit: [CARBONDATA-709]corrected doc
for bucketing This closes #601
Posted by ch...@apache.org.
[CARBONDATA-709]corrected doc for bucketing This closes #601
Project: http://git-wip-us.apache.org/repos/asf/incubator-carbondata/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-carbondata/commit/766671c7
Tree: http://git-wip-us.apache.org/repos/asf/incubator-carbondata/tree/766671c7
Diff: http://git-wip-us.apache.org/repos/asf/incubator-carbondata/diff/766671c7
Branch: refs/heads/master
Commit: 766671c79535a6ef82383c15360d7dffcb452f28
Parents: 1bce0bc e98a2e8
Author: chenliang613 <ch...@huawei.com>
Authored: Wed Feb 22 17:15:39 2017 +0800
Committer: chenliang613 <ch...@huawei.com>
Committed: Wed Feb 22 17:15:39 2017 +0800
----------------------------------------------------------------------
docs/ddl-operation-on-carbondata.md | 19 +++++++++----------
1 file changed, 9 insertions(+), 10 deletions(-)
----------------------------------------------------------------------