Materialize view feature in Polypheny UI

[nodermatt]

Operating System (Polypheny-DB)

Windows

Polypheny-DB Version

5e41a00 master

Affected Areas

UI

Browser

Chrome

Client Operating System

Windows 10

Bug Description

I was looking for the button to materialize a view in the Polypheny UI. Wasn't there such a feature before the last release?

@isabelge @datomo Would you happen to know anything about this?

Reproduction Steps

Start Polypheny
Go to the UI http://localhost:8080/
Create a new view in the Console, e.g. CREATE VIEW HIGH_PAYED2 as select name from emps where salary > 5000;
Navigate to the schema tab and select the view

Expected Behavior

After running the reproduction steps above there should be a button to materialize the view.

Relevant Log Output

No response

[isabelge]

@nodermatt I am not sure if I understand the issue correct. You created a view and now you would like to materialize it?

There is no possibility to create a view or materialized view within the schema editing. In the schema editing for views only information about the underling tables is shown and for materialized views information about the freshness and it is possible to update the materialized view.

The easiest way to materialize a view is:

• Graphical Querying
• select all columns from the view you would like to create a materialized view of
• execute the query
• now there is a button at the top right to create a materialized view from the result

[isabelge]

The option to transform a view to a materialized view within the schema editing does not exist at the moment. However, this can be added in the future.