[storm] Is there any way to do a Join to table itself in Storm?

[Matt Haggard]

Domic,

Using Aliases, you can do what you want:
https://storm.canonical.com/Tutorial#Aliases

Matt

On Mon, Sep 30, 2013 at 6:00 AM,  <storm-request at lists.canonical.com> wrote:
> Send storm mailing list submissions to
>         storm at lists.canonical.com
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         https://lists.ubuntu.com/mailman/listinfo/storm
> or, via email, send a message with subject or body 'help' to
>         storm-request at lists.canonical.com
>
> You can reach the person managing the list at
>         storm-owner at lists.canonical.com
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of storm digest..."
>
>
> Today's Topics:
>
>    1. Is there any way to do a Join to table itself in Storm? (Domic)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Mon, 30 Sep 2013 08:07:12 +0000 (UTC)
> From: Domic <serkan at luxeys.com>
> To: storm at lists.canonical.com
> Subject: [storm] Is there any way to do a Join to table itself in
>         Storm?
> Message-ID: <loom.20130930T095354-951 at post.gmane.org>
> Content-Type: text/plain; charset=us-ascii
>
> About storm, is there any way to do a Join to table itself in Storm?
> table_1
> ------------------------------------------
> ID | source_id | kind | target_id
> 1     500        100      15
> 2     500        200      22
>
> In this example I want to create a query like:
> SELECT t1.target_id
> FROM `table_1` t1, table_1 t2
> WHERE t1.source_id = t2.source_id
> AND t2.target_id = 22
> AND t2.kind = 200
> AND t1.kind = 100
>
>
> Can anybody show direction on this matter.
>
>
>
>
> ------------------------------
>
> --
> storm mailing list
> storm at lists.canonical.com
> Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/storm
>
>
> End of storm Digest, Vol 63, Issue 3
> ************************************