Author: lidong Date: Fri Sep 27 14:11:25 2019 New Revision: 1867636 URL: http://svn.apache.org/viewvc?rev=1867636&view=rev Log: Added blog entry 2019-09-22-kylin-tableau.md describing how to connect Tableau with Kylin
Added: kylin/site/blog/2019/09/ kylin/site/blog/2019/09/22/ kylin/site/blog/2019/09/22/kylin-tableau/ kylin/site/blog/2019/09/22/kylin-tableau/index.html kylin/site/images/blog/kylin-tableau/ kylin/site/images/blog/kylin-tableau/kylin_jdbc_tableau_server.jpg (with props) kylin/site/images/blog/kylin-tableau/kylin_jdbc_tableau_working.jpg (with props) kylin/site/images/blog/kylin-tableau/kylin_jdbc_tableau_working_sheet.jpg (with props) kylin/site/images/blog/kylin-tableau/tableau_kylin_connection.jpg (with props) kylin/site/images/blog/kylin-tableau/tableau_other_databases_jdbc.jpg (with props) Modified: kylin/site/blog/index.html kylin/site/feed.xml Added: kylin/site/blog/2019/09/22/kylin-tableau/index.html URL: http://svn.apache.org/viewvc/kylin/site/blog/2019/09/22/kylin-tableau/index.html?rev=1867636&view=auto ============================================================================== --- kylin/site/blog/2019/09/22/kylin-tableau/index.html (added) +++ kylin/site/blog/2019/09/22/kylin-tableau/index.html Fri Sep 27 14:11:25 2019 @@ -0,0 +1,6534 @@ +<!-- +* Licensed to the Apache Software Foundation (ASF) under one +* or more contributor license agreements. See the NOTICE file +* distributed with this work for additional information +* regarding copyright ownership. The ASF licenses this file +* to you under the Apache License, Version 2.0 (the +* "License"); you may not use this file except in compliance +* with the License. You may obtain a copy of the License at +* +* http://www.apache.org/licenses/LICENSE-2.0 +* +* Unless required by applicable law or agreed to in writing, software +* distributed under the License is distributed on an "AS IS" BASIS, +* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +* See the License for the specific language governing permissions and +* limitations under the License. +--> +<!doctype html> +<html> + <!-- +* Licensed to the Apache Software Foundation (ASF) under one +* or more contributor license agreements. See the NOTICE file +* distributed with this work for additional information +* regarding copyright ownership. The ASF licenses this file +* to you under the Apache License, Version 2.0 (the +* "License"); you may not use this file except in compliance +* with the License. You may obtain a copy of the License at +* +* http://www.apache.org/licenses/LICENSE-2.0 +* +* Unless required by applicable law or agreed to in writing, software +* distributed under the License is distributed on an "AS IS" BASIS, +* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +* See the License for the specific language governing permissions and +* limitations under the License. +--> + +<head> + <meta charset="utf-8"> + <meta http-equiv="X-UA-Compatible" content="IE=edge"> + <meta name="viewport" content="width=device-width, initial-scale=1"> + + <title>Apache Kylin | Connecting Tableau Desktop and Tableau Server with Apache Kylin</title> + <meta name="description" content="BackgroundThis document describes how to connect Tableau to Apache Kylin OLAP server, particularly (but not only) in live mode to use both reporting and anal..."> + <meta name="author" content="Apache Kylin"> + <link rel="shortcut icon" href="fav.png" type="image/png"> + + + +<link rel="stylesheet" href="/assets/css/animate.css"> +<!-- Bootstrap --> +<link rel="stylesheet" href="/assets/css/bootstrap.min.css"> + +<!-- Fonts --> +<!-- <link rel="stylesheet" href="http://fonts.googleapis.com/css?family=Alice|Open+Sans:400,300,700"> --> + +<!-- Icons --> +<link rel="stylesheet" href="/assets/css/font-awesome.min.css"> + + <!-- Custom styles --> + <link rel="stylesheet" href="/assets/css/styles.css"> + <link rel="stylesheet" href="/assets/css/docs.css"> + <link rel="stylesheet" href="/assets/css/pygments.css"> + + <link rel="canonical" href="http://kylin.apache.org/blog/2019/09/22/kylin-tableau/"> + <link rel="alternate" type="application/rss+xml" title="Apache Kylin" href="http://kylin.apache.org/feed.xml" /> + +<!--[if lt IE 9]> <script src="assets/js/html5shiv.js"></script> <![endif]--> +<!-- Global site tag (gtag.js) - Google Analytics --> +<script async src="https://www.googletagmanager.com/gtag/js?id=UA-120788561-1"></script> +<script> + window.dataLayer = window.dataLayer || []; + function gtag(){dataLayer.push(arguments);} + gtag('js', new Date()); + + gtag('config', 'UA-120788561-1'); +</script> +<script type="text/javascript" src="/assets/js/jquery-1.9.1.min.js"></script> +<script type="text/javascript" src="/assets/js/nside.js"></script> </script> +<script type="text/javascript" src="/assets/js/nnav.js"></script> </script> +<script> +var _hmt = _hmt || []; +(function() { + var hm = document.createElement("script"); + hm.src = "https://hm.baidu.com/hm.js?bdc5e03add430c0b72cc0eb91eabfa99"; + var s = document.getElementsByTagName("script")[0]; + s.parentNode.insertBefore(hm, s); +})(); +</script> + +</head> + + <body> + <!-- +* Licensed to the Apache Software Foundation (ASF) under one +* or more contributor license agreements. See the NOTICE file +* distributed with this work for additional information +* regarding copyright ownership. The ASF licenses this file +* to you under the Apache License, Version 2.0 (the +* "License"); you may not use this file except in compliance +* with the License. You may obtain a copy of the License at +* +* http://www.apache.org/licenses/LICENSE-2.0 +* +* Unless required by applicable law or agreed to in writing, software +* distributed under the License is distributed on an "AS IS" BASIS, +* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +* See the License for the specific language governing permissions and +* limitations under the License. +--> + +<header id="header" > + + <!-- Main Menu --> + <nav class="navbar navbar-default" role="navigation" id="nav-wrapper"> + <div class="container-fluid" id="nav"> + <!-- + <img class="img-circle" width="40px" height="40px" id="circlelogo" src="/assets/images/kylin_logo.jpg"> + --> + <!-- Brand and toggle get grouped for better mobile display --> + <div class="navbar-header"> + <img class="navbar-logo" width="46" src="/assets/images/kylin_logo.png" ></img> + <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1"> + <span class="sr-only">Toggle navigation</span> + <span class="icon-bar"></span> + <span class="icon-bar"></span> + <span class="icon-bar"></span> + </button> + <ul class="nav icon-navbar"> + <li class="li-search"> + <div> + <form target="_blank" autocomplete="false" action="https://sematext.com/opensee/big-data"> + <input type="hidden" name="project" value="kylin"> + <div class="form-group search-container"> + <input type="text" autocomplete="false" class="form-control" name="q" placeholder="Search..."> + <div class="search fa fa-search fa-lg"></div> + </div> + </form> + </div> + <!-- <a href="https://twitter.com/apachekylin" target="_blank" class="fa fa-search fa-lg" title="Search: @ApacheKylin" ></a> --> + </li> + <li><a href="https://twitter.com/apachekylin" target="_blank" class="fa fa-twitter fa-lg" title="Twitter: @ApacheKylin" ></a></li> + <li><a href="https://github.com/apache/kylin" target="_blank" class="fa fa-github-alt fa-lg" title="Github: apache/kylin" ></a></li> + <li><a href="https://www.facebook.com/kylinio" target="_blank" class="fa fa-facebook fa-lg" title="Facebook: kylin.io" ></a></li> + </ul> + </div> + + <!-- Collect the nav links, forms, and other content for toggling --> + <div class="navbar-collapse collapse" id="bs-example-navbar-collapse-1"> + + <ul class="nav navbar-nav"> + + <li><a href="/">Home</a></li> + <li> + <a href="/docs">Docs</a> +<!-- + <a href="#" class="dropdown-toggle" data-toggle="dropdown">Docs</a> + <ul class="dropdown-menu"> + + <li class="dropdown-submenu"><a href="#titleGetting Started" data-toggle="collapse" class="navtitle">Getting Started</a> + <ul class="dropdown-menu"> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/index.html" class="list-group-item-lay pjaxlink">Overview</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/release_notes.html" class="list-group-item-lay pjaxlink">Release Notes</a> + </li> + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/gettingstarted/concepts.html" class="list-group-item-lay pjaxlink">Technical Concepts</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/gettingstarted/terminology.html" class="list-group-item-lay pjaxlink">Terminology</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/gettingstarted/faq.html" class="list-group-item-lay pjaxlink">FAQ</a> + </li> + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/gettingstarted/events.html" class="list-group-item-lay pjaxlink">Events and Conferences</a> + </li> + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/gettingstarted/best_practices.html" class="list-group-item-lay pjaxlink">Community Best Practices</a> + </li> + + + + + + + + + <ul> + </li> + + <li class="dropdown-submenu"><a href="#titleInstallation" data-toggle="collapse" class="navtitle">Installation</a> + <ul class="dropdown-menu"> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/install/index.html" class="list-group-item-lay pjaxlink">Installation Guide</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/install/kylin_cluster.html" class="list-group-item-lay pjaxlink">Deploy in Cluster Mode</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/install/configuration.html" class="list-group-item-lay pjaxlink">Kylin Configuration</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/install/kylin_aws_emr.html" class="list-group-item-lay pjaxlink">Install Kylin on AWS EMR</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/install/kylin_docker.html" class="list-group-item-lay pjaxlink">Run Kylin with Docker</a> + </li> + + + + + + + + + <ul> + </li> + + <li class="dropdown-submenu"><a href="#titleTutorial" data-toggle="collapse" class="navtitle">Tutorial</a> + <ul class="dropdown-menu"> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/kylin_sample.html" class="list-group-item-lay pjaxlink">Quick Start with Sample Cube</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/web.html" class="list-group-item-lay pjaxlink">Web Interface</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/create_cube.html" class="list-group-item-lay pjaxlink">Cube Wizard</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink">Cube Build and Job Monitoring</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/sql_reference.html" class="list-group-item-lay pjaxlink">SQL Reference</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/project_table_level_acl.html" class="list-group-item-lay pjaxlink">Project And Table Level ACL</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/cube_spark.html" class="list-group-item-lay pjaxlink">Build Cube with Spark</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/cube_streaming.html" class="list-group-item-lay pjaxlink">Scalable Cubing from Kafka</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/cube_build_performance.html" class="list-group-item-lay pjaxlink">Cube Build Tuning</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/kylin_client_tool.html" class="list-group-item-lay pjaxlink">Kylin Python Client</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/setup_systemcube.html" class="list-group-item-lay pjaxlink">Set Up System Cube</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/use_cube_planner.html" class="list-group-item-lay pjaxlink">Use Cube Planner</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/use_dashboard.html" class="list-group-item-lay pjaxlink">Use Dashboard</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/setup_jdbc_datasource.html" class="list-group-item-lay pjaxlink">Setup JDBC Data Source</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/hybrid.html" class="list-group-item-lay pjaxlink">Hybrid Model</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/mysql_metastore.html" class="list-group-item-lay pjaxlink">Use MySQL as Metastore</a> + </li> + + + + + + + + + <ul> + </li> + + <li class="dropdown-submenu"><a href="#titleIntegration" data-toggle="collapse" class="navtitle">Integration</a> + <ul class="dropdown-menu"> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/odbc.html" class="list-group-item-lay pjaxlink">Kylin ODBC Driver</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/jdbc.html" class="list-group-item-lay pjaxlink">Kylin JDBC Driver</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/tableau.html" class="list-group-item-lay pjaxlink">Tableau 8</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink">Tableau 9</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/powerbi.html" class="list-group-item-lay pjaxlink">MS Excel and Power BI</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/microstrategy.html" class="list-group-item-lay pjaxlink">MicroStrategy</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/squirrel.html" class="list-group-item-lay pjaxlink">SQuirreL</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/flink.html" class="list-group-item-lay pjaxlink">Apache Flink</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/spark.html" class="list-group-item-lay pjaxlink">Apache Spark</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/hue.html" class="list-group-item-lay pjaxlink">Hue</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/Qlik.html" class="list-group-item-lay pjaxlink">Qlik Sense</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/superset.html" class="list-group-item-lay pjaxlink">Superset</a> + </li> + + + + + + + + + <ul> + </li> + + <li class="dropdown-submenu"><a href="#titleHow To" data-toggle="collapse" class="navtitle">How To</a> + <ul class="dropdown-menu"> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink">Use RESTful API</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink">Build Cube with API</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/howto/howto_optimize_cubes.html" class="list-group-item-lay pjaxlink">Optimize Cube Design</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/howto/howto_optimize_build.html" class="list-group-item-lay pjaxlink">Optimize Cube Build</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink">Backup Metadata</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink">Cleanup Storage</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/howto/howto_upgrade.html" class="list-group-item-lay pjaxlink">Upgrade From Old Versions</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/howto/howto_use_cli.html" class="list-group-item-lay pjaxlink">Use Utility CLIs</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/howto/howto_ldap_and_sso.html" class="list-group-item-lay pjaxlink">Secure with LDAP and SSO</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/howto/howto_use_beeline.html" class="list-group-item-lay pjaxlink">Use Beeline for Hive</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/howto/howto_update_coprocessor.html" class="list-group-item-lay pjaxlink">Update Coprocessor</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/howto/howto_install_ranger_kylin_plugin.html" class="list-group-item-lay pjaxlink">Install Ranger Plugin</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/howto/howto_enable_zookeeper_acl.html" class="list-group-item-lay pjaxlink">Enable Zookeeper ACL</a> + </li> + + + + + + + + + <ul> + </li> + + </ul> --> + </li> + <li><a href="/download">Download</a></li> + <li><a href="/community" >Community</a></li> + <li><a href="/development" >Development</a></li> + <li><a href="/blog">Blog</a></li> + <li><a href="/cn" >ä¸æç</a></li> + </ul> + </div><!-- /.navbar-collapse --> + </div><!-- /.container-fluid --> + </nav> + + <div id="head" class="parallax normal-header" > + <div class="text-center header-apache"> + <a href="http://apache.org/foundation/contributing.html" title="Support Apache" style="margin-left: 150px;"> + <div> + <img src="https://www.apache.org/images/SupportApache-small.png" > + </div> + </a> + </div> + </div> + + </header> + + <div class="page-content main"> + <header style=" padding:2em 0 0 "> + <div class="container" > + <div style=" padding:0 4em"> + <div class="blog-icon"> + <img width="30" src="/assets/images/icon_blog_w.png"> + </div> + <h4 class="index-title" style=" float:left;"><span>Apache Kylin⢠Technical Blog</span></h4> + </div> + </div> + </div> + + <div class="container blog"> + <div> + <article class="post-content" > + <!-- +* Licensed to the Apache Software Foundation (ASF) under one +* or more contributor license agreements. See the NOTICE file +* distributed with this work for additional information +* regarding copyright ownership. The ASF licenses this file +* to you under the Apache License, Version 2.0 (the +* "License"); you may not use this file except in compliance +* with the License. You may obtain a copy of the License at +* +* http://www.apache.org/licenses/LICENSE-2.0 +* +* Unless required by applicable law or agreed to in writing, software +* distributed under the License is distributed on an "AS IS" BASIS, +* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +* See the License for the specific language governing permissions and +* limitations under the License. +--> + +<div class="post" style=" padding:2em 4em 4em 4em"> + + <header class="post-header"> + <h1 class="post-title">Connecting Tableau Desktop and Tableau Server with Apache Kylin</h1> + <p class="post-meta" >Sep 22, 2019 ⢠Piotr Naszarkowski</p> + </header> + + <article class="post-content" > + <h2 id="background">Background</h2> +<p>This document describes how to connect Tableau to Apache Kylin OLAP server, particularly (but not only) in live mode to use both reporting and analytics features of Tableau together with Apache Kylinâs fast query processing engine. The configuration is platform independent - it works for both Windows and Linux installations of Tableau Server.</p> + +<p>For the time of writing this guide we tested that it works with Kylin 3.0.0 and Tableau Server 2019.1.</p> + +<h2 id="prerequisites">Prerequisites</h2> +<p>### Apache Kylin JDBC Driver<br /> +First we need to get Apache Kylin JDBC Driver - kylin-jdbc-X.Y.Z.jar file. You can either get it from the compiled package available on the download page http://kylin.apache.org/download/ from <code class="highlighter-rouge">lib</code> folder or compile it on your own using instructions below.</p> + +<p><em>Note</em>: To make JDBC driver work properly, there has been a fix recently https://github.com/apache/kylin/pull/739 that upgraded one of the libraries used by the driver. The fix was applied for version 3, so if for some reason you need a jar for earlier version, you have to apply the fix on the lower versionâs codebase and compile yourself.<br /> +#### Compiling Apache Kylin JDBC Driver<br /> +<code class="highlighter-rouge"> +git clone https://github.com/apache/kylin.git +cd kylin +mvn clean package -DskipTests -am -pl jdbc +</code></p> + +<p>The compiled jar is located in the following location: <code class="highlighter-rouge">jdbc/target/kylin-jdbc-X.Y.Z.jar</code></p> + +<h3 id="tableau-server-on-linux">Tableau Server on Linux</h3> +<p>If you have installed Tableau Server in a Linux box, e.g. CentOS, copy the driverâs jar file to the following location: <code class="highlighter-rouge">/opt/tableau/tableau_driver/jdbc/</code> and restart Tableau Server. <br /> +The server is now ready to create and refresh data from Apache Kylin.</p> + +<h3 id="tableau-server-and-tableau-desktop-on-windows">Tableau Server and Tableau Desktop on Windows</h3> +<p>For either Tableau Server or Tableau Desktop that is installed on a Windows machine, copy the driverâs jar file to the following location <code class="highlighter-rouge">C:\Program Files\Tableau\Drivers</code> and restart Tableau Server or reopen Tableau Desktop.</p> + +<p>Some more details regarding jdbc connection from Tableau are well described in Tableauâs documentation: https://onlinehelp.tableau.com/current/pro/desktop/en-us/examples_otherdatabases_jdbc.htm.</p> + +<h2 id="creating-report-in-tableau-desktop---connecting-to-apache-kylin">Creating report in Tableau Desktop - connecting to Apache Kylin</h2> +<p>To create report follow the steps:<br /> +1. Open Tableau Desktop<br /> +2. Use âOther Databases (JDBC)â to create connection for the data source</p> + +<p><img src="/images/blog/kylin-tableau/tableau_other_databases_jdbc.jpg" alt="Other Databases (JDBC)" /></p> + +<ol> + <li>Configure the connection in the following way: + <ul> + <li>URL: <code class="highlighter-rouge">jdbc:kylin://<kylin-server-name>:<kylin-port>/<project></code></li> + <li>Dialect: <code class="highlighter-rouge">SQL92</code></li> + </ul> + </li> +</ol> + +<p><img src="/images/blog/kylin-tableau/tableau_kylin_connection.jpg" alt="Datasource connection" /></p> + +<ol> + <li>Configure data source as follows: + <ul> + <li>Database: <code class="highlighter-rouge">defaultCatalog</code></li> + <li>Schema: <code class="highlighter-rouge">DEFAULT</code></li> + </ul> + </li> +</ol> + +<p>You should be able to see the tables/cubes in the Apache Kylinâs project</p> + +<p><img src="/images/blog/kylin-tableau/kylin_jdbc_tableau_working.jpg" alt="Data source" /></p> + +<p><strong>Important</strong>: Decide if you want the data source be in <code class="highlighter-rouge">live</code> or <code class="highlighter-rouge">extract</code> mode. Some of the functions might not work in <code class="highlighter-rouge">live</code> mode as for the other data sources - itâs just how Tableau works. Recommendation is to start with <code class="highlighter-rouge">live</code> mode to utilize performance of Apache Kylin. If youâre forced to switch to <code class="highlighter-rouge">extract</code> mode - consider creating a custom query against Apache Kylinâs cubes to retrieve as small amount of data as possible as it will help the report to perform well.</p> + +<ol> + <li>Finish designing your data source and then switch to worksheets, dashboards</li> +</ol> + +<p><img src="/images/blog/kylin-tableau/kylin_jdbc_tableau_working_sheet.jpg" alt="Tableau Desktop" /></p> + +<h2 id="publishing-reports-from-tableau-desktop-to-tableau-server">Publishing reports from Tableau Desktop to Tableau Server</h2> +<p>To publish the data source and the report follow these steps:<br /> +1. In Tableau Desktop from top menu select Server -> Publish<br /> +2. Choose the settings for publishing like Project, select sheets<br /> +3. <strong>Important</strong>: For data source Authentication set <code class="highlighter-rouge">Embedded</code> - this is very important for data refresh to work, however keep in mind that the credentials will be embeded in the report then<br /> +4. Publish the report<br /> +5. Pop up should be displayed with the preview of the report rendered by the server</p> + +<p><img src="/images/blog/kylin-tableau/kylin_jdbc_tableau_server.jpg" alt="Tableau Server" /></p> + +<p>Verify if the report is displaying properly and can connect to Apache Kylin correctly by opening it directly in Tableau Server web application.</p> + + </article> + +</div> + + + + + + </article> + </div> + </div> + <!-- +* Licensed to the Apache Software Foundation (ASF) under one +* or more contributor license agreements. See the NOTICE file +* distributed with this work for additional information +* regarding copyright ownership. The ASF licenses this file +* to you under the Apache License, Version 2.0 (the +* "License"); you may not use this file except in compliance +* with the License. You may obtain a copy of the License at +* +* http://www.apache.org/licenses/LICENSE-2.0 +* +* Unless required by applicable law or agreed to in writing, software +* distributed under the License is distributed on an "AS IS" BASIS, +* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +* See the License for the specific language governing permissions and +* limitations under the License. +--> + +<footer id="underfooter"> + <div> + <div class="row"> + <div class="col-md-12 widget"> + <div class="widget-body"> + <div class="footer-img"> + <a href="http://www.apache.org"> + <img id="asf-logo" height="78px" alt="Apache Software Foundation" src="/assets/images/apache_footer.png"> + </a> + </div> + <p style="padding-top: 11px;"> + The contents of this website are © 2015 Apache Software Foundation under the terms of the + <a href="http://www.apache.org/licenses/LICENSE-2.0"> Apache License v2 </a>. + </p> + <p style="margin-bottom: 11px;"> + Apache Kylin and its logo are trademarks of the Apache Software Foundation. + </div> + + </div> + </div> + </div> + <!-- /row of widgets --> + + </div> + <div></div> + +</footer> + + <script src="/assets/js/jquery-1.9.1.min.js"></script> + <script src="/assets/js/bootstrap.min.js"></script> + <script src="/assets/js/main.js"></script> + </body> +</html> + + + + Modified: kylin/site/blog/index.html URL: http://svn.apache.org/viewvc/kylin/site/blog/index.html?rev=1867636&r1=1867635&r2=1867636&view=diff ============================================================================== --- kylin/site/blog/index.html (original) +++ kylin/site/blog/index.html Fri Sep 27 14:11:25 2019 @@ -6367,6 +6367,16 @@ var _hmt = _hmt || []; <div class="col-md-6 col-lg-6 col-xs-12"> + <a class="blog-card" href="/blog/2019/09/22/kylin-tableau/"> + <div class="blog-pic"> + <img width="20" src="../assets/images/icon_blog_w.png" /> + </div> + <p class="blog-title">Connecting Tableau Desktop and Tableau Server with Apache Kylin</p> + <p align="left" class="post-meta">posted: Sep 22, 2019</p> + </a> + </div> + + <div class="col-md-6 col-lg-6 col-xs-12"> <a class="blog-card" href="/blog/2019/07/30/detailed-analysis-of-refine-query-cache/"> <div class="blog-pic"> <img width="20" src="../assets/images/icon_blog_w.png" /> Modified: kylin/site/feed.xml URL: http://svn.apache.org/viewvc/kylin/site/feed.xml?rev=1867636&r1=1867635&r2=1867636&view=diff ============================================================================== --- kylin/site/feed.xml (original) +++ kylin/site/feed.xml Fri Sep 27 14:11:25 2019 @@ -19,11 +19,101 @@ <description>Apache Kylin Home</description> <link>http://kylin.apache.org/</link> <atom:link href="http://kylin.apache.org/feed.xml" rel="self" type="application/rss+xml"/> - <pubDate>Tue, 24 Sep 2019 06:59:42 -0700</pubDate> - <lastBuildDate>Tue, 24 Sep 2019 06:59:42 -0700</lastBuildDate> + <pubDate>Fri, 27 Sep 2019 06:59:31 -0700</pubDate> + <lastBuildDate>Fri, 27 Sep 2019 06:59:31 -0700</lastBuildDate> <generator>Jekyll v2.5.3</generator> <item> + <title>Connecting Tableau Desktop and Tableau Server with Apache Kylin</title> + <description><h2 id="background">Background</h2> +<p>This document describes how to connect Tableau to Apache Kylin OLAP server, particularly (but not only) in live mode to use both reporting and analytics features of Tableau together with Apache Kylinâs fast query processing engine. The configuration is platform independent - it works for both Windows and Linux installations of Tableau Server.</p> + +<p>For the time of writing this guide we tested that it works with Kylin 3.0.0 and Tableau Server 2019.1.</p> + +<h2 id="prerequisites">Prerequisites</h2> +<p>### Apache Kylin JDBC Driver<br /> +First we need to get Apache Kylin JDBC Driver - kylin-jdbc-X.Y.Z.jar file. You can either get it from the compiled package available on the download page http://kylin.apache.org/download/ from <code class="highlighter-rouge">lib</code> folder or compile it on your own using instructions below.</p> + +<p><em>Note</em>: To make JDBC driver work properly, there has been a fix recently https://github.com/apache/kylin/pull/739 that upgraded one of the libraries used by the driver. The fix was applied for version 3, so if for some reason you need a jar for earlier version, you have to apply the fix on the lower versionâs codebase and compile yourself.<br /> +#### Compiling Apache Kylin JDBC Driver<br /> +<code class="highlighter-rouge"> +git clone https://github.com/apache/kylin.git +cd kylin +mvn clean package -DskipTests -am -pl jdbc +</code></p> + +<p>The compiled jar is located in the following location: <code class="highlighter-rouge">jdbc/target/kylin-jdbc-X.Y.Z.jar</code></p> + +<h3 id="tableau-server-on-linux">Tableau Server on Linux</h3> +<p>If you have installed Tableau Server in a Linux box, e.g. CentOS, copy the driverâs jar file to the following location: <code class="highlighter-rouge">/opt/tableau/tableau_driver/jdbc/</code> and restart Tableau Server. <br /> +The server is now ready to create and refresh data from Apache Kylin.</p> + +<h3 id="tableau-server-and-tableau-desktop-on-windows">Tableau Server and Tableau Desktop on Windows</h3> +<p>For either Tableau Server or Tableau Desktop that is installed on a Windows machine, copy the driverâs jar file to the following location <code class="highlighter-rouge">C:\Program Files\Tableau\Drivers</code> and restart Tableau Server or reopen Tableau Desktop.</p> + +<p>Some more details regarding jdbc connection from Tableau are well described in Tableauâs documentation: https://onlinehelp.tableau.com/current/pro/desktop/en-us/examples_otherdatabases_jdbc.htm.</p> + +<h2 id="creating-report-in-tableau-desktop---connecting-to-apache-kylin">Creating report in Tableau Desktop - connecting to Apache Kylin</h2> +<p>To create report follow the steps:<br /> +1. Open Tableau Desktop<br /> +2. Use âOther Databases (JDBC)â to create connection for the data source</p> + +<p><img src="/images/blog/kylin-tableau/tableau_other_databases_jdbc.jpg" alt="Other Databases (JDBC)" /></p> + +<ol> + <li>Configure the connection in the following way: + <ul> + <li>URL: <code class="highlighter-rouge">jdbc:kylin://&lt;kylin-server-name&gt;:&lt;kylin-port&gt;/&lt;project&gt;</code></li> + <li>Dialect: <code class="highlighter-rouge">SQL92</code></li> + </ul> + </li> +</ol> + +<p><img src="/images/blog/kylin-tableau/tableau_kylin_connection.jpg" alt="Datasource connection" /></p> + +<ol> + <li>Configure data source as follows: + <ul> + <li>Database: <code class="highlighter-rouge">defaultCatalog</code></li> + <li>Schema: <code class="highlighter-rouge">DEFAULT</code></li> + </ul> + </li> +</ol> + +<p>You should be able to see the tables/cubes in the Apache Kylinâs project</p> + +<p><img src="/images/blog/kylin-tableau/kylin_jdbc_tableau_working.jpg" alt="Data source" /></p> + +<p><strong>Important</strong>: Decide if you want the data source be in <code class="highlighter-rouge">live</code> or <code class="highlighter-rouge">extract</code> mode. Some of the functions might not work in <code class="highlighter-rouge">live</code> mode as for the other data sources - itâs just how Tableau works. Recommendation is to start with <code class="highlighter-rouge">live</code> mode to utilize performance of Apache Kylin. If youâre forced to switch to <code class="highlighter-rouge">extract</code> mode - consider creating a custom query against Apache Kylinâs cubes to retrieve as small amount of data as possible as it will help the report to perform well.</p> + +<ol> + <li>Finish designing your data source and then switch to worksheets, dashboards</li> +</ol> + +<p><img src="/images/blog/kylin-tableau/kylin_jdbc_tableau_working_sheet.jpg" alt="Tableau Desktop" /></p> + +<h2 id="publishing-reports-from-tableau-desktop-to-tableau-server">Publishing reports from Tableau Desktop to Tableau Server</h2> +<p>To publish the data source and the report follow these steps:<br /> +1. In Tableau Desktop from top menu select Server -&gt; Publish<br /> +2. Choose the settings for publishing like Project, select sheets<br /> +3. <strong>Important</strong>: For data source Authentication set <code class="highlighter-rouge">Embedded</code> - this is very important for data refresh to work, however keep in mind that the credentials will be embeded in the report then<br /> +4. Publish the report<br /> +5. Pop up should be displayed with the preview of the report rendered by the server</p> + +<p><img src="/images/blog/kylin-tableau/kylin_jdbc_tableau_server.jpg" alt="Tableau Server" /></p> + +<p>Verify if the report is displaying properly and can connect to Apache Kylin correctly by opening it directly in Tableau Server web application.</p> +</description> + <pubDate>Sun, 22 Sep 2019 13:30:00 -0700</pubDate> + <link>http://kylin.apache.org/blog/2019/09/22/kylin-tableau/</link> + <guid isPermaLink="true">http://kylin.apache.org/blog/2019/09/22/kylin-tableau/</guid> + + + <category>blog</category> + + </item> + + <item> <title>Detailed Analysis of refine query cache</title> <description><hr /> @@ -1454,85 +1544,6 @@ The checkpoint info is the smallest part </item> - <item> - <title>Apache Kylin v2.6.0 æ£å¼åå¸</title> - <description><p>è¿æ¥Apache Kylin 社åºå¾é«å ´å°å®£å¸ï¼Apache Kylin 2.6.0 æ£å¼åå¸ã</p> - -<p>Apache Kylin æ¯ä¸ä¸ªå¼æºçåå¸å¼åæå¼æï¼æ¨å¨ä¸ºæ大æ°æ®éæä¾ SQL æ¥å£åå¤ç»´åæï¼OLAPï¼çè½åã</p> - -<p>è¿æ¯ç»§2.5.0 åçä¸ä¸ªæ°åè½çæ¬ã该çæ¬å¼å ¥äºå¾å¤æä»·å¼çæ¹è¿ï¼å®æ´çæ¹å¨å表请åè§<a href="https://kylin.apache.org/docs/release_notes.html">release notes</a>ï¼è¿éæä¸äºä¸»è¦æ¹è¿å说æï¼</p> - -<h3 id="jdbcsdk">é对以JDBC为æ°æ®æºçSDK</h3> -<p>Kylinç®åå·²ç»æ¯æéè¿JDBCè¿æ¥å æ¬Amazon Redshift, SQL Serverå¨å çå¤ç§æ°æ®æºã<br /> -为äºä¾¿äºå¼åè æ´ä¾¿å©å°å¤çåç§ SQL æ¹è¨ï¼dialectï¼ çä¸å以æ´å ç®åå°å¼åæ°ç JDBC æ°æ®æºï¼Kylin æä¾äºç¸åºç SDK åç»ä¸ç API å ¥å£ï¼<br /> -* åæ¥å æ°æ®åæ°æ®<br /> -* æ建 cube<br /> -* å½æ¾ä¸å°ç¸åºçcubeæ¥è§£çæ¥è¯¢æ¶ï¼ä¸æ¨æ¥è¯¢å°æ°æ®æº</p> - -<p>æ´å¤å 容åè§ KYLIN-3552ã</p> - -<h3 id="memcached--kylin-">ä½¿ç¨ Memcached ä½ Kylin çåå¸å¼ç¼å</h3> -<p>å¨è¿å»ï¼Kylin 对æ¥è¯¢ç»æçç¼åä¸æ¯ååé«æï¼ä¸»è¦æ以ä¸ä¸¤ä¸ªæ¹é¢çåå ï¼<br /> -ä¸ä¸ªæ¯å½ Kylin ç metadata åçååæ¶ï¼ä¼ä¸»å¨ç²ç®å°å»æ¸ é¤å¤§éç¼åï¼ä½¿å¾ç¼åä¼è¢«é¢ç¹å·æ°è导è´å©ç¨çéä½ã<br /> -å¦ä¸ç¹æ¯ç±äºåªä½¿ç¨æ¬å°ç¼åèå¯¼è´ Kylin server ä¹é´ä¸è½å ±äº«å½¼æ¤çç¼åï¼è¿æ ·æ¥è¯¢çç¼åå½ä¸çå°±ä¼éä½ã<br /> -æ¬å°ç¼åçä¸ä¸ªç¼ºç¹æ¯å¤§å°åå°éå¶ï¼ä¸è½ååå¸å¼ç¼åé£æ ·æ°´å¹³æ©å±ãè¿æ ·å¯¼è´è½ç¼åçæ¥è¯¢ç»æéåå°äºéå¶ã</p> - -<p>é对è¿äºç¼ºé·ï¼æ们æ¹åäºç¼å失æçæºå¶ï¼ä¸å主å¨å»æ¸ çç¼åï¼èæ¯éåå¦ä¸çæ¹æ¡ï¼<br /> -1. å¨å°æ¥è¯¢ç»ææ¾å ¥ç¼åä¹åï¼æ ¹æ®å½åçå æ°æ®ä¿¡æ¯è®¡ç®ä¸ä¸ªæ°åç¾åï¼å¹¶ä¸æ¥è¯¢ç»æä¸åæ¾å ¥ç¼åä¸<br /> -2. ä»ç¼åä¸è·åæ¥è¯¢ç»æä¹åï¼æ ¹æ®å½åçå æ°æ®ä¿¡æ¯è®¡ç®ä¸ä¸ªæ°åç¾åï¼å¯¹æ¯ä¸¤è çæ°åç¾åæ¯å¦ä¸è´ãå¦æä¸è´ï¼é£ä¹ç¼åææï¼åä¹ï¼è¯¥ç¼å失æ并å é¤</p> - -<p>æ们è¿å¼å ¥äº Memcached ä½ä¸º Kylin çåå¸å¼ç¼åãè¿æ · Kylin server ä¹é´å¯ä»¥å ±äº«æ¥è¯¢ç»æçç¼åï¼èä¸ç±äº Memcached server ä¹é´çç¬ç«æ§ï¼é常æäºæ°´å¹³æå±ï¼æ´å æå©äºç¼åæ´å¤çæ°æ®ã<br /> -ç¸å ³å¼åä»»å¡æ¯ KYLIN-2895, KYLIN-2894, KYLIN-2896, KYLIN-2897, KYLIN-2898, KYLIN-2899ã</p> - -<h3 id="forkjoinpool--fast-cubing-">ForkJoinPool ç®å fast cubing ç线ç¨æ¨¡å</h3> -<p>å¨è¿å»è¿è¡ fast cubing æ¶ï¼Kylin 使ç¨èªå·±å®ä¹çä¸ç³»å线ç¨ï¼å¦ split 线ç¨ï¼task 线ç¨ï¼main 线ç¨ççè¿è¡å¹¶åç cube æ建ã<br /> -å¨è¿ä¸ªçº¿ç¨æ¨¡åä¸ï¼çº¿ç¨ä¹é´çå ³ç³»ååçå¤æï¼èä¸å¯¹å¼å¸¸å¤çä¹åå容æåºéã</p> - -<p>ç°å¨æ们å¼å ¥äº ForkJoinPoolï¼å¨ä¸»çº¿ç¨ä¸å¤ç split é»è¾ï¼æ建 cuboid çä»»å¡ä»¥ååä»»å¡é½å¨ fork join poolä¸æ§è¡ï¼cuboid æ建çç»æå¯ä»¥è¢«å¼æ¥çæ¶é并ä¸å¯ä»¥æ´æ©å°è¾åºç»ä¸æ¸¸ç merge æä½ãæ´å¤å 容åè§ KYLIN-2932ã</p> - -<h3 id="hllcounter-">æ¹è¿ HLLCounter çæ§è½</h3> -<p>å¯¹äº HLLCounterï¼ æ们ä»ä¸¤æ¹é¢è¿è¡äºæ¹è¿ï¼æ建 HLLCounter å计ç®è°åå¹³åçæ¹å¼ã<br /> -1. å ³äº HLLCounter çæ建ï¼æ们ä¸å使ç¨mergeçæ¹å¼ï¼èæ¯ç´æ¥copyå«çHLLCounteréé¢çregisters<br /> -2. å ³äºè®¡ç® HLLCSnapshot éé¢çè°åå¹³åï¼åäºä»¥ä¸ä¸ä¸ªæ¹é¢çæ¹è¿ï¼<br /> -* ç¼åææç1/2^r<br /> -* 使ç¨æ´åç¸å 代æ¿æµ®ç¹åç¸å <br /> -* å é¤æ¡ä»¶åæ¯ï¼ä¾å¦æ éæ£æ¥ registers[i] æ¯ä¸æ¯ä¸º0</p> - -<p>æ´å¤å 容åè§ KYLIN-3656ã</p> - -<h3 id="cube-planner-">æ¹è¿ Cube Planner ç®æ³</h3> -<p>å¨è¿å»ï¼cube planner ç phase two å¢å æªè¢«é¢è®¡ç®ç cuboid çæ¹å¼åªè½éè¿ mandatory cuboid çæ¹å¼ãèä¸ä¸ª cuboid æ¯å¦ä¸º mandatoryï¼åæ两ç§æ¹å¼ï¼<br /> -æå¨è®¾ç½®ï¼æ¥è¯¢æ¶ rollup çè¡æ°è¶³å¤å¤§ãè¿ééè¿å¤ææ¥è¯¢æ¶ rollup çè¡æ°æ¯å¦è¶³å¤å¤§æ¥å¤ææ¯å¦ä¸º mandatory cuboid çæ¹å¼æ两大缺é·ï¼<br /> -* ä¸æ¯ä¼°ç® rollup çè¡æ°çç®æ³ä¸æ¯å¾å¥½<br /> -* äºæ¯å¾é¾è®¾ç«ä¸ä¸ªéæçéå¼æ¥åå¤å®</p> - -<p>ç°å¨æ们ä¸åä» rollup è¡æ°çè§åº¦çé®é¢äºãä¸åé½æ¯ä» cuboid è¡æ°çè§åº¦çé®é¢ï¼è¿æ ·å°±å cost based ç cube planner ç®æ³åäºç»ä¸ã<br /> -为æ¤æ们éè¿ä½¿ç¨ rollup æ¯çæ¥æ¹è¿äºæªè¢«é¢å æ建ç cuboid çè¡æ°çä¼°ç®ï¼ç¶å让 cost based ç cube planner ç®æ³æ¥å¤å®åªäºæªè¢«æ建ç cuboid 该被æ建ï¼åªäºè¯¥è¢«éå¼ã<br /> -éè¿è¿æ ·çæ¹è¿ï¼æ ééè¿è®¾å®éæçéå¼æ¥æ¨è mandatory cuboid äºï¼è mandatory cuboid åªè½è¢«æå¨è®¾ç½®ï¼ä¸è½è¢«æ¨èäºãæ´å¤å 容åè§ KYLIN-3540ã</p> - -<p><strong>ä¸è½½</strong></p> - -<p>è¦ä¸è½½Apache Kylin v2.6.0æºä»£ç æäºè¿å¶å ï¼è¯·è®¿é®<a href="http://kylin.apache.org/download">ä¸è½½é¡µé¢</a> .</p> - -<p><strong>å级</strong></p> - -<p>åè<a href="/docs/howto/howto_upgrade.html">å级æå</a>.</p> - -<p><strong>åé¦</strong></p> - -<p>å¦ææ¨éå°é®é¢æçé®ï¼è¯·åéé®ä»¶è³ Apache Kylin dev æ user é®ä»¶å表ï¼d...@kylin.apache.orgï¼u...@kylin.apache.org; å¨åéä¹åï¼è¯·ç¡®ä¿æ¨å·²éè¿åéçµåé®ä»¶è³ dev-subscr...@kylin.apache.org æ user-subscr...@kylin.apache.org订é äºé®ä»¶å表ã</p> - -<p><em>é常æè°¢ææè´¡ç®Apache Kylinçæå!</em></p> -</description> - <pubDate>Fri, 18 Jan 2019 12:00:00 -0800</pubDate> - <link>http://kylin.apache.org/cn_blog/2019/01/18/release-v2.6.0/</link> - <guid isPermaLink="true">http://kylin.apache.org/cn_blog/2019/01/18/release-v2.6.0/</guid> - - - <category>cn_blog</category> - - </item> - <item> <title>Apache Kylin v2.6.0 Release Announcement</title> <description><p>The Apache Kylin community is pleased to announce the release of Apache Kylin v2.6.0.</p> Added: kylin/site/images/blog/kylin-tableau/kylin_jdbc_tableau_server.jpg URL: http://svn.apache.org/viewvc/kylin/site/images/blog/kylin-tableau/kylin_jdbc_tableau_server.jpg?rev=1867636&view=auto ============================================================================== Binary file - no diff available. Propchange: kylin/site/images/blog/kylin-tableau/kylin_jdbc_tableau_server.jpg ------------------------------------------------------------------------------ svn:mime-type = application/octet-stream Added: kylin/site/images/blog/kylin-tableau/kylin_jdbc_tableau_working.jpg URL: http://svn.apache.org/viewvc/kylin/site/images/blog/kylin-tableau/kylin_jdbc_tableau_working.jpg?rev=1867636&view=auto ============================================================================== Binary file - no diff available. Propchange: kylin/site/images/blog/kylin-tableau/kylin_jdbc_tableau_working.jpg ------------------------------------------------------------------------------ svn:mime-type = application/octet-stream Added: kylin/site/images/blog/kylin-tableau/kylin_jdbc_tableau_working_sheet.jpg URL: http://svn.apache.org/viewvc/kylin/site/images/blog/kylin-tableau/kylin_jdbc_tableau_working_sheet.jpg?rev=1867636&view=auto ============================================================================== Binary file - no diff available. Propchange: kylin/site/images/blog/kylin-tableau/kylin_jdbc_tableau_working_sheet.jpg ------------------------------------------------------------------------------ svn:mime-type = application/octet-stream Added: kylin/site/images/blog/kylin-tableau/tableau_kylin_connection.jpg URL: http://svn.apache.org/viewvc/kylin/site/images/blog/kylin-tableau/tableau_kylin_connection.jpg?rev=1867636&view=auto ============================================================================== Binary file - no diff available. Propchange: kylin/site/images/blog/kylin-tableau/tableau_kylin_connection.jpg ------------------------------------------------------------------------------ svn:mime-type = application/octet-stream Added: kylin/site/images/blog/kylin-tableau/tableau_other_databases_jdbc.jpg URL: http://svn.apache.org/viewvc/kylin/site/images/blog/kylin-tableau/tableau_other_databases_jdbc.jpg?rev=1867636&view=auto ============================================================================== Binary file - no diff available. Propchange: kylin/site/images/blog/kylin-tableau/tableau_other_databases_jdbc.jpg ------------------------------------------------------------------------------ svn:mime-type = application/octet-stream