You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@kylin.apache.org by sh...@apache.org on 2016/03/16 10:07:58 UTC
[2/2] kylin git commit: update doc for v1.5
update doc for v1.5
Project: http://git-wip-us.apache.org/repos/asf/kylin/repo
Commit: http://git-wip-us.apache.org/repos/asf/kylin/commit/a7502ea6
Tree: http://git-wip-us.apache.org/repos/asf/kylin/tree/a7502ea6
Diff: http://git-wip-us.apache.org/repos/asf/kylin/diff/a7502ea6
Branch: refs/heads/document
Commit: a7502ea6e339e5b7c580faede1addc81de104dc1
Parents: ff54ee5
Author: shaofengshi <sh...@apache.org>
Authored: Wed Mar 16 17:07:31 2016 +0800
Committer: shaofengshi <sh...@apache.org>
Committed: Wed Mar 16 17:07:40 2016 +0800
----------------------------------------------------------------------
website/_docs/gettingstarted/concepts.md | 2 -
website/_docs/gettingstarted/faq.md | 2 -
website/_docs/gettingstarted/terminology.md | 3 -
website/_docs/howto/howto_backup_hbase.md | 4 +-
website/_docs/howto/howto_backup_metadata.md | 4 +-
.../howto/howto_build_cube_with_restapi.md | 4 +-
website/_docs/howto/howto_cleanup_storage.md | 4 +-
website/_docs/howto/howto_jdbc.md | 4 +-
website/_docs/howto/howto_ldap_and_sso.md | 4 +-
website/_docs/howto/howto_optimize_cubes.md | 4 +-
website/_docs/howto/howto_upgrade.md | 4 +-
website/_docs/howto/howto_use_restapi.md | 4 +-
website/_docs/howto/howto_use_restapi_in_js.md | 4 +-
website/_docs/index.md | 56 +++---
website/_docs/install/advance_settings.md | 4 +-
website/_docs/install/hadoop_evn.md | 33 ++--
website/_docs/install/index.md | 12 --
website/_docs/tutorial/acl.md | 6 +-
website/_docs/tutorial/create_cube.md | 4 +-
website/_docs/tutorial/cube_build_job.md | 4 +-
website/_docs/tutorial/kylin_sample.md | 2 -
website/_docs/tutorial/odbc.md | 4 +-
website/_docs/tutorial/powerbi.md | 4 +-
website/_docs/tutorial/tableau.md | 4 +-
website/_docs/tutorial/tableau_91.md | 4 +-
website/_docs/tutorial/web.cn.md | 7 +-
website/_docs/tutorial/web.md | 12 +-
website/_docs15/howto/howto_backup_hbase.md | 2 +-
website/_docs15/howto/howto_backup_metadata.md | 3 +-
.../howto/howto_build_cube_with_restapi.md | 3 +-
website/_docs15/howto/howto_cleanup_storage.md | 10 +-
website/_docs15/howto/howto_jdbc.md | 3 +-
website/_docs15/howto/howto_ldap_and_sso.md | 3 +-
website/_docs15/howto/howto_optimize_cubes.md | 3 +-
website/_docs15/howto/howto_upgrade.md | 2 +-
website/_docs15/howto/howto_use_restapi.md | 4 +-
.../_docs15/howto/howto_use_restapi_in_js.md | 3 +-
website/_docs15/index.md | 62 +++----
website/_docs15/install/advance_settings.md | 1 -
website/_docs15/install/hadoop_evn.md | 28 +--
website/_docs15/install/index.md | 25 +--
website/_docs15/install/kylin_cluster.md | 1 -
website/_docs15/install/kylin_docker.md | 45 -----
website/_docs15/install/manual_install_guide.md | 47 -----
website/_docs15/tutorial/acl.md | 4 +-
website/_docs15/tutorial/create_cube.md | 184 +++++++++++++------
website/_docs15/tutorial/cube_build_job.md | 52 +++---
website/_docs15/tutorial/kylin_sample.md | 9 +-
website/_docs15/tutorial/odbc.md | 2 +-
website/_docs15/tutorial/powerbi.md | 2 +-
website/_docs15/tutorial/tableau.md | 3 +-
website/_docs15/tutorial/tableau_91.md | 3 +-
website/_docs15/tutorial/web.md | 73 +++-----
.../1 action-build.png | Bin 0 -> 179836 bytes
.../10 cube-segment.png | Bin 0 -> 149989 bytes
.../3 end-date.png | Bin 0 -> 71940 bytes
.../4 jobs-page.png | Bin 0 -> 143862 bytes
.../5 job-progress.png | Bin 0 -> 144015 bytes
.../6 discard.png | Bin 0 -> 156756 bytes
.../7 job-steps.png | Bin 0 -> 243944 bytes
.../8 hover-step.png | Bin 0 -> 170826 bytes
.../9 log-d.png | Bin 0 -> 213990 bytes
.../9 log.png | Bin 0 -> 71393 bytes
.../9 mrjob-d.png | Bin 0 -> 383848 bytes
.../9 mrjob.png | Bin 0 -> 74037 bytes
.../9 parameters-d.png | Bin 0 -> 199314 bytes
.../9 parameters.png | Bin 0 -> 74876 bytes
.../1 manage-prject.png | Bin 0 -> 20645 bytes
.../10 advanced-agg.png | Bin 0 -> 133261 bytes
.../10 advanced-rowkey.png | Bin 0 -> 99149 bytes
.../10 overview.png | Bin 0 -> 114816 bytes
.../Kylin-Cube-Creation-Tutorial/2 +project.png | Bin 0 -> 70968 bytes
.../3 new-project.png | Bin 0 -> 59611 bytes
.../3.1 pj-created.png | Bin 0 -> 51935 bytes
.../4 +table-tree.png | Bin 0 -> 47857 bytes
.../Kylin-Cube-Creation-Tutorial/4 +table.png | Bin 0 -> 46477 bytes
.../5 hive-table-cardinality.png | Bin 0 -> 130591 bytes
.../5 hive-table-info.png | Bin 0 -> 91887 bytes
.../5 hive-table-synced.png | Bin 0 -> 61775 bytes
.../5 hive-table-tree.png | Bin 0 -> 62040 bytes
.../5 hive-table.png | Bin 0 -> 53368 bytes
.../Kylin-Cube-Creation-Tutorial/6 +model.png | Bin 0 -> 49263 bytes
.../6 model-created.png | Bin 0 -> 29384 bytes
.../6 model-dimensions.png | Bin 0 -> 123120 bytes
.../6 model-fact-table.png | Bin 0 -> 113046 bytes
.../6 model-join-condition.png | Bin 0 -> 118661 bytes
.../6 model-lookup-table.png | Bin 0 -> 111371 bytes
.../6 model-measures.png | Bin 0 -> 80940 bytes
.../6 model-name.png | Bin 0 -> 109929 bytes
.../6 model-partition-column.png | Bin 0 -> 82155 bytes
.../7 cube-dimension-batch.png | Bin 0 -> 99014 bytes
.../7 cube-dimension-derived.png | Bin 0 -> 94281 bytes
.../7 cube-dimension-normal.png | Bin 0 -> 48160 bytes
.../7 cube-info.png | Bin 0 -> 147909 bytes
.../Kylin-Cube-Creation-Tutorial/7 new-cube.png | Bin 0 -> 36943 bytes
.../8 meas-+meas.png | Bin 0 -> 103579 bytes
.../8 measure-count.png | Bin 0 -> 59447 bytes
.../8 measure-distinct.png | Bin 0 -> 71554 bytes
.../8 measure-max.png | Bin 0 -> 64916 bytes
.../8 measure-min.png | Bin 0 -> 65880 bytes
.../8 measure-sum.png | Bin 0 -> 65951 bytes
.../8 measure-topn.png | Bin 0 -> 70942 bytes
.../9 refresh-setting1.png | Bin 0 -> 143698 bytes
.../tutorial/1.5/Kylin-Web-Tutorial/1 login.png | Bin 0 -> 27793 bytes
.../1.5/Kylin-Web-Tutorial/10 query-result.png | Bin 0 -> 79529 bytes
.../1.5/Kylin-Web-Tutorial/11 save-query.png | Bin 0 -> 29373 bytes
.../1.5/Kylin-Web-Tutorial/12 general.png | Bin 0 -> 26097 bytes
.../1.5/Kylin-Web-Tutorial/13 results.png | Bin 0 -> 77124 bytes
.../tutorial/1.5/Kylin-Web-Tutorial/14 drag.png | Bin 0 -> 81057 bytes
.../1.5/Kylin-Web-Tutorial/15 bar-chart.png | Bin 0 -> 79660 bytes
.../1.5/Kylin-Web-Tutorial/16 pie-chart.png | Bin 0 -> 91917 bytes
.../1.5/Kylin-Web-Tutorial/17 line-chart.png | Bin 0 -> 83227 bytes
.../1.5/Kylin-Web-Tutorial/2 tables.png | Bin 0 -> 287940 bytes
.../tutorial/1.5/Kylin-Web-Tutorial/3 cubes.png | Bin 0 -> 155306 bytes
.../1.5/Kylin-Web-Tutorial/4 form-view.png | Bin 0 -> 212896 bytes
.../1.5/Kylin-Web-Tutorial/5 sql-view.png | Bin 0 -> 171545 bytes
.../1.5/Kylin-Web-Tutorial/7 access.png | Bin 0 -> 158775 bytes
.../tutorial/1.5/Kylin-Web-Tutorial/8 query.png | Bin 0 -> 191367 bytes
.../1.5/Kylin-Web-Tutorial/9 query-table.png | Bin 0 -> 142843 bytes
119 files changed, 327 insertions(+), 453 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs/gettingstarted/concepts.md
----------------------------------------------------------------------
diff --git a/website/_docs/gettingstarted/concepts.md b/website/_docs/gettingstarted/concepts.md
index 248c10f..b79ca0f 100644
--- a/website/_docs/gettingstarted/concepts.md
+++ b/website/_docs/gettingstarted/concepts.md
@@ -3,8 +3,6 @@ layout: docs
title: "Technical Concepts"
categories: gettingstarted
permalink: /docs/gettingstarted/concepts.html
-version: v1.2
-since: v1.2
---
Here are some basic technical concepts used in Apache Kylin, please check them for your reference.
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs/gettingstarted/faq.md
----------------------------------------------------------------------
diff --git a/website/_docs/gettingstarted/faq.md b/website/_docs/gettingstarted/faq.md
index 24294ee..5f6e077 100644
--- a/website/_docs/gettingstarted/faq.md
+++ b/website/_docs/gettingstarted/faq.md
@@ -3,8 +3,6 @@ layout: docs
title: "FAQ"
categories: gettingstarted
permalink: /docs/gettingstarted/faq.html
-version: v0.7.2
-since: v0.6.x
---
### Some NPM error causes ERROR exit (中国大陆地区用户请特别注意此问题)?
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs/gettingstarted/terminology.md
----------------------------------------------------------------------
diff --git a/website/_docs/gettingstarted/terminology.md b/website/_docs/gettingstarted/terminology.md
index 0f9e669..277d60d 100644
--- a/website/_docs/gettingstarted/terminology.md
+++ b/website/_docs/gettingstarted/terminology.md
@@ -3,11 +3,8 @@ layout: docs
title: "Terminology"
categories: gettingstarted
permalink: /docs/gettingstarted/terminology.html
-version: v1.0
-since: v0.5.x
---
-
Here are some domain terms we are using in Apache Kylin, please check them for your reference.
They are basic knowledge of Apache Kylin which also will help to well understand such concerpt, term, knowledge, theory and others about Data Warehouse, Business Intelligence for analycits.
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs/howto/howto_backup_hbase.md
----------------------------------------------------------------------
diff --git a/website/_docs/howto/howto_backup_hbase.md b/website/_docs/howto/howto_backup_hbase.md
index 8714132..5a48520 100644
--- a/website/_docs/howto/howto_backup_hbase.md
+++ b/website/_docs/howto/howto_backup_hbase.md
@@ -1,10 +1,8 @@
---
layout: docs
-title: How to Clean/Backup HBase Tables
+title: Clean/Backup HBase Tables
categories: howto
permalink: /docs/howto/howto_backup_hbase.html
-version: v1.0
-since: v0.7.1
---
Kylin persists all data (meta data and cube) in HBase; You may want to export the data sometimes for whatever purposes
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs/howto/howto_backup_metadata.md
----------------------------------------------------------------------
diff --git a/website/_docs/howto/howto_backup_metadata.md b/website/_docs/howto/howto_backup_metadata.md
index cf250b7..2400f19 100644
--- a/website/_docs/howto/howto_backup_metadata.md
+++ b/website/_docs/howto/howto_backup_metadata.md
@@ -1,10 +1,8 @@
---
layout: docs
-title: How to Backup Metadata
+title: Backup Metadata
categories: howto
permalink: /docs/howto/howto_backup_metadata.html
-version: v1.0
-since: v0.7.1
---
Kylin organizes all of its metadata (including cube descriptions and instances, projects, inverted index description and instances, jobs, tables and dictionaries) as a hierarchy file system. However, Kylin uses hbase to store it, rather than normal file system. If you check your kylin configuration file(kylin.properties) you will find such a line:
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs/howto/howto_build_cube_with_restapi.md
----------------------------------------------------------------------
diff --git a/website/_docs/howto/howto_build_cube_with_restapi.md b/website/_docs/howto/howto_build_cube_with_restapi.md
index 4113700..f393b43 100644
--- a/website/_docs/howto/howto_build_cube_with_restapi.md
+++ b/website/_docs/howto/howto_build_cube_with_restapi.md
@@ -1,10 +1,8 @@
---
layout: docs
-title: How to Build Cube with Restful API
+title: Build Cube with RESTful API
categories: howto
permalink: /docs/howto/howto_build_cube_with_restapi.html
-version: v1.2
-since: v0.7.1
---
### 1. Authentication
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs/howto/howto_cleanup_storage.md
----------------------------------------------------------------------
diff --git a/website/_docs/howto/howto_cleanup_storage.md b/website/_docs/howto/howto_cleanup_storage.md
index ef35d68..e49d9ee 100644
--- a/website/_docs/howto/howto_cleanup_storage.md
+++ b/website/_docs/howto/howto_cleanup_storage.md
@@ -1,10 +1,8 @@
---
layout: docs
-title: How to Cleanup Storage (HDFS & HBase Tables)
+title: Cleanup Storage (HDFS & HBase Tables)
categories: howto
permalink: /docs/howto/howto_cleanup_storage.html
-version: v0.7.2
-since: v0.7.1
---
Kylin will generate intermediate files in HDFS during the cube building; Besides, when purge/drop/merge cubes, some HBase tables may be left in HBase and will no longer be queried; Although Kylin has started to do some
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs/howto/howto_jdbc.md
----------------------------------------------------------------------
diff --git a/website/_docs/howto/howto_jdbc.md b/website/_docs/howto/howto_jdbc.md
index 3e088fe..2b004ea 100644
--- a/website/_docs/howto/howto_jdbc.md
+++ b/website/_docs/howto/howto_jdbc.md
@@ -1,10 +1,8 @@
---
layout: docs
-title: How to Use kylin Remote JDBC Driver
+title: Use kylin JDBC Driver
categories: howto
permalink: /docs/howto/howto_jdbc.html
-version: v1.2
-since: v0.7.1
---
### Authentication
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs/howto/howto_ldap_and_sso.md
----------------------------------------------------------------------
diff --git a/website/_docs/howto/howto_ldap_and_sso.md b/website/_docs/howto/howto_ldap_and_sso.md
index 4711222..fd47912 100644
--- a/website/_docs/howto/howto_ldap_and_sso.md
+++ b/website/_docs/howto/howto_ldap_and_sso.md
@@ -1,10 +1,8 @@
---
layout: docs
-title: How to Enable Security with LDAP and SSO
+title: Enable Security with LDAP
categories: howto
permalink: /docs/howto/howto_ldap_and_sso.html
-version: v1.3
-since: v1.0
---
## Enable LDAP authentication
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs/howto/howto_optimize_cubes.md
----------------------------------------------------------------------
diff --git a/website/_docs/howto/howto_optimize_cubes.md b/website/_docs/howto/howto_optimize_cubes.md
index 4ebf7be..7646b2c 100644
--- a/website/_docs/howto/howto_optimize_cubes.md
+++ b/website/_docs/howto/howto_optimize_cubes.md
@@ -1,10 +1,8 @@
---
layout: docs
-title: How to Optimize Cubes
+title: Optimize Cubes
categories: howto
permalink: /docs/howto/howto_optimize_cubes.html
-version: v0.7.2
-since: v0.7.1
---
## Hierarchies:
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs/howto/howto_upgrade.md
----------------------------------------------------------------------
diff --git a/website/_docs/howto/howto_upgrade.md b/website/_docs/howto/howto_upgrade.md
index 87367ca..3177962 100644
--- a/website/_docs/howto/howto_upgrade.md
+++ b/website/_docs/howto/howto_upgrade.md
@@ -1,10 +1,8 @@
---
layout: docs
-title: How to Upgrade
+title: Upgrade from old version
categories: howto
permalink: /docs/howto/howto_upgrade.html
-version: v1.2
-since: v0.7.1
---
## Upgrade among v0.7.x and v1.x
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs/howto/howto_use_restapi.md
----------------------------------------------------------------------
diff --git a/website/_docs/howto/howto_use_restapi.md b/website/_docs/howto/howto_use_restapi.md
index a49a2db..f56b663 100644
--- a/website/_docs/howto/howto_use_restapi.md
+++ b/website/_docs/howto/howto_use_restapi.md
@@ -1,10 +1,8 @@
---
layout: docs
-title: How to Use Restful API
+title: Use RESTful API
categories: howto
permalink: /docs/howto/howto_use_restapi.html
-version: v1.2
-since: v0.7.1
---
This page lists all the Rest APIs provided by Kylin; The base of the URL is `/kylin/api`, so don't forget to add it before a certain API's path. For example, to get all cube instances, send HTTP GET request to "/kylin/api/cubes".
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs/howto/howto_use_restapi_in_js.md
----------------------------------------------------------------------
diff --git a/website/_docs/howto/howto_use_restapi_in_js.md b/website/_docs/howto/howto_use_restapi_in_js.md
index f41b3c5..137a919 100644
--- a/website/_docs/howto/howto_use_restapi_in_js.md
+++ b/website/_docs/howto/howto_use_restapi_in_js.md
@@ -1,10 +1,8 @@
---
layout: docs
-title: How to Use Restful API in Javascript
+title: Use RESTful API in Javascript
categories: howto
permalink: /docs/howto/howto_use_restapi_in_js.html
-version: v1.2
-since: v0.7.1
---
Kylin security is based on basic access authorization, if you want to use API in your javascript, you need to add authorization info in http headers.
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs/index.md
----------------------------------------------------------------------
diff --git a/website/_docs/index.md b/website/_docs/index.md
index 9732d1b..80395b9 100644
--- a/website/_docs/index.md
+++ b/website/_docs/index.md
@@ -15,39 +15,37 @@ Future documents: [v1.5](/docs15/)
Installation & Setup
------------
+2. [Hadoop Env](install/hadoop_env.html)
+1. [Installation Guide](install/index.html)
+3. [Advanced settings](install/advance_settings.html)
+4. [Deploy in cluster mode](install/kylin_cluster.html)
-Please follow installation & tutorial in the navigation panel.
-Advanced Topics
--------
-
-#### Connectivity
-
-1. [How to use Kylin remote JDBC driver](howto/howto_jdbc.html)
-2. [SQL reference](http://calcite.apache.org/)
-
----
-
-#### REST APIs
-
-1. [Kylin Restful API list](howto/howto_use_restapi.html)
-2. [Build cube with Restful API](howto/howto_build_cube_with_restapi.html)
-3. [How to consume Kylin REST API in javascript](howto/howto_use_restapi_in_js.html)
-
----
-
-#### Operations
-
-1. [Backup/restore Kylin metadata store](howto/howto_backup_metadata.html)
-2. [Cleanup storage (HDFS & HBase tables)](howto/howto_cleanup_storage.html)
-3. [Advanced env configurations](install/advance_settings.html)
-3. [How to upgrade](howto/howto_upgrade.html)
-
----
+Tutorial
+------------
+1. [Quick Start with Sample Cube](tutorial/kylin_sample.html)
+2. [Cube Creation](tutorial/create_cube.html)
+3. [Cube Build and Job Monitoring](tutorial/cube_build_job.html)
+4. [Web Interface](tutorial/web.html)
+5. [SQL reference: by Apache Calcite](http://calcite.apache.org/docs/reference.html)
-#### Technical Details
-1. [New meta data model structure](/development/new_metadata.html)
+Connectivity and APIs
+------------
+1. [ODBC driver](tutorial/odbc.html)
+2. [JDBC driver](howto/howto_jdbc.html)
+3. [RESTful API list](howto/howto_use_restapi.html)
+4. [Build cube with RESTful API](howto/howto_build_cube_with_restapi.html)
+5. [Call RESTful API in Javascript](howto/howto_use_restapi_in_js.html)
+6. [Connect from MS Excel and PowerBI](tutorial/powerbi.html)
+7. [Connect from Tableau 8](tutorial/tableau.html)
+8. [Connect from Tableau 9](tutorial/tableau_91.html)
+
+Operations
+------------
+1. [Backup/restore Kylin metadata](howto/howto_backup_metadata.html)
+2. [Cleanup storage (HDFS & HBase)](howto/howto_cleanup_storage.html)
+3. [Upgrade from old version](howto/howto_upgrade.html)
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs/install/advance_settings.md
----------------------------------------------------------------------
diff --git a/website/_docs/install/advance_settings.md b/website/_docs/install/advance_settings.md
index 3d3cae1..9392975 100644
--- a/website/_docs/install/advance_settings.md
+++ b/website/_docs/install/advance_settings.md
@@ -1,10 +1,8 @@
---
layout: docs
-title: "Advance Settings of Kylin Environment"
+title: "Advance Settings"
categories: install
permalink: /docs/install/advance_settings.html
-version: v0.7.2
-since: v0.7.1
---
## Enable LZO compression
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs/install/hadoop_evn.md
----------------------------------------------------------------------
diff --git a/website/_docs/install/hadoop_evn.md b/website/_docs/install/hadoop_evn.md
index d15ba72..de976cd 100644
--- a/website/_docs/install/hadoop_evn.md
+++ b/website/_docs/install/hadoop_evn.md
@@ -1,35 +1,40 @@
---
-layout: docs
+layout: docs15
title: "Hadoop Environment"
categories: install
-permalink: /docs/install/hadoop_env.html
-version: v0.7.2
-since: v0.7.1
+permalink: /docs15/install/hadoop_env.html
---
-## Hadoop Environment
+Kylin need run in a Hadoop node, to get better stability, we suggest you to deploy it a pure Hadoop client machine, on which it the command lines like `hive`, `hbase`, `hadoop`, `hdfs` already be installed and configured. The Linux account that running Kylin has got permission to the Hadoop cluster, including create/write hdfs, hive tables, hbase tables and submit MR jobs.
-Kylin requires you having access to a hadoop CLI, where you have full permissions to hdfs, hive, hbase and map-reduce. To make things easier we strongly recommend you starting with running Kylin on a hadoop sandbox, like <http://hortonworks.com/products/hortonworks-sandbox/>. In the following tutorial we'll go with **Hortonworks Sandbox 2.1** and **Cloudera QuickStart VM 5.1**.
+## Recommended Hadoop Versions
-To avoid permission issue, we suggest you using `root` account. The password for **Hortonworks Sandbox 2.1** is `hadoop` , for **Cloudera QuickStart VM 5.1** is `cloudera`.
+* Hadoop: 2.4 - 2.7
+* Hive: 0.13 - 0.14
+* HBase: 0.98 - 0.99
+* JDK: 1.7+
-We also suggest you using bridged mode instead of NAT mode in your virtual box settings. Bridged mode will assign your sandbox an independent IP so that you can avoid issues like https://github.com/KylinOLAP/Kylin/issues/12
+_Tested with Hortonworks HDP 2.2 and Cloudera Quickstart VM 5.1_
-### Start Hadoop
+To make things easier we strongly recommend you try Kylin with an all-in-one sandbox VM, like [HDP sandbox](http://hortonworks.com/products/hortonworks-sandbox/). In the following tutorial we'll go with **Hortonworks Sandbox 2.1** and **Cloudera QuickStart VM 5.1**.
+
+To avoid permission issue in the sandbox, you can use its `root` account. The password for **Hortonworks Sandbox 2.1** is `hadoop` , for **Cloudera QuickStart VM 5.1** is `cloudera`.
-Please make sure Hive, HDFS and HBase are available on your CLI machine.
-If you don't know how, here's a simple tutorial for hortonworks sanbox:
+We also suggest you using bridged mode instead of NAT mode in Virtual Box settings. Bridged mode will assign your sandbox an independent IP address so that you can avoid issues like [this](https://github.com/KylinOLAP/Kylin/issues/12).
+### Start Hadoop
Use ambari helps to launch hadoop:
+```
ambari-agent start
ambari-server start
-
-With both commands successfully run you can go to ambari homepage at <http://your_sandbox_ip:8080> (user:admin,password:admin) to check everything's status. **By default hortonworks ambari disables Hbase, you'll need manually start the `Hbase` service at ambari homepage.**
+```
+
+With both command successfully run you can go to ambari homepage at <http://your_sandbox_ip:8080> (user:admin,password:admin) to check everything's status. **By default hortonworks ambari disables Hbase, you need manually start the `Hbase` service at ambari homepage.**
-**Additonal Info for setting up HortonWorks Sandbox on Virtual Box**
+**Additonal Info for setting up Hortonworks Sandbox on Virtual Box**
Please make sure Hbase Master port [Default 60000] and Zookeeper [Default 2181] is forwarded to Host OS.
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs/install/index.md
----------------------------------------------------------------------
diff --git a/website/_docs/install/index.md b/website/_docs/install/index.md
index 984c73a..926f586 100644
--- a/website/_docs/install/index.md
+++ b/website/_docs/install/index.md
@@ -3,24 +3,12 @@ layout: docs
title: "Installation Guide"
categories: install
permalink: /docs/install/index.html
-version: v0.7.2
-since: v0.7.1
---
### Environment
Kylin requires a properly setup hadoop environment to run. Following are the minimal requests to run Kylin, for more detail, please check this reference: [Hadoop Environment](hadoop_env.html).
-## Recommended Hadoop Versions
-
-* Hadoop: 2.4 - 2.7
-* Hive: 0.13 - 0.14
-* HBase: 0.98 - 0.99
-* JDK: 1.7+
-
-_Tested with Hortonworks HDP 2.2 and Cloudera Quickstart VM 5.1_
-
-
It is the most common to install Kylin on a Hadoop client machine. It can be used for demo use, or for those who want to host their own web site to provide Kylin service. The scenario is depicted as:
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs/tutorial/acl.md
----------------------------------------------------------------------
diff --git a/website/_docs/tutorial/acl.md b/website/_docs/tutorial/acl.md
index abe923b..71a7342 100644
--- a/website/_docs/tutorial/acl.md
+++ b/website/_docs/tutorial/acl.md
@@ -1,14 +1,10 @@
---
layout: docs
-title: Kylin Cube Permission Grant Tutorial
+title: Kylin Cube Permissions
categories: tutorial
permalink: /docs/tutorial/acl.html
-version: v1.2
-since: v0.7.1
---
-
-
In `Cubes` page, double click the cube row to see the detail information. Here we focus on the `Access` tab.
Click the `+Grant` button to grant permission.
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs/tutorial/create_cube.md
----------------------------------------------------------------------
diff --git a/website/_docs/tutorial/create_cube.md b/website/_docs/tutorial/create_cube.md
index 966cdd5..6813dd0 100644
--- a/website/_docs/tutorial/create_cube.md
+++ b/website/_docs/tutorial/create_cube.md
@@ -1,10 +1,8 @@
---
layout: docs
-title: Kylin Cube Creation Tutorial
+title: Kylin Cube Creation
categories: tutorial
permalink: /docs/tutorial/create_cube.html
-version: v1.2
-since: v0.7.1
---
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs/tutorial/cube_build_job.md
----------------------------------------------------------------------
diff --git a/website/_docs/tutorial/cube_build_job.md b/website/_docs/tutorial/cube_build_job.md
index a1b1584..02814f4 100644
--- a/website/_docs/tutorial/cube_build_job.md
+++ b/website/_docs/tutorial/cube_build_job.md
@@ -1,10 +1,8 @@
---
layout: docs
-title: Kylin Cube Build and Job Monitoring Tutorial
+title: Kylin Cube Build and Job Monitoring
categories: tutorial
permalink: /docs/tutorial/cube_build_job.html
-version: v1.2
-since: v0.7.1
---
### Cube Build
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs/tutorial/kylin_sample.md
----------------------------------------------------------------------
diff --git a/website/_docs/tutorial/kylin_sample.md b/website/_docs/tutorial/kylin_sample.md
index a6cde53..585f1a9 100644
--- a/website/_docs/tutorial/kylin_sample.md
+++ b/website/_docs/tutorial/kylin_sample.md
@@ -3,8 +3,6 @@ layout: docs
title: Quick Start with Sample Cube
categories: tutorial
permalink: /docs/tutorial/kylin_sample.html
-version: v1.2
-since: v0.7.1
---
Kylin provides a script for you to create a sample Cube; the script will also create three sample hive tables:
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs/tutorial/odbc.md
----------------------------------------------------------------------
diff --git a/website/_docs/tutorial/odbc.md b/website/_docs/tutorial/odbc.md
index 96957ee..d4880c0 100644
--- a/website/_docs/tutorial/odbc.md
+++ b/website/_docs/tutorial/odbc.md
@@ -1,10 +1,8 @@
---
layout: docs
-title: Kylin ODBC Driver Tutorial
+title: Kylin ODBC Driver
categories: tutorial
permalink: /docs/tutorial/odbc.html
-version: v1.2
-since: v0.7.1
---
> We provide Kylin ODBC driver to enable data access from ODBC-compatible client applications.
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs/tutorial/powerbi.md
----------------------------------------------------------------------
diff --git a/website/_docs/tutorial/powerbi.md b/website/_docs/tutorial/powerbi.md
index 20cd782..0927dff 100644
--- a/website/_docs/tutorial/powerbi.md
+++ b/website/_docs/tutorial/powerbi.md
@@ -1,10 +1,8 @@
---
layout: docs
-title: MS Excel and Power BI Tutorial
+title: MS Excel and Power BI
categories: tutorial
permalink: /docs/tutorial/powerbi.html
-version: v1.2
-since: v1.2
---
Microsoft Excel is one of the most famous data tool on Windows platform, and has plenty of data analyzing functions. With Power Query installed as plug-in, excel can easily read data from ODBC data source and fill spreadsheets.
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs/tutorial/tableau.md
----------------------------------------------------------------------
diff --git a/website/_docs/tutorial/tableau.md b/website/_docs/tutorial/tableau.md
index f805bcc..1cf961e 100644
--- a/website/_docs/tutorial/tableau.md
+++ b/website/_docs/tutorial/tableau.md
@@ -1,10 +1,8 @@
---
layout: docs
-title: Tableau Tutorial
+title: Tableau 8
categories: tutorial
permalink: /docs/tutorial/tableau.html
-version: v1.2
-since: v0.7.1
---
> There are some limitations of Kylin ODBC driver with Tableau, please read carefully this instruction before you try it.
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs/tutorial/tableau_91.md
----------------------------------------------------------------------
diff --git a/website/_docs/tutorial/tableau_91.md b/website/_docs/tutorial/tableau_91.md
index c0f013c..9a2e1fc 100755
--- a/website/_docs/tutorial/tableau_91.md
+++ b/website/_docs/tutorial/tableau_91.md
@@ -1,10 +1,8 @@
---
layout: docs
-title: Tableau 9 Tutorial
+title: Tableau 9
categories: tutorial
permalink: /docs/tutorial/tableau_91.html
-version: v1.2
-since: v1.2
---
Tableau 9.x has been released a while, there are many users are asking about support this version with Apache Kylin. With updated Kylin ODBC Driver, now user could interactive with Kylin service through Tableau 9.x.
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs/tutorial/web.cn.md
----------------------------------------------------------------------
diff --git a/website/_docs/tutorial/web.cn.md b/website/_docs/tutorial/web.cn.md
index f3dbbac..fea2078 100644
--- a/website/_docs/tutorial/web.cn.md
+++ b/website/_docs/tutorial/web.cn.md
@@ -4,7 +4,6 @@ title: Kylin网页版教程
categories: 教程
permalink: /cn/docs/tutorial/web.html
version: v1.2
-since: v0.7.1
---
> **支持的浏览器**
@@ -14,7 +13,7 @@ since: v0.7.1
> Mac: Google Chrome, FireFox, Safari
## 1. 访问 & 登陆
-访问主机: http://your_sandbox_ip:9080
+访问主机: http://hostname:7070
使用用户名/密码登陆：ADMIN/KYLIN
@@ -133,7 +132,3 @@ Kylin的网页版提供一个简单的Pivot与可视化分析工具供用户探
-## 6. Cube建立 Job监控
-监控和管理cube建立过程与诊断的详细信息，甚至直接连接到Hadoop的job信息：
-
-
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs/tutorial/web.md
----------------------------------------------------------------------
diff --git a/website/_docs/tutorial/web.md b/website/_docs/tutorial/web.md
index f664a7b..d8e4ba8 100644
--- a/website/_docs/tutorial/web.md
+++ b/website/_docs/tutorial/web.md
@@ -1,20 +1,16 @@
---
layout: docs
-title: Kylin Web Tutorial
+title: Kylin Web Interface
categories: tutorial
permalink: /docs/tutorial/web.html
-version: v1.2
-since: v0.7.1
---
> **Supported Browsers**
->
> Windows: Google Chrome, FireFox
->
> Mac: Google Chrome, FireFox, Safari
## 1. Access & Login
-Host to access: http://your_sandbox_ip:9080
+Host to access: http://your_sandbox_ip:7070
Login with username/password: ADMIN/KYLIN
@@ -133,7 +129,3 @@ There's one simple pivot and visualization analysis tool in Kylin's web for user
-## 6. Cube Build Job Monitoring
-Monitor and manage cube build process, diagnostic into the detail and even link to Hadoop's job information directly:
-
-
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs15/howto/howto_backup_hbase.md
----------------------------------------------------------------------
diff --git a/website/_docs15/howto/howto_backup_hbase.md b/website/_docs15/howto/howto_backup_hbase.md
index 0c81924..e1eecd3 100644
--- a/website/_docs15/howto/howto_backup_hbase.md
+++ b/website/_docs15/howto/howto_backup_hbase.md
@@ -1,6 +1,6 @@
---
layout: docs15
-title: How to Clean/Backup HBase Tables
+title: Clean/Backup HBase Tables
categories: howto
permalink: /docs15/howto/howto_backup_hbase.html
since: v0.7.1
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs15/howto/howto_backup_metadata.md
----------------------------------------------------------------------
diff --git a/website/_docs15/howto/howto_backup_metadata.md b/website/_docs15/howto/howto_backup_metadata.md
index e006eb0..2b4eb30 100644
--- a/website/_docs15/howto/howto_backup_metadata.md
+++ b/website/_docs15/howto/howto_backup_metadata.md
@@ -1,9 +1,8 @@
---
layout: docs15
-title: How to Backup Metadata
+title: Backup Metadata
categories: howto
permalink: /docs15/howto/howto_backup_metadata.html
-since: v0.7.1
---
Kylin organizes all of its metadata (including cube descriptions and instances, projects, inverted index description and instances, jobs, tables and dictionaries) as a hierarchy file system. However, Kylin uses hbase to store it, rather than normal file system. If you check your kylin configuration file(kylin.properties) you will find such a line:
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs15/howto/howto_build_cube_with_restapi.md
----------------------------------------------------------------------
diff --git a/website/_docs15/howto/howto_build_cube_with_restapi.md b/website/_docs15/howto/howto_build_cube_with_restapi.md
index 42f96dc..e5f408b 100644
--- a/website/_docs15/howto/howto_build_cube_with_restapi.md
+++ b/website/_docs15/howto/howto_build_cube_with_restapi.md
@@ -1,9 +1,8 @@
---
layout: docs15
-title: How to Build Cube with Restful API
+title: Build Cube with RESTful API
categories: howto
permalink: /docs15/howto/howto_build_cube_with_restapi.html
-since: v0.7.1
---
### 1. Authentication
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs15/howto/howto_cleanup_storage.md
----------------------------------------------------------------------
diff --git a/website/_docs15/howto/howto_cleanup_storage.md b/website/_docs15/howto/howto_cleanup_storage.md
index 56cef19..f04a05f 100644
--- a/website/_docs15/howto/howto_cleanup_storage.md
+++ b/website/_docs15/howto/howto_cleanup_storage.md
@@ -1,9 +1,8 @@
---
layout: docs15
-title: How to Cleanup Storage (HDFS & HBase Tables)
+title: Cleanup Storage (HDFS & HBase Tables)
categories: howto
permalink: /docs15/howto/howto_cleanup_storage.html
-since: v1.5
---
Kylin will generate intermediate files in HDFS during the cube building; Besides, when purge/drop/merge cubes, some HBase tables may be left in HBase and will no longer be queried; Although Kylin has started to do some
@@ -12,11 +11,12 @@ automated garbage collection, it might not cover all cases; You can do an offlin
Steps:
1. Check which resources can be cleanup, this will not remove anything:
{% highlight Groff markup %}
-hbase org.apache.hadoop.util.RunJar ${KYLIN_HOME}/lib/kylin-job-(version).jar org.apache.kylin.storage.hbase.util.StorageCleanupJob --delete false
+export KYLIN_HOME=/path/to/kylin_home
+${KYLIN_HOME}/bin/kylin.sh org.apache.kylin.storage.hbase.util.StorageCleanupJob --delete false
{% endhighlight %}
Here please replace (version) with the specific Kylin jar version in your installation;
2. You can pickup 1 or 2 resources to check whether they're no longer be referred; Then add the "--delete true" option to start the cleanup:
{% highlight Groff markup %}
-hbase org.apache.hadoop.util.RunJar ${KYLIN_HOME}/lib/kylin-job-(version).jar org.apache.kylin.storage.hbase.util.StorageCleanupJob --delete true
+${KYLIN_HOME}/bin/kylin.sh org.apache.kylin.storage.hbase.util.StorageCleanupJob --delete true
{% endhighlight %}
-On finish, the intermediate HDFS location and HTables will be dropped;
+On finish, the intermediate HDFS location and HTables should be dropped;
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs15/howto/howto_jdbc.md
----------------------------------------------------------------------
diff --git a/website/_docs15/howto/howto_jdbc.md b/website/_docs15/howto/howto_jdbc.md
index d374685..0c8e11e 100644
--- a/website/_docs15/howto/howto_jdbc.md
+++ b/website/_docs15/howto/howto_jdbc.md
@@ -1,9 +1,8 @@
---
layout: docs15
-title: How to Use kylin Remote JDBC Driver
+title: Use kylin Remote JDBC Driver
categories: howto
permalink: /docs15/howto/howto_jdbc.html
-since: v0.7.1
---
### Authentication
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs15/howto/howto_ldap_and_sso.md
----------------------------------------------------------------------
diff --git a/website/_docs15/howto/howto_ldap_and_sso.md b/website/_docs15/howto/howto_ldap_and_sso.md
index 1780729..e1309cf 100644
--- a/website/_docs15/howto/howto_ldap_and_sso.md
+++ b/website/_docs15/howto/howto_ldap_and_sso.md
@@ -1,9 +1,8 @@
---
layout: docs15
-title: How to Enable Security with LDAP and SSO
+title: Enable Security with LDAP and SSO
categories: howto
permalink: /docs15/howto/howto_ldap_and_sso.html
-since: v1.5
---
## Enable LDAP authentication
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs15/howto/howto_optimize_cubes.md
----------------------------------------------------------------------
diff --git a/website/_docs15/howto/howto_optimize_cubes.md b/website/_docs15/howto/howto_optimize_cubes.md
index 5468347..2ab5c9c 100644
--- a/website/_docs15/howto/howto_optimize_cubes.md
+++ b/website/_docs15/howto/howto_optimize_cubes.md
@@ -1,9 +1,8 @@
---
layout: docs15
-title: How to Optimize Cubes
+title: Optimize Cube
categories: howto
permalink: /docs15/howto/howto_optimize_cubes.html
-since: v0.7.1
---
## Hierarchies:
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs15/howto/howto_upgrade.md
----------------------------------------------------------------------
diff --git a/website/_docs15/howto/howto_upgrade.md b/website/_docs15/howto/howto_upgrade.md
index 3219f2a..6c63d96 100644
--- a/website/_docs15/howto/howto_upgrade.md
+++ b/website/_docs15/howto/howto_upgrade.md
@@ -1,6 +1,6 @@
---
layout: docs15
-title: How to Upgrade
+title: Upgrade from old version
categories: howto
permalink: /docs15/howto/howto_upgrade.html
since: v1.5
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs15/howto/howto_use_restapi.md
----------------------------------------------------------------------
diff --git a/website/_docs15/howto/howto_use_restapi.md b/website/_docs15/howto/howto_use_restapi.md
index 511c95e..714eae0 100644
--- a/website/_docs15/howto/howto_use_restapi.md
+++ b/website/_docs15/howto/howto_use_restapi.md
@@ -1,12 +1,12 @@
---
layout: docs15
-title: How to Use Restful API
+title: Use RESTful API
categories: howto
permalink: /docs15/howto/howto_use_restapi.html
since: v0.7.1
---
-This page lists all the Rest APIs provided by Kylin; The base of the URL is `/kylin/api`, so don't forget to add it before a certain API's path. For example, to get all cube instances, send HTTP GET request to "/kylin/api/cubes".
+This page lists all the RESTful APIs provided by Kylin; The base of the URL is `/kylin/api`, so don't forget to add it before a certain API's path. For example, to get all cube instances, send HTTP GET request to "/kylin/api/cubes".
* Query
* [Authentication](#authentication)
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs15/howto/howto_use_restapi_in_js.md
----------------------------------------------------------------------
diff --git a/website/_docs15/howto/howto_use_restapi_in_js.md b/website/_docs15/howto/howto_use_restapi_in_js.md
index 34c7545..aaf346b 100644
--- a/website/_docs15/howto/howto_use_restapi_in_js.md
+++ b/website/_docs15/howto/howto_use_restapi_in_js.md
@@ -1,9 +1,8 @@
---
layout: docs15
-title: How to Use Restful API in Javascript
+title: Use RESTful API in Javascript
categories: howto
permalink: /docs15/howto/howto_use_restapi_in_js.html
-since: v0.7.1
---
Kylin security is based on basic access authorization, if you want to use API in your javascript, you need to add authorization info in http headers.
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs15/index.md
----------------------------------------------------------------------
diff --git a/website/_docs15/index.md b/website/_docs15/index.md
index e9d0762..c6022ab 100644
--- a/website/_docs15/index.md
+++ b/website/_docs15/index.md
@@ -5,50 +5,46 @@ categories: docs
permalink: /docs15/index.html
---
-Welcome to Apache Kylin™
+Welcome to Apache Kylin™: Extreme OLAP Engine for Big Data
------------
-> Extreme OLAP Engine for Big Data
-Apache Kylin™ is an open source Distributed Analytics Engine designed to provide SQL interface and multi-dimensional analysis (OLAP) on Hadoop supporting extremely large datasets, original contributed from eBay Inc.
+Apache Kylin™ is an open source Distributed Analytics Engine designed to provide SQL interface and multi-dimensional analysis (OLAP) on Hadoop supporting extremely large datasets.
Prior documents: [v1.3](/docs/)
Installation & Setup
------------
+2. [Hadoop Env](install/hadoop_env.html)
+1. [Installation Guide](install/index.html)
+3. [Advanced settings](install/advance_settings.html)
+4. [Deploy in cluster mode](install/kylin_cluster.html)
-Please follow installation & tutorial in the navigation panel.
-Advanced Topics
--------
-
-#### Connectivity
-
-1. [How to use Kylin remote JDBC driver](howto/howto_jdbc.html)
-2. [SQL reference](http://calcite.apache.org/)
-
----
-
-#### REST APIs
-
-1. [Kylin Restful API list](howto/howto_use_restapi.html)
-2. [Build cube with Restful API](howto/howto_build_cube_with_restapi.html)
-3. [How to consume Kylin REST API in javascript](howto/howto_use_restapi_in_js.html)
-
----
-
-#### Operations
-
-1. [Backup/restore Kylin metadata store](howto/howto_backup_metadata.html)
-2. [Cleanup storage (HDFS & HBase tables)](howto/howto_cleanup_storage.html)
-3. [Advanced env configurations](install/advance_settings.html)
-3. [How to upgrade](howto/howto_upgrade.html)
-
----
-
-#### Technical Details
+Tutorial
+------------
+1. [Quick Start with Sample Cube](tutorial/kylin_sample.html)
+2. [Cube Creation](tutorial/create_cube.html)
+3. [Cube Build and Job Monitoring](tutorial/cube_build_job.html)
+4. [Web Interface](tutorial/web.html)
+5. [SQL reference: by Apache Calcite](http://calcite.apache.org/docs/reference.html)
-1. [New meta data model structure](/development/new_metadata.html)
+Connectivity and APIs
+------------
+1. [ODBC driver](tutorial/odbc.html)
+2. [JDBC driver](howto/howto_jdbc.html)
+3. [RESTful API list](howto/howto_use_restapi.html)
+4. [Build cube with RESTful API](howto/howto_build_cube_with_restapi.html)
+5. [Call RESTful API in Javascript](howto/howto_use_restapi_in_js.html)
+6. [Connect from MS Excel and PowerBI](tutorial/powerbi.html)
+7. [Connect from Tableau 8](tutorial/tableau.html)
+8. [Connect from Tableau 9](tutorial/tableau_91.html)
+
+Operations
+------------
+1. [Backup/restore Kylin metadata](howto/howto_backup_metadata.html)
+2. [Cleanup storage (HDFS & HBase)](howto/howto_cleanup_storage.html)
+3. [Upgrade from old version](howto/howto_upgrade.html)
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs15/install/advance_settings.md
----------------------------------------------------------------------
diff --git a/website/_docs15/install/advance_settings.md b/website/_docs15/install/advance_settings.md
index 549aa57..a2da72c 100644
--- a/website/_docs15/install/advance_settings.md
+++ b/website/_docs15/install/advance_settings.md
@@ -3,7 +3,6 @@ layout: docs15
title: "Advance Settings of Kylin Environment"
categories: install
permalink: /docs15/install/advance_settings.html
-since: v0.7.1
---
## Enable LZO compression
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs15/install/hadoop_evn.md
----------------------------------------------------------------------
diff --git a/website/_docs15/install/hadoop_evn.md b/website/_docs15/install/hadoop_evn.md
index 7395de3..de976cd 100644
--- a/website/_docs15/install/hadoop_evn.md
+++ b/website/_docs15/install/hadoop_evn.md
@@ -3,32 +3,38 @@ layout: docs15
title: "Hadoop Environment"
categories: install
permalink: /docs15/install/hadoop_env.html
-since: v0.7.1
---
-## Hadoop Environment
+Kylin need run in a Hadoop node, to get better stability, we suggest you to deploy it a pure Hadoop client machine, on which it the command lines like `hive`, `hbase`, `hadoop`, `hdfs` already be installed and configured. The Linux account that running Kylin has got permission to the Hadoop cluster, including create/write hdfs, hive tables, hbase tables and submit MR jobs.
-Kylin requires you having access to a hadoop CLI, where you have full permissions to hdfs, hive, hbase and map-reduce. To make things easier we strongly recommend you starting with running Kylin on a hadoop sandbox, like <http://hortonworks.com/products/hortonworks-sandbox/>. In the following tutorial we'll go with **Hortonworks Sandbox 2.1** and **Cloudera QuickStart VM 5.1**.
+## Recommended Hadoop Versions
-To avoid permission issue, we suggest you using `root` account. The password for **Hortonworks Sandbox 2.1** is `hadoop` , for **Cloudera QuickStart VM 5.1** is `cloudera`.
+* Hadoop: 2.4 - 2.7
+* Hive: 0.13 - 0.14
+* HBase: 0.98 - 0.99
+* JDK: 1.7+
-We also suggest you using bridged mode instead of NAT mode in your virtual box settings. Bridged mode will assign your sandbox an independent IP so that you can avoid issues like https://github.com/KylinOLAP/Kylin/issues/12
+_Tested with Hortonworks HDP 2.2 and Cloudera Quickstart VM 5.1_
-### Start Hadoop
+To make things easier we strongly recommend you try Kylin with an all-in-one sandbox VM, like [HDP sandbox](http://hortonworks.com/products/hortonworks-sandbox/). In the following tutorial we'll go with **Hortonworks Sandbox 2.1** and **Cloudera QuickStart VM 5.1**.
+
+To avoid permission issue in the sandbox, you can use its `root` account. The password for **Hortonworks Sandbox 2.1** is `hadoop` , for **Cloudera QuickStart VM 5.1** is `cloudera`.
-Please make sure Hive, HDFS and HBase are available on our CLI machine.
-If you don't know how, here's a simple tutorial for hortonworks sanbox:
+We also suggest you using bridged mode instead of NAT mode in Virtual Box settings. Bridged mode will assign your sandbox an independent IP address so that you can avoid issues like [this](https://github.com/KylinOLAP/Kylin/issues/12).
+### Start Hadoop
Use ambari helps to launch hadoop:
+```
ambari-agent start
ambari-server start
-
-With both command successfully run you can go to ambari homepage at <http://your_sandbox_ip:8080> (user:admin,password:admin) to check everything's status. **By default hortonworks ambari disables Hbase, you'll need manually start the `Hbase` service at ambari homepage.**
+```
+
+With both command successfully run you can go to ambari homepage at <http://your_sandbox_ip:8080> (user:admin,password:admin) to check everything's status. **By default hortonworks ambari disables Hbase, you need manually start the `Hbase` service at ambari homepage.**
-**Additonal Info for setting up HortonWorks Sandbox on Virtual Box**
+**Additonal Info for setting up Hortonworks Sandbox on Virtual Box**
Please make sure Hbase Master port [Default 60000] and Zookeeper [Default 2181] is forwarded to Host OS.
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs15/install/index.md
----------------------------------------------------------------------
diff --git a/website/_docs15/install/index.md b/website/_docs15/install/index.md
index f48236f..da3b999 100644
--- a/website/_docs15/install/index.md
+++ b/website/_docs15/install/index.md
@@ -3,24 +3,13 @@ layout: docs15
title: "Installation Guide"
categories: install
permalink: /docs15/install/index.html
-since: v0.7.1
---
### Environment
-Kylin requires a properly setup hadoop environment to run. Following are the minimal request to run Kylin, for more detial, please check this reference: [Hadoop Environment](hadoop_env.html).
+Kylin requires a properly setup Hadoop environment to run. Following are the minimal request to run Kylin, for more detial, please check [Hadoop Environment](hadoop_env.html).
-## Recommended Hadoop Versions
-
-* Hadoop: 2.4 - 2.7
-* Hive: 0.13 - 0.14
-* HBase: 0.98 - 0.99
-* JDK: 1.7+
-
-_Tested with Hortonworks HDP 2.2 and Cloudera Quickstart VM 5.1_
-
-
-It is most common to install Kylin on a Hadoop client machine. It can be used for demo use, or for those who want to host their own web site to provide Kylin service. The scenario is depicted as:
+It is most common to install Kylin on a Hadoop client machine, from which Kylin can talk with the Hadoop cluster via command lines including `hive`, `hbase`, `hadoop`, etc. The scenario is depicted as:
@@ -33,14 +22,14 @@ Except for some prerequisite software installations, the core of Kylin installat
1. Download latest Kylin binaries at [http://kylin.apache.org/download](http://kylin.apache.org/download)
2. Export KYLIN_HOME pointing to the extracted Kylin folder
3. Make sure the user has the privilege to run hadoop, hive and hbase cmd in shell. If you are not so sure, you can run **bin/check-env.sh**, it will print out the detail information if you have some environment issues.
-4. To start Kylin, simply run **bin/kylin.sh start**
-5. To stop Kylin, simply run **bin/kylin.sh stop**
+4. To start Kylin, run **bin/kylin.sh start**, after the server starts, you can watch logs/kylin.log for runtime logs;
+5. To stop Kylin, run **bin/kylin.sh stop**
-> If you want to have multiple Kylin nodes please refer to [this](kylin_cluster.html)
+> If you want to have multiple Kylin nodes running to provide high availability, please refer to [this](kylin_cluster.html)
-After Kylin started you can visit <http://your_hostname:7070/kylin>. The username/password is ADMIN/KYLIN. It's a clean Kylin homepage with nothing in there. To start with you can:
+After Kylin started you can visit <http://hostname:7070/kylin>. The default username/password is ADMIN/KYLIN. It's a clean Kylin homepage with nothing in there. To start with you can:
1. [Quick play with a sample cube](../tutorial/kylin_sample.html)
-2. [Create and Build your own cube](../tutorial/create_cube.html)
+2. [Create and Build a cube](../tutorial/create_cube.html)
3. [Kylin Web Tutorial](../tutorial/web.html)
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs15/install/kylin_cluster.md
----------------------------------------------------------------------
diff --git a/website/_docs15/install/kylin_cluster.md b/website/_docs15/install/kylin_cluster.md
index 4ab65e0..225b14c 100644
--- a/website/_docs15/install/kylin_cluster.md
+++ b/website/_docs15/install/kylin_cluster.md
@@ -3,7 +3,6 @@ layout: docs15
title: "Multiple Kylin REST servers"
categories: install
permalink: /docs15/install/kylin_cluster.html
-since: v0.7.1
---
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs15/install/kylin_docker.md
----------------------------------------------------------------------
diff --git a/website/_docs15/install/kylin_docker.md b/website/_docs15/install/kylin_docker.md
deleted file mode 100644
index 9ae9243..0000000
--- a/website/_docs15/install/kylin_docker.md
+++ /dev/null
@@ -1,45 +0,0 @@
----
-layout: docs15
-title: "On Hadoop Kylin installation using Docker"
-categories: install
-permalink: /docs15/install/kylin_docker.html
-since: v0.6
----
-
-With help of SequenceIQ, we have put together a fully automated method of creating a Kylin cluster (along with Hadoop, HBase and Hive). The only thing you will need to do is to pull the container from the official Docker repository by using the commands listed below:
-
-### Pre-Requisite
-
-1. Docker (If you don't have Docker installed, follow this [link](https://docs.docker.com/installation/#installation))
-2. Minimum RAM - 4Gb (We'll be running Kylin, Hadoop, HBase & Hive)
-
-### Installation
-{% highlight Groff markup %}
-docker pull sequenceiq/kylin:0.7.2
-{% endhighlight %}
-
-Once the container is pulled you are ready to start playing with Kylin. Get the following helper functions from our Kylin GitHub [repository](https://github.com/sequenceiq/docker-kylin/blob/master/ambari-functions) - _(make sure you source it)._
-
-{% highlight Groff markup %}
- $ wget https://raw.githubusercontent.com/sequenceiq/docker-kylin/master/ambari-functions
- $ source ambari-functions
-{% endhighlight %}
-{% highlight Groff markup %}
- $ kylin-deploy-cluster 1
-{% endhighlight %}
-
-You can specify the number of nodes you'd like to have in your cluster (1 in this case). Once we installed all the necessary Hadoop
-services we'll build Kylin on top of it and then you can reach the UI on:
-{% highlight Groff markup %}
-#Ambari Dashboard
-http://<container_ip>:8080
-{% endhighlight %}
-Use `admin/admin` to login. Make sure HBase is running.
-
-{% highlight Groff markup %}
-#Kylin Dashboard
-http://<container_ip>:7070/kylin
-{% endhighlight %}
-The default credentials to login are: `ADMIN:KYLIN`.
-The cluster is pre-populated with sample data and is ready to build cubes as shown [here](../tutorial/create_cube.html).
-
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs15/install/manual_install_guide.md
----------------------------------------------------------------------
diff --git a/website/_docs15/install/manual_install_guide.md b/website/_docs15/install/manual_install_guide.md
deleted file mode 100644
index 29989cd..0000000
--- a/website/_docs15/install/manual_install_guide.md
+++ /dev/null
@@ -1,47 +0,0 @@
----
-layout: docs15
-title: Manual Installation Guide
-categories: install
-permalink: /docs15/install/manual_install_guide.html
-since: v0.7.1
----
-
-## INTRODUCTION
-
-In most cases our automated script [Installation Guide](index.html) can help you launch Kylin in your hadoop sandbox and even your hadoop cluster. However, in case something went wrong in the deploy script, this article comes as an reference guide to fix your issues.
-
-Basically this article explains every step in the automatic script. We assume that you are already very familiar with Hadoop operations on Linux.
-
-## PREREQUISITES
-* Tomcat installed, with CATALINA_HOME exported.
-* Kylin binary pacakge copied to local and setup $KYLIN_HOME correctly
-
-## STEPS
-
-### 4. Prepare Jars
-
-There are two jars that Kylin will need to use, there two jars and configured in the default kylin.properties:
-
-```
-kylin.job.jar=/tmp/kylin/kylin-job-latest.jar
-
-```
-
-This is job jar that Kylin uses for MR jobs. You need to copy $KYLIN_HOME/job/target/kylin-job-latest.jar to /tmp/kylin/
-
-```
-kylin.coprocessor.local.jar=/tmp/kylin/kylin-coprocessor-latest.jar
-
-```
-
-This is a hbase coprocessor jar that Kylin will put on hbase. It is used for performance boosting. You need to copy $KYLIN_HOME/storage/target/kylin-coprocessor-latest.jar to /tmp/kylin/
-
-### 5. Start Kylin
-
-Start Kylin with
-
-`./kylin.sh start`
-
-and stop Kylin with
-
-`./Kylin.sh stop`
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs15/tutorial/acl.md
----------------------------------------------------------------------
diff --git a/website/_docs15/tutorial/acl.md b/website/_docs15/tutorial/acl.md
index c98f29d..b777f9e 100644
--- a/website/_docs15/tutorial/acl.md
+++ b/website/_docs15/tutorial/acl.md
@@ -1,13 +1,11 @@
---
layout: docs15
-title: Kylin Cube Permission Grant Tutorial
+title: Kylin Cube Permission
categories: tutorial
permalink: /docs15/tutorial/acl.html
since: v0.7.1
---
-
-
In `Cubes` page, double click the cube row to see the detail information. Here we focus on the `Access` tab.
Click the `+Grant` button to grant permission.
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs15/tutorial/create_cube.md
----------------------------------------------------------------------
diff --git a/website/_docs15/tutorial/create_cube.md b/website/_docs15/tutorial/create_cube.md
index 5f87c7c..8626e4a 100644
--- a/website/_docs15/tutorial/create_cube.md
+++ b/website/_docs15/tutorial/create_cube.md
@@ -1,128 +1,198 @@
---
layout: docs15
-title: Kylin Cube Creation Tutorial
+title: Kylin Cube Creation
categories: tutorial
permalink: /docs15/tutorial/create_cube.html
-since: v0.7.1
---
-
+
+This tutorial will guide you to create a cube. It need you have at least 1 sample table in Hive. If you don't have, you can follow this to create some data.
### I. Create a Project
1. Go to `Query` page in top menu bar, then click `Manage Projects`.
- 
+ 
2. Click the `+ Project` button to add a new project.
- 
+ 
-3. Fulfill the following form and click `submit` button to send a request.
+3. Enter a project name, e.g, "Tutorial", with a description (optional), then click `submit` button to send the request.
- 
+ 
-4. After success, there will be a notification show in the bottom.
+4. After success, the project will show in the table.
- 
+ 
-### II. Sync up a Table
-1. Click `Tables` in top bar and then click the `+ Sync` button to load hive table metadata.
+### II. Sync up Hive Table
+1. Click `Model` in top bar and then click `Data Source` tab in the left part, it lists all the tables loaded into Kylin; click `Load Hive Table` button.
- 
+ 
-2. Enter the table names and click `Sync` to send a request.
+2. Enter the hive table names, separated with commad, and then click `Sync` to send the request.
- 
+ 
-### III. Create a Cube
-To start with, click `Cubes` in top bar.Then click `+Cube` button to enter the cube designer page.
+3. [Optional] If you want to browser the hive database to pick tables, click the `Load Hive Table From Tree` button.
-
+ 
-**Step 1. Cube Info**
+4. [Optional] Expand the database node, click to select the table to load, and then click `Sync`.
-Fill up the basic information of the cube. Click `Next` to enter the next step.
+ 
-You can use letters, numbers and '_' to name your cube (Notice that space in name is not allowed).
+5. A success message will pop up. In the left `Tables` section, the newly loaded table is added. Click the table name will expand the columns.
-
+ 
-**Step 2. Dimensions**
+6. In the background, Kylin will run a MapReduce job to calculate the approximate cardinality for the newly synced table. After the job be finished, refresh web page and then click the table name, the cardinality will be shown in the table info.
+
+ 
+
+
+### III. Create Data Model
+Before create a cube, need define a data model. The data model defines the star schema. One data model can be reused in multiple cubes.
+
+1. Click `Model` in top bar, and then click `Models` tab. Click `+New` button, in the drop-down list select `New Model`.
+
+ 
+
+2. Enter a name for the model, with an optional description.
+
+ 
+
+3. In the `Fact Table` box, select the fact table of this data model.
+
+ 
+
+4. [Optional] Click `Add Lookup Table` button to add a lookup table. Select the table name and join type (inner or left).
+
+ 
+
+5. [Optional] Click `New Join Condition` button, select the FK column of fact table in the left, and select the PK column of lookup table in the right side. Repeat this if have more than one join columns.
+
+ 
+
+6. Click "OK", repeat step 4 and 5 to add more lookup tables if any. After finished, click "Next".
+
+7. The "Dimensions" page allows to select the columns that will be used as dimension in the child cubes. Click the `Columns` cell of a table, in the drop-down list select the column to the list.
+
+ 
+
+8. Click "Next" go to the "Measures" page, select the columns that will be used in measure/metrics. The measure column can only from fact table.
+
+ 
-1. Set up the fact table.
+9. Click "Next" to the "Settings" page. If the data in fact table increases by day, select the corresponding date column in the `Partition Date Column`, and select the date format, otherwise leave it as blank.
- 
+10. [Optional] Select `Cube Size`, which is an indicator on the scale of the cube, by default it is `MEDIUM`.
-2. Click `+Dimension` to add a new dimension.
+11. [Optional] If some records want to excluded from the cube, like dirty data, you can input the condition in `Filter`.
- 
-3. There are different types of dimensions that might be added to a cube. Here we list some of them for your reference.
+ 
- * Dimensions from fact table.
- 
+12. Click `Save` and then select `Yes` to save the data model. After created, the data model will be shown in the left `Models` list.
- * Dimensions from look up table.
- 
+ 
- 
-
- * Dimensions from look up table with hierarchy.
- 
+### IV. Create Cube
+After the data model be created, you can start to create cube.
- * Dimensions from look up table with derived dimensions.
- 
+Click `Model` in top bar, and then click `Models` tab. Click `+New` button, in the drop-down list select `New Cube`.
-4. User can edit the dimension after saving it.
- 
+ 
+
+**Step 1. Cube Info**
+
+Select the data model, enter the cube name; Click `Next` to enter the next step.
+
+You can use letters, numbers and '_' to name your cube (blank space in name is not allowed). `Notification List` is a list of email addresses which be notified on cube job success/failure.
+
+ 
+
+**Step 2. Dimensions**
+
+1. Click `Add Dimension`, it popups two option: "Normal" and "Derived": "Normal" is to add a normal independent dimension column, "Derived" is to add a derived dimension column. Read more in [How to optimize cubes](/docs15/howto/howto_optimize_cubes.html).
+
+2. Click "Normal" and then select a dimension column, give it a meaningful name.
+
+ 
+
+3. [Optional] Click "Derived" and then pickup 1 more multiple columns on lookup table, give them a meaningful name.
+
+ 
+
+4. Repeate 2 and 3 to add all dimension columns; you can do this in batch for "Normal" dimension with the button `Auto Generator`.
+
+ 
+
+5. Click "Next" after select all dimensions.
**Step 3. Measures**
1. Click the `+Measure` to add a new measure.
- 
+ 
-2. There are 5 different types of measure according to its expression: `SUM`, `MAX`, `MIN`, `COUNT` and `COUNT_DISTINCT`. Please be carefully to choose the return type, which is related to the error rate of the `COUNT(DISTINCT)`.
+2. There are 6 types of measure according to its expression: `SUM`, `MAX`, `MIN`, `COUNT`, `COUNT_DISTINCT` and `TOP_N`. Properly select the return type for `COUNT_DISTINCT` and `TOP_N`, as it will impact on the cube size.
* SUM
- 
+ 
* MIN
- 
+ 
* MAX
- 
+ 
* COUNT
- 
+ 
* DISTINCT_COUNT
+ This measure has two implementations:
+ a) approximate implementation with HyperLogLog, select an acceptable error rate, lower error rate will take more storage.
+ b) precise implementation with bitmap (see limitation in https://issues.apache.org/jira/browse/KYLIN-1186).
+
+ 
+
+ Pleaste note: distinct count is a very heavy data type, it is slower to build and query comparing to other measures.
- 
+ * TOP_N
+ Approximate TopN measure pre-calculates the top records in each dimension combination, it will provide higher performance in query time than no pre-calculation; Need specify two parameters here: the first is the column will be used as metrics for Top records (aggregated with SUM and then sorted in descending order); the second is the literal ID, represents the record like seller_id;
-**Step 4. Filter**
+ Properly select the return type, depends on how many top records to inspect: top 10, top 100 or top 1000.
-This step is optional. You can add some condition filter in `SQL` format.
+ 
-
-**Step 5. Refresh Setting**
+**Step 4. Refresh Setting**
This step is designed for incremental cube build.
-
+`Auto Merge Time Ranges (days)`: merge the small segments into medium and large segment automatically. If you don't want to auto merge, remove the default two ranges.
-Choose partition type, partition column and start date.
+`Retention Range (days)`: only keep the segment whose data is in past given days in cube, the old segment will be automatically dropped from head; 0 means not enable this feature.
-
+`Partition Start Date`: the start date of this cube.
-**Step 6. Advanced Setting**
+
-
+**Step 5. Advanced Setting**
-**Step 7. Overview & Save**
+`Aggregation Groups`: by default Kylin put all dimensions into one aggregation group; you can create multiple aggregation groups by knowing well about your query patterns. For the concepts of "Mandatory Dimensions", "Hierarchy Dimensions" and "Joint Dimensions", read this blog: [New Aggregation Group](/blog/2016/02/18/new-aggregation-group/)
+
+`Rowkeys`: the rowkeys are composed by the dimension encoded values. "Dictionary" is the default encoding method; If a dimension is not fit with dictionary (e.g., cardinality > 10 million), select "false" and then enter the fixed length for that dimension, usually that is the max. length of that column; if a value is longer than that size it will be truncated. Please note, without dictionary encoding, the cube size might be much bigger.
+
+You can drag & drop a dimension column to adjust its position in rowkey; Put the mandantory dimension at the begining, then followed the dimensions that heavily involved in filters (where condition). Put high cardinality dimensions ahead of low cardinality dimensions.
+
+
+**Step 6. Overview & Save**
You can overview your cube and go back to previous step to modify it. Click the `Save` button to complete the cube creation.
-
+
+
+Cheers! now the cube is created, you can go ahead to build and play it.
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs15/tutorial/cube_build_job.md
----------------------------------------------------------------------
diff --git a/website/_docs15/tutorial/cube_build_job.md b/website/_docs15/tutorial/cube_build_job.md
index 0d3d6ab..9de3bd5 100644
--- a/website/_docs15/tutorial/cube_build_job.md
+++ b/website/_docs15/tutorial/cube_build_job.md
@@ -1,65 +1,67 @@
---
layout: docs15
-title: Kylin Cube Build and Job Monitoring Tutorial
+title: Kylin Cube Build and Job Monitoring
categories: tutorial
permalink: /docs15/tutorial/cube_build_job.html
-since: v0.7.1
---
### Cube Build
First of all, make sure that you have authority of the cube you want to build.
-1. In `Cubes` page, click the `Action` drop down button in the right of a cube column and select operation `Build`.
+1. In `Models` page, click the `Action` drop down button in the right of a cube column and select operation `Build`.
- 
+ 
-2. There is a pop-up window after the selection.
+2. There is a pop-up window after the selection, click `END DATE` input box to select end date of this incremental cube build.
- 
+ 
-3. Click `END DATE` input box to choose end date of this incremental cube build.
+4. Click `Submit` to send the build request. After success, you will see the new job in the `Monitor` page.
- 
+ 
-4. Click `Submit` to send request.
+5. The new job is in "pending" status; after a while, it will be started to run and you will see the progress by refresh the web page or click the refresh button.
- 
+ 
- 
- After submit the request successfully, you will see the job just be created in the `Jobs` page.
+6. Wait the job to finish. In the between if you want to discard it, click `Actions` -> `Discard` button.
- 
+ 
-5. To discard this job, just click the `Discard` button.
+7. After the job is 100% finished, the cube's status becomes to "Ready", means it is ready to serve SQL queries. In the `Model` tab, find the cube, click cube name to expand the section, in the "HBase" tab, it will list the cube segments. Each segment has a start/end time; Its underlying HBase table information is also listed.
- 
+ 
+
+If you have more source data, repeate the steps above to build them into the cube.
### Job Monitoring
-In the `Jobs` page, click the job detail button to see detail information show in the right side.
+In the `Monitor` page, click the job detail button to see detail information show in the right side.
-
+
The detail information of a job provides a step-by-step record to trace a job. You can hover a step status icon to see the basic status and information.
-
+
-Click the icon button show in each step to see the details: `Parameters`, `Log`, `MRJob`, `EagleMonitoring`.
+Click the icon buttons showing in each step to see the details: `Parameters`, `Log`, `MRJob`.
* Parameters
- 
+ 
- 
+ 
* Log
- 
+ 
- 
+ 
* MRJob(MapReduce Job)
- 
+ 
+
+ 
+
- 
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs15/tutorial/kylin_sample.md
----------------------------------------------------------------------
diff --git a/website/_docs15/tutorial/kylin_sample.md b/website/_docs15/tutorial/kylin_sample.md
index ea0fb88..4188b18 100644
--- a/website/_docs15/tutorial/kylin_sample.md
+++ b/website/_docs15/tutorial/kylin_sample.md
@@ -3,20 +3,19 @@ layout: docs15
title: Quick Start with Sample Cube
categories: tutorial
permalink: /docs15/tutorial/kylin_sample.html
-since: v0.7.1
---
Kylin provides a script for you to create a sample Cube; the script will also create three sample hive tables:
1. Run ${KYLIN_HOME}/bin/sample.sh ; Restart kylin server to flush the caches;
-2. Logon Kylin web, select project "learn_kylin";
+2. Logon Kylin web with default user ADMIN/KYLIN, select project "learn_kylin" in the project dropdown list (left upper corner);
3. Select the sample cube "kylin_sales_cube", click "Actions" -> "Build", pick up a date later than 2014-01-01 (to cover all 10000 sample records);
-4. Check the build progress in "Jobs" tab, until 100%;
-5. Execute SQLs in the "Query" tab, for example:
+4. Check the build progress in "Monitor" tab, until 100%;
+5. Execute SQLs in the "Insight" tab, for example:
select part_dt, sum(price) as total_selled, count(distinct seller_id) as sellers from kylin_sales group by part_dt order by part_dt
6. You can verify the query result and compare the response time with hive;
## What's next
-After cube being built, please refer to other document of this tutorial for more detail information.
+You can create another cube with the sample tables, by following the tutorials.
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs15/tutorial/odbc.md
----------------------------------------------------------------------
diff --git a/website/_docs15/tutorial/odbc.md b/website/_docs15/tutorial/odbc.md
index 01e6e0b..e84890d 100644
--- a/website/_docs15/tutorial/odbc.md
+++ b/website/_docs15/tutorial/odbc.md
@@ -1,6 +1,6 @@
---
layout: docs15
-title: Kylin ODBC Driver Tutorial
+title: Kylin ODBC Driver
categories: tutorial
permalink: /docs15/tutorial/odbc.html
since: v0.7.1
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs15/tutorial/powerbi.md
----------------------------------------------------------------------
diff --git a/website/_docs15/tutorial/powerbi.md b/website/_docs15/tutorial/powerbi.md
index 12ffaea..9f62e8f 100644
--- a/website/_docs15/tutorial/powerbi.md
+++ b/website/_docs15/tutorial/powerbi.md
@@ -1,6 +1,6 @@
---
layout: docs15
-title: MS Excel and Power BI Tutorial
+title: MS Excel and Power BI
categories: tutorial
permalink: /docs15/tutorial/powerbi.html
since: v1.2
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs15/tutorial/tableau.md
----------------------------------------------------------------------
diff --git a/website/_docs15/tutorial/tableau.md b/website/_docs15/tutorial/tableau.md
index 8d668dc..cd8bdd7 100644
--- a/website/_docs15/tutorial/tableau.md
+++ b/website/_docs15/tutorial/tableau.md
@@ -1,9 +1,8 @@
---
layout: docs15
-title: Tableau Tutorial
+title: Tableau 8
categories: tutorial
permalink: /docs15/tutorial/tableau.html
-since: v0.7.1
---
> There are some limitations of Kylin ODBC driver with Tableau, please read carefully this instruction before you try it.
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs15/tutorial/tableau_91.md
----------------------------------------------------------------------
diff --git a/website/_docs15/tutorial/tableau_91.md b/website/_docs15/tutorial/tableau_91.md
index 37e5527..8eafad0 100644
--- a/website/_docs15/tutorial/tableau_91.md
+++ b/website/_docs15/tutorial/tableau_91.md
@@ -1,9 +1,8 @@
---
layout: docs15
-title: Tableau 9 Tutorial
+title: Tableau 9
categories: tutorial
permalink: /docs15/tutorial/tableau_91.html
-since: v1.2
---
Tableau 9.x has been released a while, there are many users are asking about support this version with Apache Kylin. With updated Kylin ODBC Driver, now user could interactive with Kylin service through Tableau 9.x.
http://git-wip-us.apache.org/repos/asf/kylin/blob/a7502ea6/website/_docs15/tutorial/web.md
----------------------------------------------------------------------
diff --git a/website/_docs15/tutorial/web.md b/website/_docs15/tutorial/web.md
index c2b29bd..4d7de76 100644
--- a/website/_docs15/tutorial/web.md
+++ b/website/_docs15/tutorial/web.md
@@ -1,50 +1,43 @@
---
layout: docs15
-title: Kylin Web Tutorial
+title: Kylin Web Interface
categories: tutorial
permalink: /docs15/tutorial/web.html
-since: v0.7.1
---
> **Supported Browsers**
->
> Windows: Google Chrome, FireFox
->
> Mac: Google Chrome, FireFox, Safari
## 1. Access & Login
-Host to access: http://your_sandbox_ip:9080
+Host to access: http://hostname:7070
Login with username/password: ADMIN/KYLIN
-
+
-## 2. Available Hive Tables in Kylin
+## 2. Sync Hive Table into Kylin
Although Kylin will using SQL as query interface and leverage Hive metadata, kylin will not enable user to query all hive tables since it's a pre-build OLAP (MOLAP) system so far. To enable Table in Kylin, it will be easy to using "Sync" function to sync up tables from Hive.
-
+
## 3. Kylin OLAP Cube
-Kylin's OLAP Cubes are pre-calculation datasets from Star Schema Hive tables, Here's the web management interface for user to explorer, manage all cubes.Go to `Cubes` Menu, it will list all cubes available in system:
+Kylin's OLAP Cubes are pre-calculation datasets from star schema tables, Here's the web interface for user to explorer, manage all cubes. Go to `Model` menu, it will list all cubes available in system:
-
+
To explore more detail about the Cube
* Form View:
- 
+ 
* SQL View (Hive Query to read data to generate the cube):
- 
-
-* Visualization (Showing the Star Schema behind of this cube):
-
- 
+ 
-* Access (Grant user/role privileges, Grant operation only open to Admin in beta):
+* Access (Grant user/role privileges, grant operation only open to Admin):
- 
+ 
## 4. Write and Execute SQL on web
Kylin's web offer a simple query tool for user to run SQL to explorer existing cube, verify result and explorer the result set using #5's Pivot analysis and visualization
@@ -53,40 +46,36 @@ Kylin's web offer a simple query tool for user to run SQL to explorer existing c
>
> 1. Only SELECT query be supported
>
-> 2. To avoid huge network traffic from server to client, the scan range's threshold be set to 1,000,000 in beta.
->
-> 3. SQL can't found data from cube will not redirect to Hive in beta
+> 2. SQL will not be redirect to Hive
-Go to "Query" menu:
+Go to "Insight" menu:
-
+
* Source Tables:
- Browser current available Tables (same structure and metadata as Hive):
+ Browser current available tables (same structure and metadata as Hive):
- 
+ 
* New Query:
- You can write and execute your query and explorer the result. One query for you reference:
+ You can write and execute your query and explorer the result.
- 
+ 
-* Saved Query:
+* Saved Query (only work after enable LDAP security):
Associate with user account, you can get saved query from different browsers even machines.
Click "Save" in Result area, it will popup for name and description to save current query:
- 
-
- Click "Saved Queries" to browser all your saved queries, you could direct resubmit it to run or remove it:
+ 
- 
+ Click "Saved Queries" to browser all your saved queries, you could direct submit it or remove it.
* Query History:
- Only keep the current user's query history in current bowser, it will require cookie enabled and will lost if you clean up bowser's cache.Click "Query History" tab, you could directly resubmit any of them to execute again.
+ Only keep the current user's query history in current bowser, it will require cookie enabled and will lost if you clean up bowser's cache. Click "Query History" tab, you could directly resubmit any of them to execute again.
## 5. Pivot Analysis and Visualization
There's one simple pivot and visualization analysis tool in Kylin's web for user to explore their query result:
@@ -96,13 +85,13 @@ There's one simple pivot and visualization analysis tool in Kylin's web for user
When the query execute success, it will present a success indictor and also a cube's name which be hit.
Also it will present how long this query be executed in backend engine (not cover network traffic from Kylin server to browser):
- 
+ 
* Query Result:
It's easy to order on one column.
- 
+ 
* Export to CSV File
@@ -110,9 +99,9 @@ There's one simple pivot and visualization analysis tool in Kylin's web for user
* Pivot Table:
- Drag and Drop one or more columns into the header, the result will grouping by such column's value:
+ Drag and drop one or more columns into the header, the result will grouping by such column's value:
- 
+ 
* Visualization:
@@ -122,17 +111,13 @@ There's one simple pivot and visualization analysis tool in Kylin's web for user
* Bar Chart:
- 
+ 
* Pie Chart:
- 
+ 
* Line Chart
- 
-
-## 6. Cube Build Job Monitoring
-Monitor and manage cube build process, diagnostic into the detail and even link to Hadoop's job information directly:
+ 
-