You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@kylin.apache.org by lu...@apache.org on 2015/07/15 14:48:11 UTC

[4/7] incubator-kylin git commit: KYLIN-884 re-structure website, using new menu, move to root dir

KYLIN-884 re-structure website, using new menu, move to root dir


Project: http://git-wip-us.apache.org/repos/asf/incubator-kylin/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-kylin/commit/cde1146b
Tree: http://git-wip-us.apache.org/repos/asf/incubator-kylin/tree/cde1146b
Diff: http://git-wip-us.apache.org/repos/asf/incubator-kylin/diff/cde1146b

Branch: refs/heads/0.7-staging
Commit: cde1146b6478cbb7b4505b39fd728d679e4a27a1
Parents: 3a5829c
Author: Luke Han <lu...@apache.org>
Authored: Wed Jul 15 18:02:14 2015 +0800
Committer: Luke Han <lu...@apache.org>
Committed: Wed Jul 15 18:02:14 2015 +0800

----------------------------------------------------------------------
 website/_docs/development/build_api.md      |  58 +++++++
 website/_docs/development/dev_env.md        |  97 ++++++++++++
 website/_docs/development/javascript_api.md |  49 ++++++
 website/_docs/install/advance_settings.md   |  38 +++++
 website/_docs/install/index.cn.md           |  46 ++++++
 website/_docs/install/kylin_docker.md       |  44 ++++++
 website/_docs/release_notes.md              | 185 +++++++++++++++++++++++
 7 files changed, 517 insertions(+)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/cde1146b/website/_docs/development/build_api.md
