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

Domic serkan at luxeys.com
Mon Sep 30 08:07:12 UTC 2013


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.




More information about the storm mailing list