MySQL Forums
Forum List  »  Partitioning

subpartition accross disk show error
Posted by: Fei Tian
Date: September 19, 2016 05:23PM

When I create partitioning table accross disks,show this error.I have seen refman-5.7-en.html-chapter/partitioning.html#partitioning-overview,but I don't know why? have any idea can resolve this problem? thanks.


CREATE TABLE tsss (id INT, purchased DATE) PARTITION BY RANGE( YEAR(purchased) ) SUBPARTITION BY HASH( TO_DAYS(purchased) ) ( PARTITION p0 VALUES LESS THAN (1990) ( SUBPARTITION s0 DATA DIRECTORY = '/Users/tianjingcheng/par/tj0/data' INDEX DIRECTORY = '/Users/tianjingcheng/par/tj0/idx', SUBPARTITION s1 DATA DIRECTORY = '/Users/tianjingcheng/par/tj1/data' INDEX DIRECTORY = '/Users/tianjingcheng/par/tj1/idx' ), PARTITION p1 VALUES LESS THAN (2000) ( SUBPARTITION S2 DATA DIRECTORY = '/Users/tianjingcheng/par/tj2/data' INDEX DIRECTORY = '/Users/tianjingcheng/par/tj2/idx', SUBPARTITION S3 DATA DIRECTORY = '/Users/tianjingcheng/par/tj3/data' INDEX DIRECTORY = '/Users/tianjingcheng/par/tj3/idx' ) );

error:ERROR 1031 (HY000): Table storage engine for 'tsss' doesn't have this option

mysql server: MacOS mysql-community-5.7.15.

what can I do ? Please help me.

Options: ReplyQuote

Written By
subpartition accross disk show error
September 19, 2016 05:23PM
September 20, 2016 02:00AM
September 20, 2016 03:06AM
September 20, 2016 11:42AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.