----------------------------------------------------------------------
diff --git a/website/_docs/development/build_api.md b/website/_docs/development/build_api.md
new file mode 100644
index 0000000..6f6c4ed
--- /dev/null
+++ b/website/_docs/development/build_api.md
@@ -0,0 +1,58 @@
+---
+layout: docs
+title:  "Build Cube with Restful API"
+categories: development
+permalink: /docs/development/build_api.html
+version: v0.7.2
+since: v0.6
+---
+
+### 1.	Authentication
+*   Currently, Kylin uses [basic authentication](http://en.wikipedia.org/wiki/Basic_access_authentication).
+*   Add `Authorization` header to first request for authentication
+*   Or you can do a specific request by `POST http://localhost:7070/kylin/api/user/authentication`
+*   Once authenticated, client can go subsequent requests with cookies.
+*   Example
+{% highlight Groff markup %}
+    POST http://localhost:7070/kylin/api/user/authentication
+    
+    Authorization:Basic xxxxJD124xxxGFxxxSDF
+    Content-Type: application/json;charset=UTF-8
+{% endhighlight %}
+
+### 2.	Get details of cube. 
+*   `GET http://localhost:7070/kylin/api/cubes?cubeName={cube_name}&limit=15&offset=0`
+*   Client can find cube segment date ranges in returned cube detail.
+*   Example
+{% highlight Groff markup %}
+    GET http://localhost:7070/kylin/api/cubes?cubeName=test_kylin_cube_with_slr&limit=15&offset=0
+
+    Authorization:Basic xxxxJD124xxxGFxxxSDF
+    Content-Type: application/json;charset=UTF-8
+{% endhighlight %}
+### 3.	Then submit a build job of the cube. 
+*   `PUT http://localhost:7070/kylin/api/cubes/{cube_name}/rebuild`
+*   For put request body detail please refer to [service doc](https://github.com/KylinOLAP/Kylin/wiki/Restful-Service-Doc). 
+    *   `startTime` and `endTime` should be utc timestamp.
+    *   `buildType` can be `BUILD` or `MERGE`. `BUILD` is for building a new segment or refreshing an existing segment. `MERGE` is for merging multiple existing segments into one bigger segment.
+*   This method will return a newly created job instance, in which the uuid is the identity of job to track job status.
+*   Example
+{% highlight Groff markup %}
+    PUT http://localhost:7070/kylin/api/cubes/test_kylin_cube_with_slr/rebuild
+
+    Authorization:Basic xxxxJD124xxxGFxxxSDF
+    Content-Type: application/json;charset=UTF-8
+    
+    {
+    	"startTime": 0,
+    	"endTime": 1388563200000,
+    	"buildType": "BUILD"
+    }
+{% endhighlight %}
+
+### 4.	Track job status. 
+*   `GET http://localhost:7070/kylin/api/jobs/{job_uuid}`
+*   Returned `job_status` represents current status of job.
+
+### 5.	If the job failed, you can resume the job. 
+*   `PUT http://localhost:7070/kylin/api/jobs/{job_uuid}/resume`

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/cde1146b/website/_docs/development/dev_env.md
----------------------------------------------------------------------
diff --git a/website/_docs/development/dev_env.md b/website/_docs/development/dev_env.md
new file mode 100644
index 0000000..4866f60
--- /dev/null
+++ b/website/_docs/development/dev_env.md
@@ -0,0 +1,97 @@
+---
+layout: docs
+title:  Setup Development Env
+categories: development
+permalink: /docs/development/dev_env.html
+version: v0.7.2
+since: v0.6
+---
+
+Off-Hadoop-CLI installation is usually for **development use**.
+
+Developers want to run kylin test cases or applications at their development machine. The scenario is depicted at [https://github.com/KylinOLAP/Kylin#off-hadoop-cli-installation](https://github.com/KylinOLAP/Kylin#off-hadoop-cli-installation).
+
+
+By following this tutorial, you will be able to build kylin test cubes by running a specific test case, and you can further run other test cases against the cubes having been built.
+
+
+## Environment on the Hadoop CLI
+
+Off-Hadoop-CLI installation requires you having a hadoop CLI machine (or a hadoop sandbox) as well as your local develop machine. 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.2**. 
+
+### Start Hadoop
+
+In Hortonworks sandbox, ambari helps to launch hadoop:
+
+{% highlight Groff markup %}
+	ambari-agent start
+	ambari-server start
+{% endhighlight %}
+	
+With both command successfully run you can go to ambari home page at <http://yoursandboxip:8080> (user:admin,password:admin) to check everything's status. By default ambari disables Hbase, you'll need manually start the `Hbase` service.
+
+For other hadoop distribution, basically start the hadoop cluster, make sure HDFS, YARN, Hive, HBase are running.
+
+
+## Environment on the dev machine
+
+
+### Install maven
+
+The latest maven can be found at <http://maven.apache.org/download.cgi>, we create a symbolic so that `mvn` can be run anywhere.
+
+{% highlight Groff markup %}
+	cd ~
+	wget http://xenia.sote.hu/ftp/mirrors/www.apache.org/maven/maven-3/3.2.5/binaries/apache-maven-3.2.5-bin.tar.gz
+	tar -xzvf apache-maven-3.2.5-bin.tar.gz
+	ln -s /root/apache-maven-3.2.5/bin/mvn /usr/bin/mvn
+{% endhighlight %}
+
+### Compile
+
+First clone the Kylin project to your local:
+
+{% highlight Groff markup %}
+	git clone https://github.com/KylinOLAP/Kylin.git
+{% endhighlight %}
+	
+Install Kylin artifacts to the maven repo
+
+{% highlight Groff markup %}
+	mvn clean install -DskipTests
+{% endhighlight %}
+
+### Modify local configuration
+
+Local configuration must be modified to point to your hadoop sandbox (or CLI) machine. 
+
+* In **examples/test_case_data/sandbox/kylin.properties**
+   * Find `sandbox` and replace with your hadoop hosts (if you're using HDP sandbox, this can be skipped)
+   * Fine `kylin.job.run.as.remote.cmd` and change it to "true" (in code repository the default is false, which assume running it on hadoop CLI)
+   * Find `kylin.job.remote.cli.username` and `kylin.job.remote.cli.password`, fill in the user name and password used to login hadoop cluster for hadoop command execution; If you're using HDP sandbox, the default username is "root" and password is "hadoop".
+
+* In **examples/test_case_data/sandbox**
+   * For each configuration xml file, find all occurrence of `sandbox` and replace with your hadoop hosts; (if you're using HDP sandbox, this can be skipped)
+
+An alternative to the host replacement is updating your `hosts` file to resolve `sandbox` and `sandbox.hortonworks.com` to the IP of your sandbox machine.
+
+### Run unit tests
+
+Run a end-to-end cube building test
+ 
+{% highlight Groff markup %}
+	mvn test -Dtest=com.kylinolap.job.BuildCubeWithEngineTest -DfailIfNoTests=false
+{% endhighlight %}
+	
+Run other tests, the end-to-end cube building test is exclueded
+
+{% highlight Groff markup %}
+	mvn test
+{% endhighlight %}
+
+### Launch Kylin Web Server
+
+In your Eclipse IDE, launch `com.kylinolap.rest.DebugTomcat` with specifying VM arguments "-Dspring.profiles.active=sandbox". (By default Kylin server will listen on 7070 port; If you want to use another port, please specify it as a parameter when run `DebugTomcat)
+
+Check Kylin Web available at http://localhost:7070/kylin (user:ADMIN,password:KYLIN)
+

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/cde1146b/website/_docs/development/javascript_api.md
----------------------------------------------------------------------
diff --git a/website/_docs/development/javascript_api.md b/website/_docs/development/javascript_api.md
new file mode 100644
index 0000000..1a970f6
--- /dev/null
+++ b/website/_docs/development/javascript_api.md
@@ -0,0 +1,49 @@
+---
+layout: docs
+title:  "How to consume Kylin REST API in javascript"
+categories: development
+permalink: /docs/development/javascript_api.html
+version: v0.7.2
+since: v0.7.1
+---
+Kypin securicty authorization is based on basic access authorization, so when you want to use API in your javascript,you need to involve the authorization info in http headers.
+
+## Here is a demo show how to use Kylin Query API.
+```
+$.ajaxSetup({
+      headers: { 'Authorization': "Basic eWFu**********X***ZA==", 'Content-Type': 'application/json;charset=utf-8' } // use your own authorization code here
+    });
+    var request = $.ajax({
+       url: "http://hostname/kylin/api/query",
+       type: "POST",
+       data: '{"sql":"select count(*) from SUMMARY;","offset":0,"limit":50000,"partial":true,"project":"test"}',
+       dataType: "json"
+    });
+    request.done(function( msg ) {
+       alert(msg);
+    }); 
+    request.fail(function( jqXHR, textStatus ) {
+       alert( "Request failed: " + textStatus );
+  });
+
+```
+
+
+For what is basic access authorization ,click here http://en.wikipedia.org/wiki/Basic_access_authentication
+
+## Keypoint:
+1. add basic access authorization info in heders.
+2. use right ajax type and right data synax
+
+How to generate your authorization code (download and import "jquery.base64.js" from https://github.com/yckart/jquery.base64.js)
+
+```
+var authorizationCode = $.base64('encode', 'NT_USERNAME' + ":" + 'NT_PASSWORD');
+ 
+$.ajaxSetup({
+   headers: { 
+    'Authorization': "Basic " + authorizationCode, 
+    'Content-Type': 'application/json;charset=utf-8' 
+   }
+});
+```

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/cde1146b/website/_docs/install/advance_settings.md
----------------------------------------------------------------------
diff --git a/website/_docs/install/advance_settings.md b/website/_docs/install/advance_settings.md
new file mode 100644
index 0000000..71fbfcd
--- /dev/null
+++ b/website/_docs/install/advance_settings.md
@@ -0,0 +1,38 @@
+---
+layout: docs
+title:  "Advance settings of Kylin environment"
+categories: install
+permalink: /docs/install/advance_settings.html
+version: v0.7.2
+since: v0.7.1
+---
+
+## Enabling LZO compression
+
+LZO compression can be leveraged to compress the output of MR jobs, as well as hbase table storage, reducing the storage overhead. By default we do not enable LZO compression in Kylin because hadoop sandbox venders tend to not include LZO in their distributions due to license(GPL) issues.
+
+To enable LZO in Kylin, there are three steps:
+
+### Make sure LZO is working in your environment
+
+we have a simple tool to test whether LZO is well installed and configured in your environment(we only test it on the hadoop CLI that you deployed Kylin), Just run
+
+{% highlight Groff markup %}
+hbase org.apache.hadoop.util.RunJar kylin-job-latest.jar com.kylinolap.job.tools.LZOSupportnessChecker
+{% endhighlight %}
+
+If the program prints "LZO supported by current env? true", you're good to go. Otherwise you'll need to first install LZO properly.
+
+### Modify kylin_job_conf.xml
+
+You'll need to stop Kylin first by running `./kylin.sh stop`, and then modify /etc/kylin/kylin_job_conf.xml by uncommenting some configuration entries related to LZO compression. 
+
+### export KYLIN_LD_LIBRARY_PATH to carry your native library paths
+
+Before running `./kylin.sh start` again, you'll need to export KYLIN_LD_LIBRARY_PATH to carry your LZO native library paths. If you are not sure where it is, you can simply find it in /tmp/kylin_retrieve.sh, Kylin retrieved this from hbase, normally this should work. Here's an example for hdp 2.1:
+
+{% highlight Groff markup %}
+export KYLIN_LD_LIBRARY_PATH=::/usr/lib/hadoop/lib/native/Linux-amd64-64:/usr/lib/hadoop/lib/native
+{% endhighlight %}
+
+After exporting, you need to run `./kylin.sh start` to start Kylin again. Now Kylin will use LZO to compress MR outputs and hbase tables.

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/cde1146b/website/_docs/install/index.cn.md
----------------------------------------------------------------------
diff --git a/website/_docs/install/index.cn.md b/website/_docs/install/index.cn.md
new file mode 100644
index 0000000..9e03e58
--- /dev/null
+++ b/website/_docs/install/index.cn.md
@@ -0,0 +1,46 @@
+---
+layout: docs
+title:  "Installation Guide"
+categories: install
+permalink: /cn/docs/install/index.html
+version: v0.7.2
+since: v0.7.1
+---
+
+### Environment
+
+Kylin Rquires a properly setup hadoop environment to run. Following are the minium request to run Kylin, for more detial, please check this reference: [Hadoop Environment](hadoop_env.html).
+
+## Prerequisites on Hadoop
+
+* Hadoop: 2.4+
+* Hive: 0.13+
+* HBase: 0.98+
+* JDK: 1.7+  
+_Tested with Hortonworks HDP 2.2 and Cloudera Quickstart VM 5.1_
+
+
+On-Hadoop-CLI installation is the most common way of installing Kylin. 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:
+
+![On-Hadoop-CLI-installation](/images/install/on_cli_install_scene.png)
+
+For normal use cases, the application in the above picture means Kylin Web, which contains a web interface for cube building, querying and all sorts of management. Kylin Web launches a query engine for querying and a cube build engine for building cubes. These two engines interact with the components in Hadoop CLI, like hive and hbase.
+
+Except for some prerequisite software installations, the core of Kylin installation is accomplished by running a single script. After running the script, you will be able to build sample cube and query the tables behind the cubes via a unified web interface.
+
+### Install Kylin
+
+1. Download latest Kylin binaries at [http://kylin.incubator.apache.org/download](http://kylin.incubator.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 just 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**
+
+> If you want to have multiple Kylin instances 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:
+
+1. [Quick play with a sample cube](../tutorial/kylin_sample.html)
+2. [Create and Build your own cube](../tutorial/create_cube.html)
+3. [Kylin Web Tutorial](../tutorial/web.md)
+

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/cde1146b/website/_docs/install/kylin_docker.md
----------------------------------------------------------------------
diff --git a/website/_docs/install/kylin_docker.md b/website/_docs/install/kylin_docker.md
new file mode 100644
index 0000000..f382ca1
--- /dev/null
+++ b/website/_docs/install/kylin_docker.md
@@ -0,0 +1,44 @@
+---
+layout: docs
+title:  "On Hadoop Kylin installation using Docker"
+categories: install
+version: v0.6
+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
+{% 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 3
+{% endhighlight %}
+
+You can specify the number of nodes you'd like to have in your cluster (3 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
+{% 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](https://github.com/KylinOLAP/Kylin/wiki/Kylin-Cube-Creation-Tutorial).
+  

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/cde1146b/website/_docs/release_notes.md
----------------------------------------------------------------------
diff --git a/website/_docs/release_notes.md b/website/_docs/release_notes.md
new file mode 100644
index 0000000..f4ac760
--- /dev/null
+++ b/website/_docs/release_notes.md
@@ -0,0 +1,185 @@
+---
+layout: docs
+title:  Release Notes
+categories: gettingstarted
+permalink: /docs/release_notes.html
+version: v0.7.2
+since: v0.7.1
+---
+
+# Apache Kylin Release Notes
+
+## v0.7.2-incubating  
+_Tag:_ [kylin-0.7.2-incubating](https://github.com/apache/incubator-kylin/tree/kylin-0.7.2-incubating)
+
+
+__Detail JIRA and notes will coming after verify__
+
+** Sub-task  
+
+    * [KYLIN-812] - Upgrade to Calcite 0.9.2
+
+** Bug  
+
+    * [KYLIN-457] - "ERROR Could not instantiate appender" from log4j when tomcat startup 
+    * [KYLIN-514] - Error message is not helpful to user when doing something in Jason Editor window
+    * [KYLIN-518] - Cannot select Right join type if current join type is Left join type
+    * [KYLIN-598] - Kylin detecting hive table delim failure
+    * [KYLIN-632] - "kylin.sh stop" doesn't check whether KYLIN_HOME was set
+    * [KYLIN-660] - Make configurable of dictionary cardinality cap
+    * [KYLIN-693] - Couldn't change a cube's name after it be created
+    * [KYLIN-814] - Duplicate columns error for subqueries on fact table
+    * [KYLIN-819] - Fix necessary ColumnMetaData order for Calcite (Optic)
+    * [KYLIN-824] - Cube Build fails if lookup table doesn't have any files under HDFS location
+    * [KYLIN-829] - Cube "Actions" shows "NA"; but after expand the "access" tab, the button shows up
+    * [KYLIN-830] - Cube merge failed after migrating from v0.6 to v0.7
+    * [KYLIN-831] - Kylin report "Column 'ABC' not found in table 'TABLE' while executing SQL", when that column is FK but not define as a dimension
+    * [KYLIN-840] - HBase table compress not enabled even LZO is installed
+    * [KYLIN-847] - "select * from fact" does not work on 0.7 branch
+    * [KYLIN-848] - Couldn't resume or discard a cube job
+    * [KYLIN-849] - Couldn't query metrics on lookup table PK
+    * [KYLIN-865] - Cube has been built but couldn't query; In log it said "Realization 'CUBE.CUBE_NAME' defined under project PROJECT_NAME is not found
+    * [KYLIN-873] - cancel button does not work when [resume][discard] job
+
+## v0.7.1-incubating (First Apache Release) - 2015-06-10  
+_Tag:_ [kylin-0.7.1-incubating](https://github.com/apache/incubator-kylin/tree/kylin-0.7.1-incubating)
+
+Apache Kylin v0.7.1-incubating has rolled out on June 10, 2015. This is also the first Apache release after join incubating. 
+
+To download this release, please visit: [http://kylin.incubator.apache.org/download/](http://kylin.incubator.apache.org/download/), there are source code package, binary package, ODBC driver and installation guide avaliable.
+
+Any problem or issue, please send to Apache Kylin mailing list: [dev@kylin.incubator.apache.org](mailto:dev@kylin.incubator.apache.org)
+
+Or, report to Apache Kylin JIRA project: [https://issues.apache.org/jira/browse/KYLIN](https://issues.apache.org/jira/browse/KYLIN)
+
+
+__Main Changes:__
+
+* Package renamed from com.kylinolap to org.apache.kylin
+* Code cleaned up to apply Apache License policy
+* Easy install and setup with bunch of scripts and automation
+* Job engine refactor to be generic job manager for all jobs, and improved efficiency
+* Support Hive database other than 'default'
+* JDBC driver avaliable for client to interactive with Kylin server
+* Binary pacakge avaliable download 
+
+__New Feature__
+
+    * [KYLIN-327] - Binary distribution 
+    * [KYLIN-368] - Move MailService to Common module
+    * [KYLIN-540] - Data model upgrade for legacy cube descs
+    * [KYLIN-576] - Refactor expansion rate expression
+
+__Task__
+
+    * [KYLIN-361] - Rename package name with Apache Kylin
+    * [KYLIN-531] - Rename package name to org.apache.kylin
+    * [KYLIN-533] - Job Engine Refactoring
+    * [KYLIN-585] - Simplify deployment
+    * [KYLIN-586] - Add Apache License header in each source file
+    * [KYLIN-587] - Remove hard copy of javascript libraries
+    * [KYLIN-624] - Add dimension and metric info into DataModel
+    * [KYLIN-650] - Move all document from github wiki to code repository (using md file)
+    * [KYLIN-669] - Release v0.7.1 as first apache release
+
+__Sub-task__
+
+    * [KYLIN-670] - Update pom with "incubating" in version number
+    * [KYLIN-737] - Generate and sign release package for review and vote
+    * [KYLIN-795] - Release after success vote
+
+__Bug__
+
+    * [KYLIN-132] - Job framework
+    * [KYLIN-194] - Dict & ColumnValueContainer does not support number comparison, they do string comparison right now
+    * [KYLIN-220] - Enable swap column of Rowkeys in Cube Designer
+    * [KYLIN-230] - Error when create HTable
+    * [KYLIN-255] - Error when a aggregated function appear twice in select clause
+    * [KYLIN-383] - Sample Hive EDW database name should be replaced by "default" in the sample
+    * [KYLIN-399] - refreshed segment not correctly published to cube
+    * [KYLIN-412] - No exception or message when sync up table which can't access
+    * [KYLIN-421] - Hive table metadata issue
+    * [KYLIN-436] - Can't sync Hive table metadata from other database rather than "default"
+    * [KYLIN-508] - Too high cardinality is not suitable for dictionary!
+    * [KYLIN-509] - Order by on fact table not works correctly
+    * [KYLIN-517] - Always delete the last one of Add Lookup page buttom even if deleting the first join condition
+    * [KYLIN-524] - Exception will throw out if dimension is created on a lookup table, then deleting the lookup table.
+    * [KYLIN-547] - Create cube failed if column dictionary sets false and column length value greater than 0
+    * [KYLIN-556] - error tip enhance when cube detail return empty
+    * [KYLIN-570] - Need not to call API before sending login request
+    * [KYLIN-571] - Dimensions lost when creating cube though Joson Editor
+    * [KYLIN-572] - HTable size is wrong
+    * [KYLIN-581] - unable to build cube
+    * [KYLIN-583] - Dependency of Hive conf/jar in II branch will affect auto deploy
+    * [KYLIN-588] - Error when run package.sh
+    * [KYLIN-593] - angular.min.js.map and angular-resource.min.js.map are missing in kylin.war
+    * [KYLIN-594] - Making changes in build and packaging with respect to apache release process
+    * [KYLIN-595] - Kylin JDBC driver should not assume Kylin server listen on either 80 or 443
+    * [KYLIN-605] - Issue when install Kylin on a CLI which does not have yarn Resource Manager
+    * [KYLIN-614] - find hive dependency shell fine is unable to set the hive dependency correctly
+    * [KYLIN-615] - Unable add measures in Kylin web UI
+    * [KYLIN-619] - Cube build fails with hive+tez
+    * [KYLIN-620] - Wrong duration number
+    * [KYLIN-621] - SecurityException when running MR job
+    * [KYLIN-627] - Hive tables' partition column was not sync into Kylin
+    * [KYLIN-628] - Couldn't build a new created cube
+    * [KYLIN-629] - Kylin failed to run mapreduce job if there is no mapreduce.application.classpath in mapred-site.xml
+    * [KYLIN-630] - ArrayIndexOutOfBoundsException when merge cube segments 
+    * [KYLIN-638] - kylin.sh stop not working
+    * [KYLIN-639] - Get "Table 'xxxx' not found while executing SQL" error after a cube be successfully built
+    * [KYLIN-640] - sum of float not working
+    * [KYLIN-642] - Couldn't refresh cube segment
+    * [KYLIN-643] - JDBC couldn't connect to Kylin: "java.sql.SQLException: Authentication Failed"
+    * [KYLIN-644] - join table as null error when build the cube
+    * [KYLIN-652] - Lookup table alias will be set to null
+    * [KYLIN-657] - JDBC Driver not register into DriverManager
+    * [KYLIN-658] - java.lang.IllegalArgumentException: Cannot find rowkey column XXX in cube CubeDesc
+    * [KYLIN-659] - Couldn't adjust the rowkey sequence when create cube
+    * [KYLIN-666] - Select float type column got class cast exception
+    * [KYLIN-681] - Failed to build dictionary if the rowkey's dictionary property is "date(yyyy-mm-dd)"
+    * [KYLIN-682] - Got "No aggregator for func 'MIN' and return type 'decimal(19,4)'" error when build cube
+    * [KYLIN-684] - Remove holistic distinct count and multiple column distinct count from sample cube
+    * [KYLIN-691] - update tomcat download address in download-tomcat.sh
+    * [KYLIN-696] - Dictionary couldn't recognize a value and throw IllegalArgumentException: "Not a valid value"
+    * [KYLIN-703] - UT failed due to unknown host issue
+    * [KYLIN-711] - UT failure in REST module
+    * [KYLIN-739] - Dimension as metrics does not work with PK-FK derived column
+    * [KYLIN-761] - Tables are not shown in the "Query" tab, and couldn't run SQL query after cube be built
+
+__Improvement__
+
+    * [KYLIN-168] - Installation fails if multiple ZK
+    * [KYLIN-182] - Validation Rule: columns used in Join condition should have same datatype
+    * [KYLIN-204] - Kylin web not works properly in IE
+    * [KYLIN-217] - Enhance coprocessor with endpoints 
+    * [KYLIN-251] - job engine refactoring
+    * [KYLIN-261] - derived column validate when create cube
+    * [KYLIN-317] - note: grunt.json need to be configured when add new javascript or css file
+    * [KYLIN-324] - Refactor metadata to support InvertedIndex
+    * [KYLIN-407] - Validation: There's should no Hive table column using "binary" data type
+    * [KYLIN-445] - Rename cube_desc/cube folder
+    * [KYLIN-452] - Automatically create local cluster for running tests
+    * [KYLIN-498] - Merge metadata tables 
+    * [KYLIN-532] - Refactor data model in kylin front end
+    * [KYLIN-539] - use hbase command to launch tomcat
+    * [KYLIN-542] - add project property feature for cube
+    * [KYLIN-553] - From cube instance, couldn't easily find the project instance that it belongs to
+    * [KYLIN-563] - Wrap kylin start and stop with a script 
+    * [KYLIN-567] - More flexible validation of new segments
+    * [KYLIN-569] - Support increment+merge job
+    * [KYLIN-578] - add more generic configuration for ssh
+    * [KYLIN-601] - Extract content from kylin.tgz to "kylin" folder
+    * [KYLIN-616] - Validation Rule: partition date column should be in dimension columns
+    * [KYLIN-634] - Script to import sample data and cube metadata
+    * [KYLIN-636] - wiki/On-Hadoop-CLI-installation is not up to date
+    * [KYLIN-637] - add start&end date for hbase info in cubeDesigner
+    * [KYLIN-714] - Add Apache RAT to pom.xml
+    * [KYLIN-753] - Make the dependency on hbase-common to "provided"
+    * [KYLIN-758] - Updating port forwarding issue Hadoop Installation on Hortonworks Sandbox.
+    * [KYLIN-779] - [UI] jump to cube list after create cube
+    * [KYLIN-796] - Add REST API to trigger storage cleanup/GC
+
+__Wish__
+
+    * [KYLIN-608] - Distinct count for ii storage
+