问题描述
在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中进行交叉表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！