The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
What is has_expressions colum in projections table?
HyeontaeJu
Vertica Customer ✭
What is has_expressions colum in projections table?
what's that mean? is useful for optimization?
0
Answers
Projection can have the columns defined by the expressions. HAS_EXPRESSIONS column in PROJECTIONS table tells you whether the projection has the columns defined by the expressions or not.
https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/AnalyzingData/AggregatedData/ExpressionsAggregateData.htm