This is an automated email from the ASF dual-hosted git repository.
shaofengshi pushed a commit to branch document
in repository https://gitbox.apache.org/repos/asf/kylin.git
The following commit(s) were added to refs/heads/document by this push:
new b118f91 Update poweredby, faq and events
b118f91 is described below
commit b118f91cf43e9680e77f6d95beeb5cc4fb049e03
Author: shaofengshi <shaofeng...@apache.org>
AuthorDate: Thu Feb 28 09:37:14 2019 +0800
Update poweredby, faq and events
---
website/_docs/gettingstarted/events.md | 1 +
website/_docs/gettingstarted/faq.cn.md | 6 +++++-
website/_docs/gettingstarted/faq.md | 6 +++++-
website/community/poweredby.cn.md | 2 +-
website/community/poweredby.md | 2 +-
5 files changed, 13 insertions(+), 4 deletions(-)
diff --git a/website/_docs/gettingstarted/events.md
b/website/_docs/gettingstarted/events.md
index db6978f..ef2cf30 100644
--- a/website/_docs/gettingstarted/events.md
+++ b/website/_docs/gettingstarted/events.md
@@ -21,6 +21,7 @@ __Conferences__
* [Apache Kylin: OLAP Engine on Hadoop - Tech Deep
Dive](http://v.csdn.hudong.com/s/article.html?arcid=15820707)
([video](http://v.csdn.hudong.com/s/article.html?arcid=15820707),
[slides](http://www.slideshare.net/XuJiang2/kylin-hadoop-olap-engine)) by
[Jiang Xu](https://www.linkedin.com/pub/xu-jiang/4/5a8/230), at Shanghai Big
Data Summit 2014 in Shanghai, China , 2014-10-25
__Meetup__
+* [Apache Kylin Meetup
@Shanghai](http://www.huodongxing.com/event/4476570217900),
[slides](https://www.slidestalk.com/x/241/apache_kylin_innovation_meetup)
Shangai, China; 1:00 PM - 4:30 PM, Saturday, 2019-02-23
* [Apache Kylin for Extreme OLAP and Big Data @eBay South
Campus](https://www.eventbrite.com/e/thursday-nov-29-meetup-apache-kylin-for-extreme-olap-and-big-data-tickets-52275347973?aff=estw),
Sanjose, CA, US; 6:30 PM - 8:30 PM, Thursday, 2018-11-29
* [Apache Kylin Meetup
@Hangzhou](http://www.huodongxing.com/event/7461326621900), China; 1:30PM -
17:00PM, Saturday, 2018-10-26
* [CDAP in Cloud, Extreme OLAP w Apache Kylin, Twitter Reviews &
DataStax](https://www.meetup.com/BigDataApps/events/253429041/) @ Google Cloud,
US; 6:00PM to 8:00PM, 2018-8-29
diff --git a/website/_docs/gettingstarted/faq.cn.md
b/website/_docs/gettingstarted/faq.cn.md
index 89601c2..cd3f119 100644
--- a/website/_docs/gettingstarted/faq.cn.md
+++ b/website/_docs/gettingstarted/faq.cn.md
@@ -232,4 +232,8 @@ vi
$KYLIN_HOME/tomcat/webapps/kylin/WEB-INF/classes/kylinSecurity.xml
HDFS 上的工作目录中的数据包括了中间数据 (将被垃圾清理所清除) 和 Cuboid 数据 (不会被垃圾清理所清除)，Cuboid 数据将为之后的
Segment 合并而保留。所以如果用户确认这些 Segment 在之后不会被合并，可以将 Cuboid 数据移动到其他路径甚至删除。
-另外，请留意 HDFS 工作目录下的 "resources" 子目录中会存放一些大的元数据，如字典文件和维表的快照，这些文件不能被删除。
\ No newline at end of file
+另外，请留意 HDFS 工作目录下的 "resources" 或 "jdbc-resources"
子目录中会存放一些大的元数据，如字典文件和维表的快照，这些文件不能被删除。
+
+#### 如何对 like 语句中的关键字进行转义？
+"%", "_" 是 "like" 语句中的保留关键字; "%" 可以匹配任意个字符, "_" 匹配单个字符; 如果你想匹配关键字如 "_",
需要使用另一个字符在前面进行转义; 下面是一个使用 "/" 进行转义的例子, 此查询试图匹配 "xiao_":
+"select username from gg_user where username like '%xiao/_%' escape '/'; "
\ No newline at end of file
diff --git a/website/_docs/gettingstarted/faq.md
b/website/_docs/gettingstarted/faq.md
index 66bfef7..dfaf5af 100644
--- a/website/_docs/gettingstarted/faq.md
+++ b/website/_docs/gettingstarted/faq.md
@@ -334,4 +334,8 @@ vi ./tomcat/webapps/kylin/WEB-INF/classes/kylinSecurity.xml
* The data in 'hdfs-working-dir' ('hdfs:///kylin/kylin_metadata/' by
default) includes intermediate files (will be GC) and Cuboid data (won't be
GC). The Cuboid data is kept for the further segments' merge, as Kylin couldn't
merge from HBase. If you're sure those segments won't be merged, you can move
them to other paths or even delete.
- * Please pay attention to the "resources" sub-folder under
'hdfs-working-dir', which persists some big metadata files like dictionaries
and lookup tables' snapshots. They shouldn't be moved.
+ * Please pay attention to the "resources" or "jdbc-resources" sub-folder
under '/kylin/kylin_metadata/', which persists big metadata files like
dictionaries and lookup tables' snapshots. They shouldn't be manually moved.
+
+#### How to escape the key word in fuzzy match (like) queries?
+"%", "_" are key words in the "like" clause; "%" matches any character, and
"_" matches a single character; When you wants to match the key word like "_",
need to escape them with another character ahead; Below is a sample with "/" to
escape, the query is to match the "xiao_":
+"select username from gg_user where username like '%xiao/_%' escape '/'; "
\ No newline at end of file
diff --git a/website/community/poweredby.cn.md
b/website/community/poweredby.cn.md
index 659b1a4..4696e8d 100644
--- a/website/community/poweredby.cn.md
+++ b/website/community/poweredby.cn.md
@@ -10,7 +10,7 @@ __如何贡献案例__
__公司 & 组织__
* [Telecoming](https://www.telecoming.com/), 2019-01-21
- * Telecoming 采用了 Apache Kylin，因为它是一个非常有用的商业智能工具。Kylin
缩短了查询时间，改进了报表生成，最重要的是它有助于业务决策。
+ * Telecoming 采用了 Apache Kylin，因为它是一个非常有用的商业智能工具。Kylin
缩短了查询时间，改进了报表生成，最重要的是它有助于业务决策。关于更多信息，请参考[此页面](http://www.stratebi.com/-/big-data-marketing-telecoming)。
* [Cisco Systems, Inc. 思科](https://www.cisco.com/), 2019-01-17
* 思科是 IT、网络和网络安全解决方案领域的全球领导者。思科将 Apache Kylin
应用于报表系统，以在高并发场景中获取良好的查询性能。想要了解更多请阅读[此博客](http://kylin.apache.org/blog/2019/01/17/cisco-throughput-5x/)。
diff --git a/website/community/poweredby.md b/website/community/poweredby.md
index 267e2bd..b64e4ac 100644
--- a/website/community/poweredby.md
+++ b/website/community/poweredby.md
@@ -10,7 +10,7 @@ Send a quick description of your organization and usage to
the [mailing list](ma
__Companies & Organizations__
* [Telecoming](https://www.telecoming.com/), 2019-01-21
- * Telecoming has adopted Apache Kylin, since it's an extremely useful
business intelligence tool. It has encouraged lower consultation time, it has
improved report generation and above all it contributes to improving business
decisions.
+ * Telecoming has adopted Apache Kylin, since it's an extremely useful
business intelligence tool. It has encouraged lower consultation time, it has
improved report generation and above all it contributes to improving business
decisions. Read more at [this
blog](http://www.stratebi.com/-/big-data-marketing-telecoming)
* [Cisco Systems, Inc.](https://www.cisco.com/), 2019-01-17
* Cisco is the worldwide leader in IT, networking, and cybersecurity
solutions. Apache Kylin is adopted in its reporting system and delivers a good
query performance in high concurrency scenarios. Read more at [this
blog](http://kylin.apache.org/blog/2019/01/17/cisco-throughput-5x/).
