Hi devs, I'm going to address STORM-1444 <https://issues.apache.org/jira/browse/STORM-1444> : Support EXPLAIN statement in StormSQL, and need our opinions about this.
SqlRunner analyzes sql statements from given file and converts each statement to Trident topology (without DDL statement) and submits. (This means SqlRunner may submit multiple topologies.) If we just handle EXPLAIN only bound to specific sql statement, only that statement is not submitted but shows the plan, and other statements will be submitted. If we don't allow EXPLAIN in statement level but having "explain mode" of SqlRunner, SqlRunner will show the plan for each sql statement (without DDL statement). Which do you think makes more sense to you? Thanks, Jungtaek Lim (HeartSaVioR) ps. I also feel that reading sql statements from file is already inconvenient for just 'EXPLAIN', but since Storm SQL doesn't register table to somewhere, DDL statements are needed before DML. Might need to have REPL eventually.... Need to think more about this side.
