carbondata-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ravipes...@apache.org
Subject [20/50] [abbrv] carbondata git commit: [CARBONDATA-2116] Documentation for CTAS
Date Sat, 03 Feb 2018 19:43:27 GMT
[CARBONDATA-2116] Documentation for CTAS

Added the documentation for CTAS

This closes #1906


Project: http://git-wip-us.apache.org/repos/asf/carbondata/repo
Commit: http://git-wip-us.apache.org/repos/asf/carbondata/commit/1b224a4a
Tree: http://git-wip-us.apache.org/repos/asf/carbondata/tree/1b224a4a
Diff: http://git-wip-us.apache.org/repos/asf/carbondata/diff/1b224a4a

Branch: refs/heads/branch-1.3
Commit: 1b224a4a971597c36e931eb8e17ccbd24cea642e
Parents: a3638ad
Author: sgururajshetty <sgururajshetty@gmail.com>
Authored: Thu Feb 1 20:04:54 2018 +0530
Committer: manishgupta88 <tomanishgupta18@gmail.com>
Committed: Fri Feb 2 11:48:04 2018 +0530

----------------------------------------------------------------------
 docs/data-management-on-carbondata.md | 13 ++++++++++++-
 1 file changed, 12 insertions(+), 1 deletion(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/carbondata/blob/1b224a4a/docs/data-management-on-carbondata.md
----------------------------------------------------------------------
diff --git a/docs/data-management-on-carbondata.md b/docs/data-management-on-carbondata.md
index d7954e1..3119935 100644
--- a/docs/data-management-on-carbondata.md
+++ b/docs/data-management-on-carbondata.md
@@ -144,7 +144,18 @@ This tutorial is going to introduce all commands and data operations
on CarbonDa
 				   'streaming'='true',
                    'ALLOWED_COMPACTION_DAYS'='5')
    ```
-        
+
+## CREATE TABLE As SELECT
+  This function allows you to create a Carbon table from any of the Parquet/Hive/Carbon table.
This is beneficial when the user wants to create Carbon table from any other Parquet/Hive
table and use the Carbon query engine to query and achieve better query results for cases
where Carbon is faster than other file formats. Also this feature can be used for backing
up the data.
+  ```
+  CREATE TABLE [IF NOT EXISTS] [db_name.]table_name STORED BY 'carbondata' [TBLPROPERTIES
(key1=val1, key2=val2, ...)] AS select_statement;
+  ```
+
+### Examples
+  ```
+  CREATE TABLE ctas_select_parquet STORED BY 'carbondata' as select * from parquet_ctas_test;
+  ```
+   
 ## TABLE MANAGEMENT  
 
 ### SHOW TABLE


Mime
View raw message