Teiid Plan Not Showing a Aggregation function
vsathishkumaran Sep 23, 2015 3:25 PMHello,
I am generating a plan XML from Teiid. The SQL contains aggregation function but the aggregation function(count, sum, etc) is missing from Teiid Plan. Am I missing some thing? The plan should provide which aggregate functions is being worked on right? Can someone help me please?
Below is the SQL and the plan.
SQL:
select a.ACCOUNT_ID as ACCOUNT_ID, b.company_name as company_name, c.ssn as ssn, count(a.shares_count) as total_shares
from UbuntuMySQL.PORTFOLIO.HOLDINGS a, UbuntuMySQL.PORTFOLIO.PRODUCT b,HadoopSrcModel.default.account c
WHERE a.PRODUCT_ID = b.ID and a.ACCOUNT_ID = c.ACCOUNT_ID GROUP BY a.ACCOUNT_ID,b.company_name, c.ssn
XML Plan:
<?xml version="1.0" encoding="UTF-8" ?>
</property>
</property>
</property>
</property>
</property>
</property>
</node>
</property>
</property>
</node>
</property>
</property>
</property>
</node>
</property>
</property>
</node>
</property>
</property>
</node>