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, <[email protected]> wrote: > Send storm mailing list submissions to > [email protected] > > 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 > [email protected] > > You can reach the person managing the list at > [email protected] > > 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 <[email protected]> > To: [email protected] > Subject: [storm] Is there any way to do a Join to table itself in > Storm? > Message-ID: <[email protected]> > 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 > [email protected] > Modify settings or unsubscribe at: > https://lists.ubuntu.com/mailman/listinfo/storm > > > End of storm Digest, Vol 63, Issue 3 > ************************************ -- storm mailing list [email protected] Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/storm
