to convert sql to a logical plan as a tree?

dolphin
2011-04-26
2013-05-14
  • dolphin
    dolphin
    2011-04-26

    Hi,

    I parsed SQL using pyparsing, but I can hardly get a tree-like logical plan since it just produce tokens. Do you have any suggestion that how can I get a tree structure for a SQL ?
    For example, here is a simple SQL : select * from x, y where x.a = y.b    and I want to get the logical plan like:

                          

    Thanks !

     
  • PAscal
    PAscal
    2011-05-06

    Have a look at revj (reverse snowflakes joins) and its demo site http://snowflakejoins.com/
    Regards

    PAscal