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)

Reply via email to