[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