[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 <sgururajshe...@gmail.com> Authored: Thu Feb 1 20:04:54 2018 +0530 Committer: manishgupta88 <tomanishgupt...@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
