Joins, group by, etc with Flex?

maizer · Post by **maizer** » Thu May 21, 2015 9:12 pm

We are planning to load data into two tables, one flex, one 'traditional'.

Would it be possible to do joins, group by's, and other SQL functions with a flex and 'traditional' table?

Thank you!

NorbertKrupa · Post by **NorbertKrupa** » Mon May 25, 2015 12:45 pm

Yes, as long as those columns involved with JOIN's and GROUP BY's are materialized on the Flex table.

scutter · Post by **scutter** » Tue May 26, 2015 12:50 am

Yes, as long as those columns involved with JOIN's and GROUP BY's are materialized on the Flex table.

Joins and Group Bys can be executed on virtual flex table columns as well - they need not be materialized.

—Sharon

NorbertKrupa · Post by **NorbertKrupa** » Tue May 26, 2015 9:41 am

scutter wrote:Joins and Group Bys can be executed on virtual flex table columns as well - they need not be materialized.

—Sharon

Sharon, you're correct. For performance considerations, you would want to materialize them.

Joins, group by, etc with Flex?

Joins, group by, etc with Flex?

Re: Joins, group by, etc with Flex?

Re: Joins, group by, etc with Flex?

Re: Joins, group by, etc with Flex?