[storm] Problem with EXISTS clause

Edoardo Serra edoardo at serra.to.it
Mon Sep 27 22:07:46 BST 2010


Hi Jamu,

On Sep 27, 2010, at 10:59 PM, Jamu Kakar wrote:

> I believe you need to pass an explicit list of tables to the Select
> expression, to override the logic that automatically determines
> which tables to include in the FROM clause:
> 
> subselect = Select(Subscription.id,
>                   Subscription.account_id == Account.id,
>                   [Subscription])
> accounts = store.find(Account, Not(Exists(subselect))).count()

Thanks to you and Jürgen, I did not know this feature!

E.





More information about the storm mailing list