[Spock Proxy Devel] SELECT queries with USING INDEX
Status: Alpha
Brought to you by:
kaotao
|
From: Niv <ni...@tr...> - 2008-12-03 14:39:35
|
Hello.
I have a problem with Spock Proxy.
I'm trying to run a query on all shards, and the query contains an index
hint ("USE INDEX"):
SELECT *
FROM <table>
USE INDEX (index1, index2)
WHERE <conditions>
ORDER BY <order>
LIMIT 0, 10
In the spockproxy log file, I see the warning "could not parse table alias,
using default db".
When I remove the "USE INDEX", the query works (but takes forever).
Can you please offer any assistance?
Thanks,
Niv Singer
|