MySQL Forums :: Partitioning :: subpartition accross disk show error


Advanced Search

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.

sql:

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


Subject Views Written By Posted
subpartition accross disk show error 385 Fei Tian 09/19/2016 05:23PM
Re: subpartition accross disk show error 240 Jon Stephens 09/20/2016 02:00AM
Re: subpartition accross disk show error 224 Fei Tian 09/20/2016 03:06AM
Re: subpartition accross disk show error 251 Jon Stephens 09/20/2016 11:42AM
Re: subpartition accross disk show error 226 Rick James 10/02/2016 12:58PM


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.