Skip to content

Instantly share code, notes, and snippets.

@wyukawa

wyukawa/gist:181599ddb1b923b6d2cb4bb3f0e6f996

Created February 1, 2018 12:03
Show Gist options
  • Save wyukawa/181599ddb1b923b6d2cb4bb3f0e6f996 to your computer and use it in GitHub Desktop.
Save wyukawa/181599ddb1b923b6d2cb4bb3f0e6f996 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
presto:default> set session iterative_optimizer_enabled = false;
SET SESSION
presto:default> explain ...
- Output[...
- RemoteExchange[GATHER] =>
- Project[] => [
- LeftJoin[(
- Project[] => [
- Project[] => [
- LeftJoin[
- Project[] => [
- Project[] => [
- LeftJoin[(
- Project[] => [
- LeftJoin[(
- Project[] => [
- LeftJoin[(
- Project[] => [
- InnerJoin[(
- RemoteExchange[REPARTITION][
- Project[] => [
- InnerJoin[(
- InnerJoin[(
Cost: {rows: 0, bytes: ?}
- InnerJoin[(
Cost: {rows: 0, bytes: ?}
- InnerJoin[(
Cost: {rows: 0, bytes: ?}
- RemoteExchange[REPARTITION][$hashvalue_682] =>
Cost: {rows: 0, bytes: ?}
- ScanFilterProject[
Cost: {rows: 0, bytes: ?}/{rows: 0, bytes: ?}/{rows: 0, bytes: ?}
HiveColumnHandle{name=dt, hiveType=string, hiveColumnIndex=-1, columnType=PARTITION_KEY}
:: [[20180131]]
- LocalExchange[HASH][$hashvalue_684] ("id_87") =>
Cost: {rows: 0, bytes: ?}
- RemoteExchange[REPARTITION][$hashvalue_685] =>
Cost: {rows: 0, bytes: ?}
- ScanProject[
Cost: {rows: 0, bytes: ?}/{rows: 0, bytes: ?}
HiveColumnHandle{name=dt, hiveType=string, hiveColumnIndex=-1, columnType=PARTITION_KEY}
:: [[20180131]]
- LocalExchange[HASH][$hashvalue_687] ("id_143") => id_143:bigint, $hashvalue_687:bigint
Cost: {rows: 0, bytes: ?}
- RemoteExchange[REPARTITION][$hashvalue_688] => id_143:bigint, $hashvalue_688:bigint
Cost: {rows: 0, bytes: ?}
- ScanFilterProject[
Cost: {rows: 0, bytes: ?}/{rows: 0, bytes: ?}/{rows: 0, bytes: ?}
HiveColumnHandle{name=dt, hiveType=string, hiveColumnIndex=-1, columnType=PARTITION_KEY}
:: [[20180131]]
- LocalExchange[HASH][$hashvalue_690]
Cost: {rows: 0, bytes: ?}
- RemoteExchange[REPARTITION][$hashvalue_691] =>
Cost: {rows: 0, bytes: ?}
- ScanFilterProject[
Cost: {rows: 0, bytes: ?}/{rows: 0, bytes: ?}/{rows: 0, bytes: ?}
HiveColumnHandle{name=dt, hiveType=string, hiveColumnIndex=-1, columnType=PARTITION_KEY}
:: [[20180131]]
- LocalExchange[HASH][$hashvalue_693] (
- RemoteExchange[REPARTITION][$hashvalue_694] =>
- Project[] => [
- Aggregate(FINAL)[
- LocalExchange[HASH][$hashvalue_695] (
- RemoteExchange[REPARTITION][$hashvalue_696] =>
- Aggregate(PARTIAL)[
- Project[] => [
Cost: {rows: 807318, bytes: ?}
- ScanFilterProject[table =
Cost: {rows: 1614637, bytes: ?}/{rows: 807318, bytes: ?}/{rows: 807318, bytes: ?}
dt_409 := HiveColumnHandle{name=dt, hiveType=string, hiveColumnIndex=-1, columnType=PARTITION_KEY}
:: [[20180101], [20180102], [20180103], [20180104], [20180105], [20180106], [20180107], [20180108], [20180109], [20180110], [20180111], [20180112], [20180113], [20180114], [20180115], [20180116], [20180117], [20180118], [20180119], [20180120],
platform := HiveColumnHandle{name=platform, hiveType=string, hiveColumnIndex=1, columnType=REGULAR}
- LocalExchange[HASH][$hashvalue_700]
Cost: {rows: 0, bytes: ?}
- RemoteExchange[REPARTITION][$hashvalue_701] =>
Cost: {rows: 0, bytes: ?}
- Project[] =>
Cost: {rows: 0, bytes: ?}
- ScanFilterProject[
Cost: {rows: 0, bytes: ?}/{rows: 0, bytes: ?}/{rows: 0, bytes: ?}
- LocalExchange[HASH][$hashvalue_704]
- RemoteExchange[REPARTITION] =>
- Aggregate(FINAL)
sum_443 := "sum"("sum_679")
- LocalExchange[HASH][$hashvalue_706]
- RemoteExchange[REPARTITION][$hashvalue_707] =>
- Aggregate(PARTIAL)
sum_679 := "sum"("expr_439")
- Project[] => [
Cost: {rows: 17622384, bytes: ?}
- ScanProject[
Cost: {rows: 17622384, bytes: ?}/{rows: 17622384, bytes: ?}
dt_435 := HiveColumnHandle{name=dt, hiveType=string, hiveColumnIndex=-1, columnType=PARTITION_KEY}
:: [[20161114, 20180131]]
- LocalExchange[HASH][$hashvalue_710]
- Project[] => [
- RemoteExchange[REPARTITION][$hashvalue_712] =>
- Project[] =>
- Aggregate(FINAL)
count := "count"("count_680")
- LocalExchange[HASH]
- RemoteExchange[REPARTITION]
- Aggregate(PARTIAL)
count_680 := "count"(*)
- Project[] =>
Cost: {rows: 65638, bytes: ?}
- ScanFilterProject[
Cost: {rows: 131276, bytes: ?}/{rows: 65638, bytes: ?}/{rows: 65638, bytes: ?}
dt_468 := HiveColumnHandle{name=dt, hiveType=string, hiveColumnIndex=-1, columnType=PARTITION_KEY}
:: [[20180101], [20180102], [20180103], [20180104], [20180105], [20180106], [20180107], [20180108], [20180109], [20180110], [20180111], [20180112], [20180113], [20180114], [20180115], [20180116], [20180117], [20180118], [20180119], [20180120], [20180121], [20180122],
- LocalExchange[HASH][$hashvalue_719]
- RemoteExchange[REPARTITION] =>
- Project[] =>
- Aggregate(FINAL)
- LocalExchange[HASH]
- RemoteExchange[REPARTITION]
- Aggregate(PARTIAL)
- Project[] =>
- ScanFilterProject
Cost: {rows: 2027002, bytes: ?}/{rows: 1013501, bytes: ?}/{rows: 1013501, bytes: ?}
dt_519 := HiveColumnHandle{name=dt, hiveType=string, hiveColumnIndex=-1, columnType=PARTITION_KEY}
:: [[20161114, 20180131]]
status_509 := HiveColumnHandle{name=status, hiveType=tinyint, hiveColumnIndex=19, columnType=REGULAR}
- LocalExchange[HASH][$hashvalue_726]
Cost: {rows: 4371341, bytes: ?}
- RemoteExchange[REPARTITION] =>
Cost: {rows: 4371341, bytes: ?}
- ScanFilterProject[
Cost: {rows: 8742683, bytes: ?}/{rows: 4371341, bytes: ?}/{rows: 4371341, bytes: ?}
dt_543 := HiveColumnHandle{name=dt, hiveType=string, hiveColumnIndex=-1, columnType=PARTITION_KEY}
:: [[20131031, 20180131]]
- LocalExchange[HASH]
Cost: {rows: 8742683, bytes: ?}
- RemoteExchange[REPARTITION]
Cost: {rows: 8742683, bytes: ?}
- ScanProject[
Cost: {rows: 8742683, bytes: ?}/{rows: 8742683, bytes: ?}
dt_576 := HiveColumnHandle{name=dt, hiveType=string, hiveColumnIndex=-1, columnType=PARTITION_KEY}
:: [[20131031, 20180131]]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment