carbondata-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chenliang...@apache.org
Subject [1/2] incubator-carbondata git commit: updated doc for ddl bucketing section
Date Wed, 22 Feb 2017 09:16:02 GMT
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 <anubhav.tarar@knoldus.in>
Authored: Thu Feb 16 11:20:25 2017 +0530
Committer: chenliang613 <chenliang613@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(“BUCKETNUMBER”=”noOfBuckets”,
-   “BUCKETCOLUMNS”=’’columnname”, “TABLENAME”=”tablename”)
-
+   “BUCKETCOLUMNS”=’’columnname”)
 ```
-
+  
 ## 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')
+ ```
 


Mime
View raw message