[MCOL-128] ALTER TABLE conversion to columnstore fails - Jira

Details

Type: Sub-Task
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: None
Fix Version/s: 1.4.3
Component/s: None
Labels:
None

Sprint:
2020-1, 2020-2, 2020-4, 2020-5, 2020-6, 2020-7

Description

mysql> create table t2(c1 int);
Query OK, 0 rows affected (0.01 sec)

mysql> alter table t2 engine=columnstore;
ERROR 1178 (42000): 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.

Attachments

Issue Links

is duplicated by

MCOL-779 storage engine for the table doesn't support

Closed

relates to

MCOL-3785 CTAS (Create Table as Select) with COUNT() ... FROM ... GROUP BY ... throws syntax error

Closed

Activity

Ascending order - Click to sort in descending order

dic (Inactive) added a comment - 2017-06-20 09:45 - edited

I have the similar problem:
MariaDB [employees]> ALTER TABLE salaries ENGINE = ColumnStore;
ERROR 1178 (42000): 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.

dic (Inactive) added a comment - 2017-06-20 09:45 - edited I have the similar problem: MariaDB [employees] > ALTER TABLE salaries ENGINE = ColumnStore; ERROR 1178 (42000): 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.

Elias maturana added a comment - 2019-10-09 14:53

hi, They have found a solution to this problem

regards

Elias maturana added a comment - 2019-10-09 14:53 hi, They have found a solution to this problem regards

Andrew Hutchings (Inactive) added a comment - 2020-01-20 22:29

PR opened, pending regression suite test creation.

Andrew Hutchings (Inactive) added a comment - 2020-01-20 22:29 PR opened, pending regression suite test creation.

Andrew Hutchings (Inactive) added a comment - 2020-01-21 18:38

PR in engine and regression suite to add ALTER TABLE to/from ColumnStore and CTAS.

Andrew Hutchings (Inactive) added a comment - 2020-01-21 18:38 PR in engine and regression suite to add ALTER TABLE to/from ColumnStore and CTAS.

Patrick LeBlanc (Inactive) added a comment - 2020-01-24 15:28

Merged it into develop-1.4. Merge into develop TBD.

Patrick LeBlanc (Inactive) added a comment - 2020-01-24 15:28 Merged it into develop-1.4. Merge into develop TBD.

Susil Behera added a comment - 2020-02-11 18:24

Build verified: 1.4.3-1

MariaDB [(none)]> CREATE TABLE db1.t1 (c1 int) ENGINE=innodb;
Query OK, 0 rows affected (0.015 sec)

MariaDB [(none)]> ALTER TABLE db1.t1 ENGINE=columnstore;
Query OK, 0 rows affected (0.179 sec)
Records: 0 Duplicates: 0 Warnings: 0

MariaDB [(none)]> SHOW CREATE TABLE db1.t1;
--------------------------------------------------------------------------------------------------+

Table

Create Table

--------------------------------------------------------------------------------------------------+

t1	CREATE TABLE `t1` ( `c1` int(11) DEFAULT NULL ) ENGINE=Columnstore DEFAULT CHARSET=latin1

--------------------------------------------------------------------------------------------------+
1 row in set (0.000 sec)

MariaDB [(none)]> ALTER TABLE db1.t1 ENGINE=innodb;
Query OK, 0 rows affected (0.338 sec)
Records: 0 Duplicates: 0 Warnings: 0

MariaDB [(none)]> SHOW CREATE TABLE db1.t1;
---------------------------------------------------------------------------------------------+

Table

Create Table

---------------------------------------------------------------------------------------------+

t1	CREATE TABLE `t1` ( `c1` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1

---------------------------------------------------------------------------------------------+
1 row in set (0.001 sec)

MariaDB [(none)]>

Susil Behera added a comment - 2020-02-11 18:24 Build verified: 1.4.3-1 MariaDB [(none)] > CREATE TABLE db1.t1 (c1 int) ENGINE=innodb; Query OK, 0 rows affected (0.015 sec) MariaDB [(none)] > ALTER TABLE db1.t1 ENGINE=columnstore; Query OK, 0 rows affected (0.179 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [(none)] > SHOW CREATE TABLE db1.t1; ------ --------------------------------------------------------------------------------------------+ Table Create Table ------ --------------------------------------------------------------------------------------------+ t1 CREATE TABLE `t1` ( `c1` int(11) DEFAULT NULL ) ENGINE=Columnstore DEFAULT CHARSET=latin1 ------ --------------------------------------------------------------------------------------------+ 1 row in set (0.000 sec) MariaDB [(none)] > ALTER TABLE db1.t1 ENGINE=innodb; Query OK, 0 rows affected (0.338 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [(none)] > SHOW CREATE TABLE db1.t1; ------ ---------------------------------------------------------------------------------------+ Table Create Table ------ ---------------------------------------------------------------------------------------+ t1 CREATE TABLE `t1` ( `c1` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ------ ---------------------------------------------------------------------------------------+ 1 row in set (0.001 sec) MariaDB [(none)] >

People

Assignee:: Susil Behera

Reporter:: Justin Swanhart (Inactive)

Votes:: 2 Vote for this issue

Watchers:: 8 Start watching this issue

Dates

Created:: 2016-06-12 00:23

Updated:: 2024-07-08 02:45

Resolved:: 2020-02-11 18:24

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB ColumnStore