Skip to content

Instantly share code, notes, and snippets.

@aaneja

aaneja/QuickStats_SelfJoin.json

Created January 24, 2024 06:26
Show Gist options
  • Save aaneja/680aea3681ef7d592f0e20b8dbb92776 to your computer and use it in GitHub Desktop.
Save aaneja/680aea3681ef7d592f0e20b8dbb92776 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
QuickStats_SelfJoin.json
Query Plan
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
{
"id" : "8",
"name" : "Output",
"identifier" : "[_col0]",
"details" : "_col0 := expr (1:30)\n",
"children" : [ {
"id" : "353",
"name" : "RemoteStreamingExchange",
"identifier" : "[GATHER]",
"details" : "",
"children" : [ {
"id" : "238",
"name" : "Project",
"identifier" : "[projectLocality = LOCAL]",
"details" : "expr := INTEGER'1'\n",
"children" : [ {
"id" : "325",
"name" : "InnerJoin",
"identifier" : "[(\"r_regionkey\" = \"r_regionkey_0\")][$hashvalue, $hashvalue_9]",
"details" : "Distribution: REPLICATED\n",
"children" : [ {
"id" : "413",
"name" : "ScanProject",
"identifier" : "[table = TableHandle {connectorId='local_hms', connectorHandle='HiveTableHandle{schemaName=tpch_sf1_parquet, tableName=region_no_stats, analyzePartitionValues=Optional.empty}', layout='Optional[tpch_sf1_parquet.region_no_stats{}]'}, projectLocality = LOCAL]",
"details" : "$hashvalue := combine_hash(BIGINT'0', COALESCE($operator$hash_code(r_regionkey), BIGINT'0')) (1:38)\nLAYOUT: tpch_sf1_parquet.region_no_stats{}\nr_regionkey := r_regionkey:int:0:REGULAR (1:37)\n",
"children" : [ ],
"remoteSources" : [ ],
"estimates" : [ {
"outputRowCount" : 5.0,
"totalSize" : "NaN",
"confident" : true,
"variableStatistics" : {
"r_regionkey<integer>" : {
"lowValue" : 0.0,
"highValue" : 4.0,
"nullsFraction" : 0.0,
"averageRowSize" : "NaN",
"distinctValuesCount" : "NaN"
}
},
"joinNodeStatsEstimate" : {
"nullJoinBuildKeyCount" : "NaN",
"joinBuildKeyCount" : "NaN",
"nullJoinProbeKeyCount" : "NaN",
"joinProbeKeyCount" : "NaN"
},
"tableWriterNodeStatsEstimate" : {
"taskCountIfScaledWriter" : "NaN"
},
"partialAggregationStatsEstimate" : {
"inputBytes" : "NaN",
"outputBytes" : "NaN",
"inputRowCount" : "NaN",
"outputRowCount" : "NaN"
}
}, {
"outputRowCount" : 5.0,
"totalSize" : "NaN",
"confident" : true,
"variableStatistics" : {
"r_regionkey<integer>" : {
"lowValue" : 0.0,
"highValue" : 4.0,
"nullsFraction" : 0.0,
"averageRowSize" : "NaN",
"distinctValuesCount" : "NaN"
}
},
"joinNodeStatsEstimate" : {
"nullJoinBuildKeyCount" : "NaN",
"joinBuildKeyCount" : "NaN",
"nullJoinProbeKeyCount" : "NaN",
"joinProbeKeyCount" : "NaN"
},
"tableWriterNodeStatsEstimate" : {
"taskCountIfScaledWriter" : "NaN"
},
"partialAggregationStatsEstimate" : {
"inputBytes" : "NaN",
"outputBytes" : "NaN",
"inputRowCount" : "NaN",
"outputRowCount" : "NaN"
}
} ]
}, {
"id" : "384",
"name" : "LocalExchange",
"identifier" : "[HASH][$hashvalue_9] (r_regionkey_0)",
"details" : "",
"children" : [ {
"id" : "352",
"name" : "RemoteStreamingExchange",
"identifier" : "[REPLICATE]",
"details" : "",
"children" : [ {
"id" : "414",
"name" : "ScanProject",
"identifier" : "[table = TableHandle {connectorId='local_hms', connectorHandle='HiveTableHandle{schemaName=tpch_sf1_parquet, tableName=region_no_stats, analyzePartitionValues=Optional.empty}', layout='Optional[tpch_sf1_parquet.region_no_stats{}]'}, projectLocality = LOCAL]",
"details" : "$hashvalue_11 := combine_hash(BIGINT'0', COALESCE($operator$hash_code(r_regionkey_0), BIGINT'0')) (1:57)\nLAYOUT: tpch_sf1_parquet.region_no_stats{}\nr_regionkey_0 := r_regionkey:int:0:REGULAR (1:57)\n",
"children" : [ ],
"remoteSources" : [ ],
"estimates" : [ {
"outputRowCount" : 5.0,
"totalSize" : "NaN",
"confident" : true,
"variableStatistics" : {
"r_regionkey_0<integer>" : {
"lowValue" : 0.0,
"highValue" : 4.0,
"nullsFraction" : 0.0,
"averageRowSize" : "NaN",
"distinctValuesCount" : "NaN"
}
},
"joinNodeStatsEstimate" : {
"nullJoinBuildKeyCount" : "NaN",
"joinBuildKeyCount" : "NaN",
"nullJoinProbeKeyCount" : "NaN",
"joinProbeKeyCount" : "NaN"
},
"tableWriterNodeStatsEstimate" : {
"taskCountIfScaledWriter" : "NaN"
},
"partialAggregationStatsEstimate" : {
"inputBytes" : "NaN",
"outputBytes" : "NaN",
"inputRowCount" : "NaN",
"outputRowCount" : "NaN"
}
}, {
"outputRowCount" : 5.0,
"totalSize" : "NaN",
"confident" : true,
"variableStatistics" : {
"r_regionkey_0<integer>" : {
"lowValue" : 0.0,
"highValue" : 4.0,
"nullsFraction" : 0.0,
"averageRowSize" : "NaN",
"distinctValuesCount" : "NaN"
}
},
"joinNodeStatsEstimate" : {
"nullJoinBuildKeyCount" : "NaN",
"joinBuildKeyCount" : "NaN",
"nullJoinProbeKeyCount" : "NaN",
"joinProbeKeyCount" : "NaN"
},
"tableWriterNodeStatsEstimate" : {
"taskCountIfScaledWriter" : "NaN"
},
"partialAggregationStatsEstimate" : {
"inputBytes" : "NaN",
"outputBytes" : "NaN",
"inputRowCount" : "NaN",
"outputRowCount" : "NaN"
}
} ]
} ],
"remoteSources" : [ ],
"estimates" : [ {
"outputRowCount" : 5.0,
"totalSize" : "NaN",
"confident" : true,
"variableStatistics" : {
"r_regionkey_0<integer>" : {
"lowValue" : 0.0,
"highValue" : 4.0,
"nullsFraction" : 0.0,
"averageRowSize" : "NaN",
"distinctValuesCount" : "NaN"
}
},
"joinNodeStatsEstimate" : {
"nullJoinBuildKeyCount" : "NaN",
"joinBuildKeyCount" : "NaN",
"nullJoinProbeKeyCount" : "NaN",
"joinProbeKeyCount" : "NaN"
},
"tableWriterNodeStatsEstimate" : {
"taskCountIfScaledWriter" : "NaN"
},
"partialAggregationStatsEstimate" : {
"inputBytes" : "NaN",
"outputBytes" : "NaN",
"inputRowCount" : "NaN",
"outputRowCount" : "NaN"
}
} ]
} ],
"remoteSources" : [ ],
"estimates" : [ {
"outputRowCount" : 5.0,
"totalSize" : "NaN",
"confident" : true,
"variableStatistics" : {
"r_regionkey_0<integer>" : {
"lowValue" : 0.0,
"highValue" : 4.0,
"nullsFraction" : 0.0,
"averageRowSize" : "NaN",
"distinctValuesCount" : "NaN"
}
},
"joinNodeStatsEstimate" : {
"nullJoinBuildKeyCount" : "NaN",
"joinBuildKeyCount" : "NaN",
"nullJoinProbeKeyCount" : "NaN",
"joinProbeKeyCount" : "NaN"
},
"tableWriterNodeStatsEstimate" : {
"taskCountIfScaledWriter" : "NaN"
},
"partialAggregationStatsEstimate" : {
"inputBytes" : "NaN",
"outputBytes" : "NaN",
"inputRowCount" : "NaN",
"outputRowCount" : "NaN"
}
} ]
} ],
"remoteSources" : [ ],
"estimates" : [ {
"outputRowCount" : "NaN",
"totalSize" : "NaN",
"confident" : false,
"variableStatistics" : { },
"joinNodeStatsEstimate" : {
"nullJoinBuildKeyCount" : "NaN",
"joinBuildKeyCount" : "NaN",
"nullJoinProbeKeyCount" : "NaN",
"joinProbeKeyCount" : "NaN"
},
"tableWriterNodeStatsEstimate" : {
"taskCountIfScaledWriter" : "NaN"
},
"partialAggregationStatsEstimate" : {
"inputBytes" : "NaN",
"outputBytes" : "NaN",
"inputRowCount" : "NaN",
"outputRowCount" : "NaN"
}
} ]
} ],
"remoteSources" : [ ],
"estimates" : [ {
"outputRowCount" : "NaN",
"totalSize" : "NaN",
"confident" : false,
"variableStatistics" : { },
"joinNodeStatsEstimate" : {
"nullJoinBuildKeyCount" : "NaN",
"joinBuildKeyCount" : "NaN",
"nullJoinProbeKeyCount" : "NaN",
"joinProbeKeyCount" : "NaN"
},
"tableWriterNodeStatsEstimate" : {
"taskCountIfScaledWriter" : "NaN"
},
"partialAggregationStatsEstimate" : {
"inputBytes" : "NaN",
"outputBytes" : "NaN",
"inputRowCount" : "NaN",
"outputRowCount" : "NaN"
}
} ]
} ],
"remoteSources" : [ ],
"estimates" : [ {
"outputRowCount" : "NaN",
"totalSize" : "NaN",
"confident" : false,
"variableStatistics" : { },
"joinNodeStatsEstimate" : {
"nullJoinBuildKeyCount" : "NaN",
"joinBuildKeyCount" : "NaN",
"nullJoinProbeKeyCount" : "NaN",
"joinProbeKeyCount" : "NaN"
},
"tableWriterNodeStatsEstimate" : {
"taskCountIfScaledWriter" : "NaN"
},
"partialAggregationStatsEstimate" : {
"inputBytes" : "NaN",
"outputBytes" : "NaN",
"inputRowCount" : "NaN",
"outputRowCount" : "NaN"
}
} ]
} ],
"remoteSources" : [ ],
"estimates" : [ {
"outputRowCount" : "NaN",
"totalSize" : "NaN",
"confident" : false,
"variableStatistics" : { },
"joinNodeStatsEstimate" : {
"nullJoinBuildKeyCount" : "NaN",
"joinBuildKeyCount" : "NaN",
"nullJoinProbeKeyCount" : "NaN",
"joinProbeKeyCount" : "NaN"
},
"tableWriterNodeStatsEstimate" : {
"taskCountIfScaledWriter" : "NaN"
},
"partialAggregationStatsEstimate" : {
"inputBytes" : "NaN",
"outputBytes" : "NaN",
"inputRowCount" : "NaN",
"outputRowCount" : "NaN"
}
} ]
}
(1 row)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment