StarRocks / starrocks

StarRocks, a Linux Foundation project, is a next-generation sub-second MPP OLAP database for full analytics scenarios, including multi-dimensional analytics, real-time analytics, and ad-hoc queries.
https://starrocks.io
Apache License 2.0
8.67k stars 1.75k forks source link

[main-release] select error:Backend node not found when enable_short_circuit = true and all BE alive #46828

Closed tiannan-sr closed 3 months ago

tiannan-sr commented 3 months ago

Steps to reproduce the behavior (Required)

  1. create table:
    ADMIN SET FRONTEND CONFIG ("enable_experimental_rowstore" = "true");
    CREATE TABLE pri_par_tbl (
                    `k1` date not null,
                    `k2` datetime not null,
                    `k3` varchar(20) not null,
                    `k4` varchar(20) not null,
                    `k5` boolean not null,
                    `v1` tinyint,
                    `v2` smallint,
                    `v3` int,
                    `v4` bigint,
                    `v5` largeint,
                    `v6` float,
                    `v7` double,
                    `v8` decimal(27,9)
                )
                PRIMARY KEY(`k1`, `k2`, `k3`, `k4`, `k5`)
                COMMENT "OLAP"
                PARTITION BY RANGE(`k1`)
                (
                    PARTITION `p202006` VALUES LESS THAN ("2020-07-01"),
                    PARTITION `p202007` VALUES LESS THAN ("2020-08-01"),
                    PARTITION `p202008` VALUES LESS THAN ("2020-09-01")
                )
                DISTRIBUTED BY HASH(`k1`, `k2`, `k3`, `k4`, `k5`) BUCKETS 3
                order by(k3,k1)
                PROPERTIES ("storage_type" = "column_with_row");
  2. select:
    set enable_short_circuit = true;
    select * from pri_par_tbl partition(p202007, p202008)
                where k3 in ('beijing', 'shenzhen', 'shenyang')
                  and k5 = true
                  and k1 in ('2020-06-24', '2020-06-30')
                  and k2 = '2020-07-01 02:19:10'
                  and k4 in ('chaoyang', 'luohu');

    img_v3_02bo_7cea6e0e-0d47-42c4-b490-2c19a8b1022g

Expected behavior (Required)

select ok when enable_short_circuit

Real behavior (Required)

select error

StarRocks version (Required)

Jay-ju commented 3 months ago

i will resovle