pingcap / tiflash

The analytical engine for TiDB and TiDB Cloud. Try free: https://tidbcloud.com/free-trial
https://docs.pingcap.com/tidb/stable/tiflash-overview
Apache License 2.0
936 stars 409 forks source link

support push calculation of type 'enum' to TiFlash #9172

Open giant-panda666 opened 6 days ago

giant-panda666 commented 6 days ago

Feature Request

Is your feature request related to a problem? Please describe:

  1. create table t0 and t1
    create table t0(id int primary key, v int, vv enum('A1', 'A2', 'A3'));
    create table t1(id int primary key, v int, vv enum('B1', 'B2', 'B3'));
  2. execute expain
    explain analyze select/*+ read_from_storage(tiflash[a], tiflash[b]) */ a.v, b.v, a.vv, b.vv from t0 a join t1 b on a.id=b.id where a.vv='A1';

    image

there are some warnings: image

enum type is used frequently as basic type, so why TiFlash don't support it ?

Describe the feature you'd like:

Describe alternatives you've considered:

Teachability, Documentation, Adoption, Migration Strategy: