I was speaking with Rajesh and Ankit at DataWorks Summit today and they said that Phoenix views have to be “simple”, that is, made up of only SELECT … WHERE.
Is that the case? If so, are there any plans to lift the restriction, and allow views with, say, JOIN, UNION and GROUP BY? The more complex views would not allow inserts/upserts/deletes, because a single row in the view would not necessarily correspond to a single row in the underlying table, but nevertheless, complex views are extremely useful for read-only queries. Calcite allows view expansion for complex views, and even for views upon views, so it should be straightforward to do in 5.0. Julian
