Failed to execute question for question 016e09b9-ca44-4009-b756-558570eb6cf5

[yiwen92]

Hi, it's failed to execute question

Question title

the latest update in github

Error message

Query execution was interrupted

Generated SQL

SELECT
  `ge`.`repo_name` AS `repo_name`,
  `ge`.`created_at` AS `created_at`,
  `ge`.`type` AS `type`,
  `ge`.`action` AS `action`,
  `ge`.`number` AS `number`,
  `gr`.`pushed_at` AS `pushed_at`,
  `gr`.`updated_at` AS `updated_at`
FROM
  `github_events` AS `ge`
  INNER JOIN `github_repos` AS `gr` ON `ge`.`repo_id` = `gr`.`repo_id`
ORDER BY
  `created_at` DESC
LIMIT
  20

Chart info

{
  "chartName": "Table",
  "columns": [
    "repo_name",
    "created_at",
    "type",
    "action",
    "number",
    "pushed_at",
    "updated_at"
  ],
  "title": "Latest Updates in GitHub"
}

[yiwen92]

just want to see how real-time OSSinsight data can be, Is this sql too bad for db engine to execute?

[Mini256]

+------------------------------------------+---------------+--------------+---------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| id                                       | estRows       | task         | access object | operator info                                                                                                                                                                                                                                                        |
+------------------------------------------+---------------+--------------+---------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Projection_11                            | 20.00         | root         |               | gharchive_dev.github_events.repo_name, gharchive_dev.github_events.created_at, gharchive_dev.github_events.type, gharchive_dev.github_events.action, gharchive_dev.github_events.number, gharchive_dev.github_repos.pushed_at, gharchive_dev.github_repos.updated_at |
| └─TopN_15                                | 20.00         | root         |               | gharchive_dev.github_events.created_at:desc, offset:0, count:20                                                                                                                                                                                                      |
|   └─TableReader_82                       | 20.00         | root         | partition:all | data:ExchangeSender_81                                                                                                                                                                                                                                               |
|     └─ExchangeSender_81                  | 20.00         | mpp[tiflash] |               | ExchangeType: PassThrough                                                                                                                                                                                                                                            |
|       └─TopN_80                          | 20.00         | mpp[tiflash] |               | gharchive_dev.github_events.created_at:desc, offset:0, count:20                                                                                                                                                                                                      |
|         └─Projection_79                  | 5532019372.78 | mpp[tiflash] |               | gharchive_dev.github_events.type, gharchive_dev.github_events.created_at, gharchive_dev.github_events.repo_name, gharchive_dev.github_events.action, gharchive_dev.github_events.number, gharchive_dev.github_repos.pushed_at, gharchive_dev.github_repos.updated_at |
|           └─HashJoin_73                  | 5532019372.78 | mpp[tiflash] |               | inner join, equal:[eq(gharchive_dev.github_repos.repo_id, gharchive_dev.github_events.repo_id)]                                                                                                                                                                      |
|             ├─ExchangeReceiver_76(Build) | 326019939.00  | mpp[tiflash] |               |                                                                                                                                                                                                                                                                      |
|             │ └─ExchangeSender_75        | 326019939.00  | mpp[tiflash] |               | ExchangeType: HashPartition, Hash Cols: [name: Column#75, collate: binary]                                                                                                                                                                                           |
|             │   └─Projection_74          | 326019939.00  | mpp[tiflash] |               | gharchive_dev.github_repos.repo_id, gharchive_dev.github_repos.pushed_at, gharchive_dev.github_repos.updated_at, cast(gharchive_dev.github_repos.repo_id, bigint(20))->Column#75                                                                                     |
|             │     └─TableFullScan_42     | 326019939.00  | mpp[tiflash] | table:gr      | keep order:false                                                                                                                                                                                                                                                     |
|             └─ExchangeReceiver_47(Probe) | 5484347451.00 | mpp[tiflash] |               |                                                                                                                                                                                                                                                                      |
|               └─ExchangeSender_46        | 5484347451.00 | mpp[tiflash] |               | ExchangeType: HashPartition, Hash Cols: [name: gharchive_dev.github_events.repo_id, collate: binary]                                                                                                                                                                 |
|                 └─TableFullScan_45       | 5484347451.00 | mpp[tiflash] | table:ge      | keep order:false, PartitionTableScan:true                                                                                                                                                                                                                            |
+------------------------------------------+---------------+--------------+---------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
14 rows in set
Time: 0.191s

From the execution plan, this is a bad SQL. @qw4990 @chrysan PTAL～