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 410 Fei Tian 09/19/2016 05:23PM
Re: subpartition accross disk show error 257 Jon Stephens 09/20/2016 02:00AM
Re: subpartition accross disk show error 239 Fei Tian 09/20/2016 03:06AM
Re: subpartition accross disk show error 268 Jon Stephens 09/20/2016 11:42AM
Re: subpartition accross disk show error 244 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.