[kylin] branch document updated: update poweredby
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 0222784bef update poweredby 0222784bef is described below commit 0222784bef8e2d59847e0c7fa144e1f458a8c968 Author: Shaofeng Shi AuthorDate: Sat Oct 29 21:13:05 2022 +0800 update poweredby --- website/community/poweredby.cn.md | 15 +++ website/community/poweredby.md| 16 2 files changed, 31 insertions(+) diff --git a/website/community/poweredby.cn.md b/website/community/poweredby.cn.md index fc56e3c0e4..d574e9bfce 100644 --- a/website/community/poweredby.cn.md +++ b/website/community/poweredby.cn.md @@ -9,6 +9,21 @@ __如何贡献案例__ __公司 & 组织__ +* [爱的番茄](https://www.tomatogames.com/), 2022-8-18 +* By building a self-service data platform based on MDX for Kylin + Kylin 4, users can use Excel to retrieve data and then flexibly analyze user behavior, conduct targeted user incentives and advertising operations. + +* [传音](https://www.transsion.com/), 2022-4-6 +* Transsion is a manufacturer of mobile phones based in Shenzhen, China. Transsion uses Apache Kylin as the OLAP engine of metrics store, managing thousands of key metrics. + +* [兴业银行](https://www.cib.com.cn/), 2022-2-10 +* CIB is a commercial bank based in Fuzhou, Fujian province of China. CIB has over 100 million card holders. It adopted Apache Kylin for its credit card data and user portrait analysis. + +* [TP-Link](https://www.tp-link.com/), 2021-8-9 +* TP-Link sells a large number of IoT devices, which regularly generate a large amount of device operation data. The data has great value for the monitoring of device operation status. By building a data analysis system with Kylin, TP-Link can analyse the running status of different versions of equipment in time. + +* [顺丰科技](https://www.sf-tech.com.cn/), 2020-11-21 +* SF-tech is a subsidiary of SF express, which is a multinational delivery services and logistics company in China. SF-tech selects Kylin for internal finance metrics processing and online serving. + * [ZTO 中通快递](https://www.zto.com/), 2019-12-18 * ZTO 作为体量最大的快递公司，将 Apache Kylin 用于大数据分析，为各种数据产品提供支持，主要应用在数据驾驶舱，仪表盘分析等产品。 diff --git a/website/community/poweredby.md b/website/community/poweredby.md index ffb06b4c53..2041ccf840 100644 --- a/website/community/poweredby.md +++ b/website/community/poweredby.md @@ -9,6 +9,22 @@ Send a quick description of your organization and usage to the [mailing list](ma __Companies & Organizations__ + +* [Tomato Games](https://www.tomatogames.com/), 2022-8-18 +* By building a self-service data platform based on MDX for Kylin + Kylin 4, users can use Excel to retrieve data and then flexibly analyze user behavior, conduct targeted user incentives and advertising operations. + +* [Transsion](https://www.transsion.com/), 2022-4-6 +* Transsion is a manufacturer of mobile phones based in Shenzhen, China. Transsion uses Apache Kylin as the OLAP engine of metrics store, managing thousands of key metrics. + +* [Industrial Bank (China)](https://www.cib.com.cn/), 2022-2-10 +* CIB is a commercial bank based in Fuzhou, Fujian province of China. CIB has over 100 million card holders. It adopted Apache Kylin for its credit card data and user portrait analysis. + +* [TP-Link](https://www.tp-link.com/), 2021-8-9 +* TP-Link sells a large number of IoT devices, which regularly generate a large amount of device operation data. The data has great value for the monitoring of device operation status. By building a data analysis system with Kylin, TP-Link can analyse the running status of different versions of equipment in time. + +* [SF-tech](https://www.sf-tech.com.cn/), 2020-11-21 +* SF-tech is a subsidiary of SF express, which is a multinational delivery services and logistics company in China. SF-tech selects Kylin for internal finance metrics processing and online serving. + * [ZTO](https://www.zto.com/), 2019-12-18 * ZTO is the largest express company. Apache Kylin is used for big data analytics and supports a wide range of data products, mainly in data cockpits, dashboard analysis and other products.
[kylin] branch document updated: Update poweredby, faq and events
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
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
[kylin] branch document updated: update poweredby
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 6c2810e update poweredby 6c2810e is described below commit 6c2810e32ae3e00fd0c7465c3f01d5c353740fd9 Author: shaofengshi AuthorDate: Wed Jul 18 16:24:28 2018 +0800 update poweredby --- website/community/poweredby.md | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/website/community/poweredby.md b/website/community/poweredby.md index c14f140..8af35c8 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__ * [DiDi](http://www.didiglobal.com/), 2018-06-27 -* Apache Kylin is running as the engine for OLAP analytics in Didi; It has served more than 10 business lines and 3000+ users, providing stable, reliable and high performance data services for us. Read more at [this blog](https://mp.weixin.qq.com/s/WDaSJHeHvWTDjGkUR7zmfg). +* Apache Kylin is running as a specific scenario engine of OLAP in Didi. With the help of aggregation cache function, it has served more than 10 business lines and 3000+ users, providing stable, reliable and high performance data services for us. Read more at [this blog](https://mp.weixin.qq.com/s/WDaSJHeHvWTDjGkUR7zmfg). * [StrateBI](http://www.stratebi.com/), 2018-05-23 * Apache Kylin has become an essential part in our Big Data projects. We have deployed Kylin with successful for a digital marketing and retail customers, where requirements for data refreshing (minutes) and query latency (sub-second) were very strict while data volumes remain very high (billion rows). Moreover, in order to try and show Kylin features, we have created some demos integrating it with [Tableau](http://bigdata.stratebi.com/kylin-tableau/index.htm), [Superset](http://bigd [...]
