Created
January 24, 2024 06:26
-
-
Save aaneja/680aea3681ef7d592f0e20b8dbb92776 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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