I understand that this is the variable substitution but I just wanted to see why and when the optimizer does it. It seems nondeterministic.
Can I find somewhere the complete specification of plans that vertica produces?
Search found 3 matches
- Mon Jun 10, 2013 10:04 pm
- Forum: Vertica Administration Tools
- Topic: vertica plans, unresolved attributes
- Replies: 2
- Views: 16365
- Mon Jun 10, 2013 7:58 pm
- Forum: Vertica Administration Tools
- Topic: vertica plans, unresolved attributes
- Replies: 2
- Views: 16365
vertica plans, unresolved attributes
I was looking at some vertica plans produced with EXPLAIN command and it seems that for some expressions instead of real attribute names the plan prints <SVAR> . This happens even if I have different attributes (for all of them it prints <SVAR>). Here is the example for two aggregates over different...
- Fri Jun 07, 2013 10:22 pm
- Forum: Vertica Database Development
- Topic: View Explain Plan
- Replies: 7
- Views: 25128
Re: View Explain Plan
Hi, I still do not entirely understand the explain plan of vertica and I was reading some documentations but still have some doubts. First, is there a way to know the schemata of individual operations, i.e., which attributes an operation receives at its input and which sends to an output (considerin...