Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

MyCat查询指定分区 #57

Open
superleo-cn opened this issue Apr 8, 2017 · 0 comments
Open

MyCat查询指定分区 #57

superleo-cn opened this issue Apr 8, 2017 · 0 comments

Comments

@superleo-cn
Copy link

superleo-cn commented Apr 8, 2017

我现在有3个分区,

# range start-end ,data node index
# K=1000,M=10000.
0-500M=0
500M-1000M=1
1000M-1500M=2

现在想指定MyCat查询的时候走第0个分区,下面的语句不起作用
explain /*!mycat:sql=select 0 */select * from t_ticket_detail where PK_SID >= 1000

请问要怎么实现呢?

# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant