[IGNITE-16765] Support creation of table for specific storage engine

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: sql
• Labels: ignite-3
• Epic Link: Pluggable Storage
• Assignee: Unassigned
• Reporter: Andrey N. Gura
• Created: 30/Mar/22 08:01
• Updated: 26/Jul/22 09:48

Description

To make the work with scripts more convenient, we need to support an ability to change default storage engine for an entire script.

From user's point of view it should look like this:

SET default_engine = <storage_engine_name>;

CREATE TABLE <table_name> (
    <table_schema>
);

The scope of the SET expression is limited by DDL script execution context.

So, within this ticket we should introduce a support for SET command as well as execution context that is bound to a script lifecycle.

Issue Links

• depends upon: IGNITE-16691 Storage Configuration refactoring and improvements
• is blocked by: IGNITE-16960 Sql. Script execution using java public API
• is depended upon by: IGNITE-16766 Support storage engine configuration parameters during table creation.