从Kibana取消归一化数据 [英] Denormalizing data from Kibana

问题描述

一旦它已经装载在弹性搜索/ kibana中，有没有办法对数据进行非规范化？以下是我正在努力做的一个具体例子：

Is there a way to denormalize data once its already loaded in elasticsearch/kibana? Here is a specific example of what I'm trying to do:

如果您有关于如此销售汽车的记录：
汽车销售， Camaro，$ 20,000
Car Sale，Malibu，$ 15,000
Car Sale，TrailBlazer，$ 23,000
Car Sale，Fusion $ 18,000

If you have records pertaining to sales of cars like so: "Car Sale", "Camaro", "$20,000" "Car Sale", "Malibu", "$15,000" "Car Sale", "TrailBlazer", "$23,000" "Car Sale", "Fusion", "$18,000"

您有单独的记录，有关这些车的更多信息：
Camaro，Chevrolet
Malibu ，雪佛兰
TrailBlazer，雪佛兰
Fusion，Ford

And you have separate records with further information about these cars: "Camaro", "Chevrolet" "Malibu", "Chevrolet" "TrailBlazer", "Chevrolet" "Fusion", "Ford"

我想生成的图表是汽车价格根据品牌汇总，所以雪佛兰与Fords的总价格是多少？一个选择是在将数据加载到弹性搜索之前对其进行非规范化处理，但是我觉得这样会迫使我知道我的数据在前面，并且不适应变化。

The chart I want to generate is the car prices aggregated based on make, so what are the total prices for Chevy vs. Fords? One option would be to denormalize the data before I load it into elasticsearch but I feel like that's going to force me to know what my data is up front and not adapt to changes very well.

所以我可以根据我的汽车销售记录生成一个条形图，并通过特定车型获得价格，但在那一点上，我无法访问那些让我认为汽车进行汇总的记录它们存在于单独的记录上。我觉得我想在kibana图表的过滤器框中开始一个新的查询，但是看起来不像你这样做？任何其他的想法？

So I can generate a bar chart based on the car sale records I have and get prices by specific models of cars but at that point, I don't have access to those other records that give me that car make aggregation since they exist on separate records. I feel like I want to "start a new query" in the filter boxes of the kibana chart but it doesn't look like you can do that? Any other ideas?

推荐答案

Elasticsearch / Kibana真的不支持关系连接。

Elasticsearch/Kibana really don't support joins in a relational sense.

您真的需要知道您在为数据建模之前的计划使用情况，但您仍然可以灵活地进行操作。

You really do need to know what you planned usage looks like before you model you data, but you can still do things nimbly.

您只需要从源头重新载入你的数据，并在那个时候对它进行非规范化处理。将记录重新加载到弹性搜索可以以每秒千次的速度进行，因此，除非您拥有整个世界的销售记录，否则不需要花费几个小时来重新索引数据。

You just have to be willing to reload your data from source and denormalize it at that point. Reloading records into elasticsearch can be done at the rate of thousands per second, so unless you have sale records for the entire world, it's not going to take you more than a few hours to re-index your data.

这篇关于从Kibana取消归一化数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！