How to create impala derived tables

[#1]

I read in a presentation that derived tables will be available in v > 2.4, I am using 2.5 with quick start but it seems that the CREATE DERIVED TABLE keyword is  not supported???

[#2]

That feature has not made it in unfortunately. The documentation at http://www.cloudera.com/documentation.html is the source of truth about what features are or are not present.

[#3]

Thank you Tim for the quick reply.

When can we expect the feature to be available? this is my best selling point of Cloudera option for the team

[#4]

I don't think it's on the immediate roadmap, our focus recently has been on various other things (performance, Amazon EC2 support, etc)

[#5]

Hi Tim

That is unfortunate.

However,

I am creating external tables with configured locations and that is great, because now the only thing I need to do to push new daily data is to just create the parquet file and alter the table with the new partition details.

Now the challenge is the aggregated tables that are created as CREATE TABLE FOO AS SELECT..FROM ABC, XYZ,..WHERE...;

These ones I have to recreate them at each time and there is no way to just alter them and make them aware of the new data. The queries are evaluated at creation time!

Is there any other way to create aggregated tables that are updated automatically?

Cheers Khalef. 

[#6 · Accepted solution]

The only way to do this with zero work would be to use a view. http://www.cloudera.com/documentation/enterprise/latest/topics/impala_create_view.html 

Otherwise you do have to run the queries as part of your data pipeline as you mentioned.