Skip to content

Query cann't hit rollup  #1254

@qdore

Description

@qdore

Describe the bug
This sql can't hit rollup:

explain select cuid from visd_dws_topic_novel_wide_table2 where event_day='20190527' and is_na = 1 and bhv_type = 'show' and id = '10053' group by cuid;

image

Table Schema

+----------------------+---------------+------+-------+------------+-----------+
| Field                | Type          | Null | Key   | Default    | Extra     |
+----------------------+---------------+------+-------+------------+-----------+
| cuid                 | VARCHAR(128)  | No   | true  |            |           |
| sid                  | VARCHAR(50)   | No   | true  |            |           |
| os_name              | VARCHAR(20)   | No   | true  |            |           |
| soft_version         | VARCHAR(20)   | No   | true  |            |           |
| appid                | VARCHAR(20)   | No   | true  |            |           |
| from                 | VARCHAR(20)   | No   | true  |            |           |
| value                | VARCHAR(50)   | No   | true  |            |           |
| page                 | VARCHAR(30)   | No   | true  |            |           |
| source               | VARCHAR(50)   | No   | true  |            |           |
| tpl_id               | VARCHAR(20)   | No   | true  |            |           |
| tpl_name             | VARCHAR(50)   | No   | true  |            |           |
| tpl_pos              | VARCHAR(50)   | No   | true  |            |           |
| sub_pos              | VARCHAR(50)   | No   | true  |            |           |
| page_id              | VARCHAR(20)   | No   | true  |            |           |
| book_id              | VARCHAR(20)   | No   | true  |            |           |
| cid                  | VARCHAR(128)  | No   | true  |            |           |
| is_genuine           | VARCHAR(10)   | No   | true  |            |           |
| save_content         | VARCHAR(10)   | No   | true  |            |           |
| is_free              | VARCHAR(10)   | No   | true  |            |           |
| target_index         | VARCHAR(10)   | No   | true  |            |           |
| target_gid           | VARCHAR(20)   | No   | true  |            |           |
| target_source        | VARCHAR(20)   | No   | true  |            |           |
| id                   | VARCHAR(20)   | No   | true  |            |           |
| page_type            | VARCHAR(50)   | No   | true  |            |           |
| bhv_type             | VARCHAR(20)   | No   | true  |            |           |
| is_start             | VARCHAR(10)   | No   | true  |            |           |
| tpl_content_item_num | INT           | No   | true  | 0          |           |
| paid_type            | VARCHAR(30)   | No   | true  |            |           |
| region               | VARCHAR(128)  | No   | true  |            |           |
| channel              | VARCHAR(30)   | No   | true  |            |           |
| cfrom                | VARCHAR(30)   | No   | true  |            |           |
| country              | VARCHAR(20)   | No   | true  |            |           |
| province             | VARCHAR(20)   | No   | true  |            |           |
| city                 | VARCHAR(30)   | No   | true  |            |           |
| manufacturer         | VARCHAR(20)   | No   | true  |            |           |
| mode_id              | VARCHAR(50)   | No   | true  |            |           |
| is_na                | INT           | Yes  | true  | 0          |           |
| location             | VARCHAR(50)   | Yes  | true  | 0          |           |
| event_hour           | CHAR(2)       | Yes  | true  | 00         |           |
| event_day            | DATE          | No   | true  | 2000-01-01 |           |
| duration             | DECIMAL(20,2) | No   | false | 0.0        | SUM       |
| pv                   | BIGINT        | No   | false | 0          | SUM       |

Rollup Schema

| visd_dws_topic_novel_wide_table2_sid_rollup2                  | sid                  | VARCHAR(50)   | No   | true  |            |           |
|                                                               | cuid                 | VARCHAR(128)  | No   | true  |            |           |
|                                                               | event_day            | DATE          | No   | true  | 2000-01-01 |           |
|                                                               | page_type            | VARCHAR(50)   | No   | true  |            |           |
|                                                               | os_name              | VARCHAR(20)   | No   | true  |            |           |
|                                                               | appid                | VARCHAR(20)   | No   | true  |            |           |
|                                                               | id                   | VARCHAR(20)   | No   | true  |            |           |
|                                                               | tpl_name             | VARCHAR(50)   | No   | true  |            |           |
|                                                               | tpl_content_item_num | INT           | No   | true  | 0          |           |
|                                                               | is_na                | INT           | Yes  | true  | 0          |           |
|                                                               | is_free              | VARCHAR(10)   | No   | true  |            |           |
|                                                               | bhv_type             | VARCHAR(20)   | No   | true  |            |           |
|                                                               | source               | VARCHAR(50)   | No   | true  |            |           |
|                                                               | page                 | VARCHAR(30)   | No   | true  |            |           |
|                                                               | duration             | DECIMAL(20,2) | No   | false | 0.0        | SUM       |
|                                                               | pv                   | BIGINT        | No   | false | 0          | SUM       |
|                                                               | uv_set               | HLL           | Yes  | false | 0          | HLL_UNION |
|                                                               |                      |

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions