예제 #1
0
  public static void main(String[] args) {
    PlanFactory f = getInstance();

    // DAU
    // SELECT COUNT(DISTINCT(uid))
    // FROM event NATURAL JOIN user
    // WHERE user.register_time='2013-02-01'
    // AND event.date='2013-02-02' and event.event='visit'
    f.newGroup()
        .setInput(
            f.newDistinct()
                .setInput(
                    f.newJoin()
                        .setInput(
                            f.newSelection()
                                .setInput(
                                    f.newTableScan("user"),
                                    new Equals(
                                        new ColumnValue("register_time"),
                                        new Constant("2013-02-01"))),
                            f.newSelection()
                                .setInput(
                                    f.newTableScan("event"),
                                    new And(
                                        new Equals(
                                            new ColumnValue("date"), new Constant("2013-02-02")),
                                        new Equals(
                                            new ColumnValue("event"), new Constant("visit"))))),
                    new ColumnValue("uid")),
            null,
            null);
  }
예제 #2
0
 @Override
 public void visit(SubJoin subJoin) {
   FromItem left = subJoin.getLeft();
   FromItem right = subJoin.getJoin().getRightItem();
   FromItemVisitorImpl leftVisitor = new FromItemVisitorImpl(where);
   FromItemVisitorImpl rightVisitor = new FromItemVisitorImpl(where);
   left.accept(leftVisitor);
   right.accept(rightVisitor);
   relationProvider = PlanFactory.getInstance().newJoin();
   ((Join) relationProvider)
       .setInput(leftVisitor.getRelationProvider(), rightVisitor.getRelationProvider());
 }
예제 #3
0
 @Override
 public void visit(Table table) {
   TableScan tableScan = PlanFactory.getInstance().newTableScan(table.getName());
   relationProvider = PlanFactory.getInstance().newSelection();
   ((Selection) relationProvider).setInput(tableScan, getWhere(tableScan));
 }