JSON Standard

Common Properties

Component Description

Projection

"Projection": {
  "Name": "r_name"
  "Alias": "name_1"
}

Condition

"Condition": {
  "Qual": "r_regionkey = 1"
}

Individual Plan Description

ScanNode

"Plan": {
  "PlanType": "SCAN"
  "RelationName": "region"
  "Projections": {
    "Projection": {
      "Name": "r_name"
    }
  }
  "Conditions": {
    "Cond": "r_regionkey = 1"
  }
}

GroupByNode

"Plan": {
  "PlanType": "GROUP_BY"
  "Keys": {
    "Key": "r_name"
  }
  "Measures": {
    "Projection": {
      "Name": "sum(r_regionkey)"
      "Alias": "sum_key"
    }
  }
  "Plan" {
    "PlanType": "SCAN"
    "RelationName": "region"
    "Projections": {
      "Projection": {
        "Name": "r_name"
      }
      "Projection": {
        "Name": "r_regionkey"
      }
    }
  }
}

JoinNode

"Plan": {
  "PlanType": "JOIN"
  "JoinType": "INNER"
  "Conditions": {
    "Cond": "r_regionkey = n_regionkey"
  }
  "Plan" {
    "PlanType": "SCAN"
    "ParentRelationship": "Outer"
    "RelationName": "region"
    "Projections": {
      "Projection": {
        "Name": "r_regionkey"
      }
    }
  }
  "Plan" {
    "PlanType": "SCAN"
    "ParentRelationship": "Inner"
    "RelationName": "nation"
    "Projections": {
      "Projection": {
        "Name": "n_regionkey"
      }
    }
  }
}

LogicalNodeConvertStandard (last edited 2014-04-02 12:36:21 by JihoonSon)