SQL Server columnstore clustered index on an indexed view

Question

I want to have an automatically updated structure in SQL Server that can handle aggregate queries well. Can I create an indexed view in SQL server 2014 that has a columnstore index as its clustered index?

Answer 1

You can't create a columnstore index on a view as per the documentation:

CREATE COLUMNSTORE INDEX (Transact-SQL)

In the limitations and restrictions it explicitly states:

"Cannot be created on a view or indexed view."