[STORM-2057] Support JOIN statement in Storm SQL

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.0.0, 1.1.0
• Component/s: storm-sql
• Epic Link: SQL support for Storm Phase II -- support aggregations and simplify deployment
• Assignee: Jungtaek Lim
• Reporter: Jungtaek Lim
• Created: 26/Aug/16 02:15
• Updated: 13/Sep/16 04:48
• Resolved: 13/Sep/16 04:48

Description

It would be great to support JOIN statement in Storm SQL.

http://storm.apache.org/releases/1.0.1/Trident-API-Overview.html

According to this page, Trident supports 'join' across multiple spouts which is done by synchronizing spouts.
This might be good start for Storm SQL join feature. This restricts the boundary of join to batch, but we're OK for now since aggregation is implemented via same restriction.

Issue Links

• links to: GitHub Pull Request #1656