如何在Vertica中进行交叉表 [英] How do I do a Crosstab in Vertica

问题描述

在PostgreSQL和其他RDBMS中找到的crosstab或pivot table的Vertica等效项是什么?

What is the Vertica equivalent of crosstab or pivot table found in PostgreSQL and other RDBMS's?

推荐答案

Vertica当前不具备此功能(以供将来参考的3.5.9版).我与一位同事交谈，他的建议是玩交叉连接".

Vertica doesn't currently (release 3.5.9 for future reference) have that capability. I talked with a co-worker and his suggestion was to play around with "cross join."

另一种选择是尽可能地提取结果，然后在数据库外运行一个处理数据的进程(perl，Java，C#等).

The other option would be to distill your results as far as you could and then run a process outside of the database (perl, Java, C#, etc) that manipulated the data.

Vertica可以接受功能请求.

Vertica is open to feature requests however.

我也不认为这将在即将发布的4.0版本中提供.

I don't believe this will be available in the upcoming 4.0 release either.

这篇关于如何在Vertica中进行交叉表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！