# query

```sql
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Explain String                                                                                                                                                                                  |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| PLAN FRAGMENT 0                                                                                                                                                                                 |
|  OUTPUT EXPRS:1: id | 2: timestamp | 3: slot | 4: transactionHash | 5: fee | 6: signers | 7: mint | 8: rent | 9: decimals | 10: mintAuthority | 11: freezeAuthority | 41: coalesce | 43: symbol |
|   PARTITION: UNPARTITIONED                                                                                                                                                                      |
|                                                                                                                                                                                                 |
|   RESULT SINK                                                                                                                                                                                   |
|                                                                                                                                                                                                 |
|   30:EXCHANGE                                                                                                                                                                                   |
|                                                                                                                                                                                                 |
| PLAN FRAGMENT 1                                                                                                                                                                                 |
|  OUTPUT EXPRS:                                                                                                                                                                                  |
|   PARTITION: RANDOM                                                                                                                                                                             |
|                                                                                                                                                                                                 |
|   STREAM DATA SINK                                                                                                                                                                              |
|     EXCHANGE ID: 30                                                                                                                                                                             |
|     UNPARTITIONED                                                                                                                                                                               |
|                                                                                                                                                                                                 |
|   29:Decode                                                                                                                                                                                     |
|   |  <dict id 44> : <string id 8>                                                                                                                                                               |
|   |  <dict id 45> : <string id 10>                                                                                                                                                              |
|   |  <dict id 46> : <string id 11>                                                                                                                                                              |
|   |                                                                                                                                                                                             |
|   28:Project                                                                                                                                                                                    |
|   |  <slot 1> : 1: id                                                                                                                                                                           |
|   |  <slot 2> : 2: timestamp                                                                                                                                                                    |
|   |  <slot 3> : 3: slot                                                                                                                                                                         |
|   |  <slot 4> : 4: transactionHash                                                                                                                                                              |
|   |  <slot 5> : 5: fee                                                                                                                                                                          |
|   |  <slot 6> : 6: signers                                                                                                                                                                      |
|   |  <slot 7> : 7: mint                                                                                                                                                                         |
|   |  <slot 9> : 9: decimals                                                                                                                                                                     |
|   |  <slot 41> : 41: coalesce                                                                                                                                                                   |
|   |  <slot 43> : 43: symbol                                                                                                                                                                     |
|   |  <slot 44> : 44: rent                                                                                                                                                                       |
|   |  <slot 45> : 45: mintAuthority                                                                                                                                                              |
|   |  <slot 46> : 46: freezeAuthority                                                                                                                                                            |
|   |                                                                                                                                                                                             |
|   27:HASH JOIN                                                                                                                                                                                  |
|   |  join op: RIGHT OUTER JOIN (BUCKET_SHUFFLE)                                                                                                                                                 |
|   |  colocate: false, reason:                                                                                                                                                                   |
|   |  equal join conjunct: 42: address = 7: mint                                                                                                                                                 |
|   |                                                                                                                                                                                             |
|   |----26:EXCHANGE                                                                                                                                                                              |
|   |                                                                                                                                                                                             |
|   0:OlapScanNode                                                                                                                                                                                |
|      TABLE: token_data_legacy                                                                                                                                                                   |
|      PREAGGREGATION: ON                                                                                                                                                                         |
|      partitions=1/1                                                                                                                                                                             |
|      rollup: token_data_legacy                                                                                                                                                                  |
|      tabletRatio=16/16                                                                                                                                                                          |
|      tabletList=3834800,3834801,3834802,3834803,3834804,3834805,3834806,3834807,3834808,3834809 ...                                                                                             |
|      cardinality=16333644                                                                                                                                                                       |
|      avgRowSize=49.18258                                                                                                                                                                        |
|                                                                                                                                                                                                 |
| PLAN FRAGMENT 2                                                                                                                                                                                 |
|  OUTPUT EXPRS:                                                                                                                                                                                  |
|   PARTITION: HASH_PARTITIONED: 12: tx                                                                                                                                                           |
|                                                                                                                                                                                                 |
|   STREAM DATA SINK                                                                                                                                                                              |
|     EXCHANGE ID: 26                                                                                                                                                                             |
|     BUCKET_SHUFFLE_HASH_PARTITIONED: 7: mint                                                                                                                                                    |
|                                                                                                                                                                                                 |
|   25:Project                                                                                                                                                                                    |
|   |  <slot 1> : 1: id                                                                                                                                                                           |
|   |  <slot 2> : 2: timestamp                                                                                                                                                                    |
|   |  <slot 3> : 3: slot                                                                                                                                                                         |
|   |  <slot 4> : 4: transactionHash                                                                                                                                                              |
|   |  <slot 5> : 5: fee                                                                                                                                                                          |
|   |  <slot 6> : 6: signers                                                                                                                                                                      |
|   |  <slot 7> : 7: mint                                                                                                                                                                         |
|   |  <slot 9> : 9: decimals                                                                                                                                                                     |
|   |  <slot 41> : coalesce(CAST(14: succeeded AS TINYINT), 0)                                                                                                                                    |
|   |  <slot 44> : 44: rent                                                                                                                                                                       |
|   |  <slot 45> : 45: mintAuthority                                                                                                                                                              |
|   |  <slot 46> : 46: freezeAuthority                                                                                                                                                            |
|   |                                                                                                                                                                                             |
|   24:HASH JOIN                                                                                                                                                                                  |
|   |  join op: RIGHT OUTER JOIN (PARTITIONED)                                                                                                                                                    |
|   |  colocate: false, reason:                                                                                                                                                                   |
|   |  equal join conjunct: 12: tx = 4: transactionHash                                                                                                                                           |
|   |                                                                                                                                                                                             |
|   |----23:EXCHANGE                                                                                                                                                                              |
|   |                                                                                                                                                                                             |
|   21:EXCHANGE                                                                                                                                                                                   |
|                                                                                                                                                                                                 |
| PLAN FRAGMENT 3                                                                                                                                                                                 |
|  OUTPUT EXPRS:                                                                                                                                                                                  |
|   PARTITION: RANDOM                                                                                                                                                                             |
|                                                                                                                                                                                                 |
|   STREAM DATA SINK                                                                                                                                                                              |
|     EXCHANGE ID: 23                                                                                                                                                                             |
|     HASH_PARTITIONED: 4: transactionHash                                                                                                                                                        |
|                                                                                                                                                                                                 |
|   22:OlapScanNode                                                                                                                                                                               |
|      TABLE: stg_mint_initialization_data_600_610                                                                                                                                                |
|      PREAGGREGATION: ON                                                                                                                                                                         |
|      partitions=1/2                                                                                                                                                                             |
|      rollup: stg_mint_initialization_data_600_610                                                                                                                                               |
|      tabletRatio=10/10                                                                                                                                                                          |
|      tabletList=133144775,133144776,133144777,133144778,133144779,133144780,133144781,133144782,133144783,133144784                                                                             |
|      cardinality=220                                                                                                                                                                            |
|      avgRowSize=345.62378                                                                                                                                                                       |
|                                                                                                                                                                                                 |
| PLAN FRAGMENT 4                                                                                                                                                                                 |
|  OUTPUT EXPRS:                                                                                                                                                                                  |
|   PARTITION: HASH_PARTITIONED: 12: tx, 14: succeeded                                                                                                                                            |
|                                                                                                                                                                                                 |
|   STREAM DATA SINK                                                                                                                                                                              |
|     EXCHANGE ID: 21                                                                                                                                                                             |
|     HASH_PARTITIONED: 12: tx                                                                                                                                                                    |
|                                                                                                                                                                                                 |
|   20:AGGREGATE (merge finalize)                                                                                                                                                                 |
|   |  group by: 12: tx, 14: succeeded                                                                                                                                                            |
|   |                                                                                                                                                                                             |
|   19:EXCHANGE                                                                                                                                                                                   |
|                                                                                                                                                                                                 |
| PLAN FRAGMENT 5                                                                                                                                                                                 |
|  OUTPUT EXPRS:                                                                                                                                                                                  |
|   colocate exec groups: ExecGroup{groupId=4, nodeIds=[16, 1, 17, 18, 8, 9]}                                                                                                                     |
|   PARTITION: RANDOM                                                                                                                                                                             |
|                                                                                                                                                                                                 |
|   STREAM DATA SINK                                                                                                                                                                              |
|     EXCHANGE ID: 19                                                                                                                                                                             |
|     HASH_PARTITIONED: 12: tx, 14: succeeded                                                                                                                                                     |
|                                                                                                                                                                                                 |
|   18:AGGREGATE (update serialize)                                                                                                                                                               |
|   |  STREAMING                                                                                                                                                                                  |
|   |  group by: 12: tx, 14: succeeded                                                                                                                                                            |
|   |                                                                                                                                                                                             |
|   17:Project                                                                                                                                                                                    |
|   |  <slot 12> : 12: tx                                                                                                                                                                         |
|   |  <slot 14> : 14: succeeded                                                                                                                                                                  |
|   |                                                                                                                                                                                             |
|   16:NESTLOOP JOIN                                                                                                                                                                              |
|   |  join op: INNER JOIN                                                                                                                                                                        |
|   |  colocate: false, reason:                                                                                                                                                                   |
|   |  other join predicates: 13: timestamp <= 39: max                                                                                                                                            |
|   |                                                                                                                                                                                             |
|   |----15:EXCHANGE                                                                                                                                                                              |
|   |                                                                                                                                                                                             |
|   9:Project                                                                                                                                                                                     |
|   |  <slot 12> : 12: tx                                                                                                                                                                         |
|   |  <slot 13> : 13: timestamp                                                                                                                                                                  |
|   |  <slot 14> : 14: succeeded                                                                                                                                                                  |
|   |                                                                                                                                                                                             |
|   8:NESTLOOP JOIN                                                                                                                                                                               |
|   |  join op: INNER JOIN                                                                                                                                                                        |
|   |  colocate: false, reason:                                                                                                                                                                   |
|   |  other join predicates: 13: timestamp >= 26: min                                                                                                                                            |
|   |                                                                                                                                                                                             |
|   |----7:EXCHANGE                                                                                                                                                                               |
|   |                                                                                                                                                                                             |
|   1:OlapScanNode                                                                                                                                                                                |
|      TABLE: transaction_info                                                                                                                                                                    |
|      PREAGGREGATION: ON                                                                                                                                                                         |
|      partitions=15899/15899                                                                                                                                                                     |
|      rollup: transaction_info                                                                                                                                                                   |
|      tabletRatio=144608/144608                                                                                                                                                                  |
|      tabletList=46552448,46552449,46552450,46552451,46552452,46552453,46552454,46552455,46552456,46552457 ...                                                                                   |
|      cardinality=325844561                                                                                                                                                                      |
|      avgRowSize=96.8051                                                                                                                                                                         |
|                                                                                                                                                                                                 |
| PLAN FRAGMENT 6                                                                                                                                                                                 |
|  OUTPUT EXPRS:                                                                                                                                                                                  |
|   PARTITION: UNPARTITIONED                                                                                                                                                                      |
|                                                                                                                                                                                                 |
|   STREAM DATA SINK                                                                                                                                                                              |
|     EXCHANGE ID: 15                                                                                                                                                                             |
|     UNPARTITIONED                                                                                                                                                                               |
|                                                                                                                                                                                                 |
|   14:ASSERT NUMBER OF ROWS                                                                                                                                                                      |
|   |  assert number of rows: LE 1                                                                                                                                                                |
|   |                                                                                                                                                                                             |
|   13:Project                                                                                                                                                                                    |
|   |  <slot 39> : 29: timestamp                                                                                                                                                                  |
|   |  limit: 1                                                                                                                                                                                   |
|   |                                                                                                                                                                                             |
|   12:MERGING-EXCHANGE                                                                                                                                                                           |
|      limit: 1                                                                                                                                                                                   |
|                                                                                                                                                                                                 |
| PLAN FRAGMENT 7                                                                                                                                                                                 |
|  OUTPUT EXPRS:                                                                                                                                                                                  |
|   PARTITION: RANDOM                                                                                                                                                                             |
|                                                                                                                                                                                                 |
|   STREAM DATA SINK                                                                                                                                                                              |
|     EXCHANGE ID: 12                                                                                                                                                                             |
|     UNPARTITIONED                                                                                                                                                                               |
|                                                                                                                                                                                                 |
|   11:TOP-N                                                                                                                                                                                      |
|   |  order by: <slot 29> 29: timestamp DESC                                                                                                                                                     |
|   |  offset: 0                                                                                                                                                                                  |
|   |  limit: 1                                                                                                                                                                                   |
|   |                                                                                                                                                                                             |
|   10:OlapScanNode                                                                                                                                                                               |
|      TABLE: stg_mint_initialization_data_600_610                                                                                                                                                |
|      PREAGGREGATION: ON                                                                                                                                                                         |
|      partitions=1/2                                                                                                                                                                             |
|      rollup: stg_mint_initialization_data_600_610                                                                                                                                               |
|      tabletRatio=10/10                                                                                                                                                                          |
|      tabletList=133144775,133144776,133144777,133144778,133144779,133144780,133144781,133144782,133144783,133144784                                                                             |
|      cardinality=220                                                                                                                                                                            |
|      avgRowSize=8.0                                                                                                                                                                             |
|                                                                                                                                                                                                 |
| PLAN FRAGMENT 8                                                                                                                                                                                 |
|  OUTPUT EXPRS:                                                                                                                                                                                  |
|   PARTITION: UNPARTITIONED                                                                                                                                                                      |
|                                                                                                                                                                                                 |
|   STREAM DATA SINK                                                                                                                                                                              |
|     EXCHANGE ID: 07                                                                                                                                                                             |
|     UNPARTITIONED                                                                                                                                                                               |
|                                                                                                                                                                                                 |
|   6:ASSERT NUMBER OF ROWS                                                                                                                                                                       |
|   |  assert number of rows: LE 1                                                                                                                                                                |
|   |                                                                                                                                                                                             |
|   5:Project                                                                                                                                                                                     |
|   |  <slot 26> : 16: timestamp                                                                                                                                                                  |
|   |  limit: 1                                                                                                                                                                                   |
|   |                                                                                                                                                                                             |
|   4:MERGING-EXCHANGE                                                                                                                                                                            |
|      limit: 1                                                                                                                                                                                   |
|                                                                                                                                                                                                 |
| PLAN FRAGMENT 9                                                                                                                                                                                 |
|  OUTPUT EXPRS:                                                                                                                                                                                  |
|   PARTITION: RANDOM                                                                                                                                                                             |
|                                                                                                                                                                                                 |
|   STREAM DATA SINK                                                                                                                                                                              |
|     EXCHANGE ID: 04                                                                                                                                                                             |
|     UNPARTITIONED                                                                                                                                                                               |
|                                                                                                                                                                                                 |
|   3:TOP-N                                                                                                                                                                                       |
|   |  order by: <slot 16> 16: timestamp ASC                                                                                                                                                      |
|   |  offset: 0                                                                                                                                                                                  |
|   |  limit: 1                                                                                                                                                                                   |
|   |                                                                                                                                                                                             |
|   2:OlapScanNode                                                                                                                                                                                |
|      TABLE: stg_mint_initialization_data_600_610                                                                                                                                                |
|      PREAGGREGATION: ON                                                                                                                                                                         |
|      partitions=1/2                                                                                                                                                                             |
|      rollup: stg_mint_initialization_data_600_610                                                                                                                                               |
|      tabletRatio=10/10                                                                                                                                                                          |
|      tabletList=133144775,133144776,133144777,133144778,133144779,133144780,133144781,133144782,133144783,133144784                                                                             |
|      cardinality=220                                                                                                                                                                            |
|      avgRowSize=8.0                                                                                                                                                                             |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
```