On 6/25/14, 6:36 PM, Neil Hooey wrote: > 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 <http://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. there's no way to do that because two "shards" are accessed via two totally different database connections.
-- 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.