Andrey N. Gura created IGNITE-16765:
---------------------------------------
Summary: Support creation of table for specific storage engine
Key: IGNITE-16765
URL: https://issues.apache.org/jira/browse/IGNITE-16765
Project: Ignite
Issue Type: Task
Reporter: Andrey N. Gura
There must be an ability to define a storage engine for every table using the
following DDL syntax:
{code:sql}
CREATE TABLE <table_name> (
<table_schema>
)
ENGINE <storage_engine_name>;
{code}
It is possible to define a default storage engine in the following manner:
{code:sql}
SET default_engine = <storage_engine_name>;
CREATE TABLE <table_name> (
<table_schema>
);
{code}
It is impossible to change the storage engine for the table after creation
because it will lead to moving a big amount of data between different storages.
But a user could copy a table to another table which was created on a different
storage engine. Maybe such kind of action will be automated later.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)