Details
-
New Feature
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.1.6
-
None
-
None
-
2018-15, 2018-16, 2018-17
Description
It would be nice if ColumnStore supported the CREATE TABLE table_name LIKE ... syntax.
For instance, if you try to execute this CREATE TABLE command:
CREATE TABLE table2 LIKE table1;
|
It throws the following error:
The storage engine for the table doesn't support The syntax or the data type(s) is not supported by Columnstore. Please check the Columnstore syntax guide for supported syntax or data types.
|
Here is the CREATE TABLE for the existing table, table1:
CREATE TABLE `table1` (
|
`col1` int(10) NOT NULL,
|
`col2` varchar(255) DEFAULT NULL,
|
`col3` tinyint(127) DEFAULT NULL,
|
`col4` tinyint(1) DEFAULT NULL
|
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
|