Formatted Document
Project: http://git-wip-us.apache.org/repos/asf/incubator-carbondata/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-carbondata/commit/7962027d Tree: http://git-wip-us.apache.org/repos/asf/incubator-carbondata/tree/7962027d Diff: http://git-wip-us.apache.org/repos/asf/incubator-carbondata/diff/7962027d Branch: refs/heads/12-dev Commit: 7962027d8ea4d9fb5c20cb3723b65b7ed1e476ec Parents: 24d9fd2 Author: ksimar <simarpreetkaurmonga1...@gmail.com> Authored: Thu Apr 6 13:16:34 2017 +0530 Committer: chenliang613 <chenliang...@huawei.com> Committed: Fri Apr 7 14:51:55 2017 +0530 ---------------------------------------------------------------------- docs/quick-start-guide.md | 17 +++++++---------- 1 file changed, 7 insertions(+), 10 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/7962027d/docs/quick-start-guide.md ---------------------------------------------------------------------- diff --git a/docs/quick-start-guide.md b/docs/quick-start-guide.md index c29a8d3..5eec075 100644 --- a/docs/quick-start-guide.md +++ b/docs/quick-start-guide.md @@ -34,9 +34,7 @@ This tutorial provides a quick introduction to using CarbonData. EOF ``` -## Interactive Analysis with Spark Shell - -## Version 2.1 +## Interactive Analysis with Spark Shell Version 2.1 Apache Spark Shell provides a simple way to learn the API, as well as a powerful tool to analyze data interactively. Please visit [Apache Spark Documentation](http://spark.apache.org/docs/latest/) for more details on Spark shell. @@ -68,13 +66,13 @@ val carbon = SparkSession.builder().config(sc.getConf).getOrCreateCarbonSession( #### Executing Queries -##### Creating a Table +###### Creating a Table ``` scala>carbon.sql("CREATE TABLE IF NOT EXISTS test_table(id string, name string, city string, age Int) STORED BY 'carbondata'") ``` -##### Loading Data to a Table +###### Loading Data to a Table ``` scala>carbon.sql("LOAD DATA INPATH 'sample.csv file path' INTO TABLE test_table") @@ -89,8 +87,7 @@ scala>carbon.sql("SELECT * FROM test_table").show() scala>carbon.sql("SELECT city, avg(age), sum(age) FROM test_table GROUP BY city").show() ``` -## Interactive Analysis with Spark Shell -## Version 1.6 +## Interactive Analysis with Spark Shell Version 1.6 #### Basics @@ -117,7 +114,7 @@ val cc = new CarbonContext(sc, "<hdfs store path>") #### Executing Queries -##### Creating a Table +###### Creating a Table ``` scala>cc.sql("CREATE TABLE IF NOT EXISTS test_table (id string, name string, city string, age Int) STORED BY 'carbondata'") @@ -128,14 +125,14 @@ To see the table created : scala>cc.sql("SHOW TABLES").show() ``` -##### Loading Data to a Table +###### Loading Data to a Table ``` scala>cc.sql("LOAD DATA INPATH 'sample.csv file path' INTO TABLE test_table") ``` **NOTE**: Please provide the real file path of `sample.csv` for the above script. -##### Query Data from a Table +###### Query Data from a Table ``` scala>cc.sql("SELECT * FROM test_table").show()