什么是ApacheKylin用例?-WhatareApacheKylinUseCases?

作者：邹balitas_611 | 来源：互联网 | 2023-05-17 20:00

IrecentlycameacrossApacheKylin,andwascuriouswhatitsusecasesare.FromwhatIcantell,

I recently came across Apache Kylin, and was curious what it's use cases are. From what I can tell, it seems to be a tool designed to solve very specific problems related to upwards of 10+ billion rows, aggregating, caching and querying data from other sources (HBase, Hadoop, Hive). Am I correct in this assumption?

我最近遇到了Apache Kylin，很好奇它的用例是什么。据我所知，它似乎是一种工具，旨在解决与超过10亿行、聚合、缓存和查询来自其他数据源(HBase、Hadoop、Hive)的数据相关的非常具体的问题。在这个假设中我是正确的吗?

1 个解决方案

#1

Apache Kylin's use case is interactive big data analysis on Hadoop. It lets you query big Hive tables at sub-second latency in 3 simple steps.

Apache Kylin的用例是关于Hadoop的交互式大数据分析。它允许您以3个简单的步骤查询大的Hive表。

Identify a set of Hive tables in star schema.
标识星型模式中的一组Hive表。
Build a cube from the Hive tables in an offline batch process.
在脱机批处理过程中从Hive表中构建一个多维数据集。
Query the Hive tables using SQL and get results in sub-seconds, via Rest API, ODBC, or JDBC.
使用SQL查询Hive表，并通过Rest API、ODBC或JDBC在子秒内获得结果。

The use case is pretty general that it can fast query any Hive tables as long as you can define star schema and model cubes from the tables. Check out Kylin terminologies if you are not sure what is star schema and what is cube.

用例非常普遍，只要您可以从表中定义星型模式和模型数据集，它就可以快速查询任何Hive表。如果您不确定什么是星型模式，什么是多维数据集，请查看Kylin术语。

Kylin provides ANSI SQL interface, so you can query the Hive tables pretty much the same way you used to. One limitation however is Kylin provides only aggregated results, or in other word, SQL should contain a "group by" clause to yield correct result. This is usually fine because big data analysis focus more on the aggregated results rather than individual records.

Kylin提供了ANSI SQL接口，所以您可以像以前一样查询Hive表。但是，Kylin只提供聚合的结果，或者换句话说，SQL应该包含一个“group by”子句来产生正确的结果。这通常很好，因为大数据分析更关注聚合结果，而不是单个记录。