http://git-wip-us.apache.org/repos/asf/incubator-carbondata-site/blob/64ee1986/src/main/webapp/docs/latest/ddl.html ---------------------------------------------------------------------- diff --git a/src/main/webapp/docs/latest/ddl.html b/src/main/webapp/docs/latest/ddl.html index fd18795..e270f31 100644 --- a/src/main/webapp/docs/latest/ddl.html +++ b/src/main/webapp/docs/latest/ddl.html @@ -1,59 +1,4 @@ -Untitled Document.md -

Version: 0.2.0 | Last Published: 21-11-2016

- - Top -

DDL Operations on CarbonData

This tutorial guides you through the data definition language support provided by CarbonData.

@@ -91,7 +31,7 @@ under the License.

CREATE TABLE

-

This command can be used to create carbon table by specifying the list of fields along with the table properties.

+

This command can be used to create CarbonData table by specifying the list of fields along with the table properties.

CREATE TABLE [IF NOT EXISTS] [db_name.]table_name
                  [(col_name data_type , ...)]
            STORED BY 'carbondata'
@@ -115,22 +55,22 @@ under the License.
 
 
 field_list
-Comma separated List of fields with data type. The field names should consist of Alphanumeric characters and underscore(_) special character.
+Comma separated List of fields with data type. The field names should consist of alphanumeric characters and underscore(_) special character.
 No
 
 
 table_name
-The name of the table in Database. Table Name should consist of Alphanumeric characters and underscore(_) special character.
+The name of the table in Database. Table Name should consist of alphanumeric characters and underscore(_) special character.
 No
 
 
 STORED BY
-“org.apache.carbondata.format”, identifies and creates carbon table.
+“org.apache.carbondata.format”, identifies and creates a CarbonData table.
 No
 
 
 TBLPROPERTIES
-List of carbon table properties.
+List of CarbonData table properties.
 
 
 
@@ -154,8 +94,7 @@ under the License.
 
 
  • Table Block Size Configuration

    -

    The block size of table files can be defined using the property TABLE_BLOCKSIZE. It accepts only integer values. The default value is 1024 MB and supports a range of 1 MB to 2048 MB.
    -If you do not specify this value in the DDL command, default value is used.

    +

    The block size of table files can be defined using the property TABLE_BLOCKSIZE. It accepts only integer values. The default value is 1024 MB and supports a range of 1 MB to 2048 MB. If you do not specify this value in the DDL command, default value is used.

    TBLPROPERTIES ("TABLE_BLOCKSIZE"="512 MB")
     

    Here 512 MB means the block size of this table is 512 MB. You can also set it as 512M or 512.

    @@ -167,7 +106,7 @@ By default inverted index is enabled. The user can disable the inverted index cr
    TBLPROPERTIES ("NO_INVERTED_INDEX"="column1,column3")
     

    No inverted index shall be generated for the columns specified in NO_INVERTED_INDEX. This property is applicable on columns with high-cardinality and is an optional parameter.

    -

    Note :

    +

    NOTE:

    • By default all columns other than numeric datatype are treated as dimensions and all columns of numeric datatype are treated as measures.

      @@ -289,7 +228,17 @@ By default inverted index is enabled. The user can disable the inverted index cr
      ALTER TABLE carbontable COMPACT MAJOR;
       
      -
      - Top -
      + +