kangpinghuang opened a new issue #3014: [segment v2] too many seek will bring performance degradation URL: https://github.com/apache/incubator-doris/issues/3014 when I test ssb test with sf20 in segment v2 with bitmap. I create the table by using: CREATE TABLE `topic_lineorder` ( `lo_orderkey` bigint(20) NULL COMMENT "", `lo_linenumber` bigint(20) NULL COMMENT "", `lo_custkey` int(11) NULL COMMENT "", `c_custkey` int(11) NULL COMMENT "", `c_name` varchar(25) NULL COMMENT "", `c_address` varchar(40) NULL COMMENT "", `c_city` varchar(10) NULL COMMENT "", `c_nation` varchar(15) NULL COMMENT "", `c_region` varchar(12) NULL COMMENT "", `c_phone` varchar(15) NULL COMMENT "", `c_mktsegment` varchar(10) NULL COMMENT "", `lo_partkey` int(11) NULL COMMENT "", `p_name` varchar(22) NULL COMMENT "", `p_mfgr` varchar(6) NULL COMMENT "", `p_category` varchar(7) NULL COMMENT "", `p_brand` varchar(9) NULL COMMENT "", `p_color` varchar(11) NULL COMMENT "", `p_type` varchar(25) NULL COMMENT "", `p_size` int(11) NULL COMMENT "", `p_container` varchar(10) NULL COMMENT "", `lo_suppkey` int(11) NULL COMMENT "", `s_name` varchar(25) NULL COMMENT "", `s_address` varchar(25) NULL COMMENT "", `s_city` varchar(10) NULL COMMENT "", `s_nation` varchar(15) NULL COMMENT "", `s_region` varchar(12) NULL COMMENT "", `s_phone` varchar(15) NULL COMMENT "", `lo_orderdate` int(11) NULL COMMENT "", `d_date` varchar(19) NULL COMMENT "", `d_dayofweek` varchar(9) NULL COMMENT "", `d_month` varchar(10) NULL COMMENT "", `d_year` int(11) NULL COMMENT "", `d_yearmonthnum` int(11) NULL COMMENT "", `d_yearmonth` varchar(8) NULL COMMENT "", `d_daynuminweek` int(11) NULL COMMENT "", `d_daynuminmonth` int(11) NULL COMMENT "", `d_daynuminyear` int(11) NULL COMMENT "", `d_monthnuminyear` int(11) NULL COMMENT "", `d_weeknuminyear` int(11) NULL COMMENT "", `lo_orderpriotity` varchar(15) NULL COMMENT "", `lo_shippriotity` int(11) NULL COMMENT "", `lo_quantity` bigint(20) NULL COMMENT "", `lo_extendedprice` bigint(20) NULL COMMENT "", `lo_ordtotalprice` bigint(20) NULL COMMENT "", `lo_discount` bigint(20) NULL COMMENT "", `lo_revenue` bigint(20) NULL COMMENT "", `lo_supplycost` bigint(20) NULL COMMENT "", `lo_tax` bigint(20) NULL COMMENT "", `lo_commitdate` int(11) NULL COMMENT "", `lo_shipmode` varchar(10) NULL COMMENT "", INDEX lo_orderkey_idx (`lo_orderkey`) USING BITMAP COMMENT '', INDEX lo_linenumber_idx (`lo_linenumber`) USING BITMAP COMMENT '', INDEX lo_custkey_idx (`lo_custkey`) USING BITMAP COMMENT '', INDEX lo_partkey_idx (`lo_partkey`) USING BITMAP COMMENT '', INDEX lo_suppkey_idx (`lo_suppkey`) USING BITMAP COMMENT '', INDEX lo_orderdate_idx (`lo_orderdate`) USING BITMAP COMMENT '', INDEX c_custkey_idx (`c_custkey`) USING BITMAP COMMENT '', INDEX c_name_idx (`c_name`) USING BITMAP COMMENT '', INDEX c_address_idx (`c_address`) USING BITMAP COMMENT '', INDEX c_city_idx (`c_city`) USING BITMAP COMMENT '', INDEX c_nation_idx (`c_nation`) USING BITMAP COMMENT '', INDEX c_region_idx (`c_region`) USING BITMAP COMMENT '', INDEX c_phone_idx (`c_phone`) USING BITMAP COMMENT '', INDEX c_mktsegment_idx (`c_mktsegment`) USING BITMAP COMMENT '', INDEX p_name_idx (`p_name`) USING BITMAP COMMENT '', INDEX p_mfgr_idx (`p_mfgr`) USING BITMAP COMMENT '', INDEX p_category_idx (`p_category`) USING BITMAP COMMENT '', INDEX p_brand_idx (`p_brand`) USING BITMAP COMMENT '', INDEX p_color_idx (`p_color`) USING BITMAP COMMENT '', INDEX p_type_idx (`p_type`) USING BITMAP COMMENT '', INDEX p_size_idx (`p_size`) USING BITMAP COMMENT '', INDEX p_container_idx (`p_container`) USING BITMAP COMMENT '', INDEX s_name_idx (`s_name`) USING BITMAP COMMENT '', INDEX s_address_idx (`s_address`) USING BITMAP COMMENT '', INDEX s_city_idx (`s_city`) USING BITMAP COMMENT '', INDEX s_nation_idx (`s_nation`) USING BITMAP COMMENT '', INDEX s_region_idx (`s_region`) USING BITMAP COMMENT '', INDEX s_phone_idx (`s_phone`) USING BITMAP COMMENT '', INDEX d_date_idx (`d_date`) USING BITMAP COMMENT '', INDEX d_dayofweek_idx (`d_dayofweek`) USING BITMAP COMMENT '', INDEX d_month_idx (`d_month`) USING BITMAP COMMENT '', INDEX d_year_idx (`d_year`) USING BITMAP COMMENT '', INDEX d_yearmonthnum_idx (`d_yearmonthnum`) USING BITMAP COMMENT '', INDEX d_yearmonth_idx (`d_yearmonth`) USING BITMAP COMMENT '', INDEX d_daynuminweek_idx (`d_daynuminweek`) USING BITMAP COMMENT '', INDEX d_daynuminmonth_idx (`d_daynuminmonth`) USING BITMAP COMMENT '', INDEX d_daynuminyear_idx (`d_daynuminyear`) USING BITMAP COMMENT '', INDEX d_monthnuminyear_idx (`d_monthnuminyear`) USING BITMAP COMMENT '', INDEX d_weeknuminyear_idx (`d_weeknuminyear`) USING BITMAP COMMENT '', INDEX lo_orderpriotity_idx (`lo_orderpriotity`) USING BITMAP COMMENT '', INDEX lo_shippriotity_idx (`lo_shippriotity`) USING BITMAP COMMENT '', INDEX lo_commitdate_idx (`lo_commitdate`) USING BITMAP COMMENT '', INDEX lo_shipmode_idx (`lo_shipmode`) USING BITMAP COMMENT '' ) ENGINE=OLAP DUPLICATE KEY(`lo_orderkey`, `lo_linenumber`, `lo_custkey`, `c_custkey`) COMMENT "OLAP" DISTRIBUTED BY HASH(`lo_orderkey`) BUCKETS 10 PROPERTIES ( "storage_type" = "COLUMN", "replication_num" = "1" ); create 10 tablet. for Q1-1, a got an equal time cost compared to query against table without bitmap index. profile with bitmap:  profile without bitmap: 
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
