Is it possible to do a join query on two tables that have different shard
keys in SQLAlchemy?

For example, if you have two tables:

users: [userId, name] (sharded on userId)
messages: [messageId, userId, message] (sharded on messageId)

Could you select all of the messages for a particular user with:

select u.name, m.userId, m.messageId, m.message
from messages m
join users u on m.userId = u.userId

(Even though messages are sharded on messageId instead of userId?)

I haven't seen an example of this in the code.

- Neil

-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.

Reply via email to