ERROR 3014 (HY000): Table storage engine 'NDBCLUSTER' found required create option missing

Question

I am trying to create a disk table

CREATE TABLE table1_disk 
(col0 INT(11) NOT NULL AUTO_INCREMENT,
col1 VARCHAR(20) DEFAULT NULL,
PRIMARY KEY (col0)) 
ENGINE=ndbcluster DEFAULT CHARSET=latin1 
TABLESPACE ts_1 STORAGE DISK;

Error: Table storage engine 'NDBCLUSTER' found required create option missing.

I have specified ENGINE type. If I remove STORAGE type the table is created.

score 0 · Answer 1 · edited Feb 25 '19 at 08:06

0

Use this:

CREATE TABLE `table1_disk` (
  `col0` int(11) NOT NULL,
  `col1` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `table1_disk`
  ADD PRIMARY KEY (`col0`);

ALTER TABLE `table1_disk`
MODIFY `col0` int(11) NOT NULL AUTO_INCREMENT;COMMIT;

edited Feb 25 '19 at 08:06

adiga

34,372
9
61
83

answered Sep 22 '17 at 12:23

salomon

1
1

i want ENGINE=ndbcluster not InnoDB. – Raghu DV Sep 22 '17 at 12:24
@saloman when you answer question explain what is the error and then explain how you your going to solve it without giving answer quickly – Shiwanka Chathuranga Oct 21 '17 at 01:36

ERROR 3014 (HY000): Table storage engine 'NDBCLUSTER' found required create option missing

1 Answers1