search

running-elephant / datart

Datart is a next generation Data Visualization Open Platform
https://running-elephant.github.io/datart-docs/
Apache License 2.0
1.88k stars 571 forks source link

doris数据源，创建视图，limit不生效 #1870

Open luyaozhi opened 2 years ago

luyaozhi commented 2 years ago

Datart Version 1.0.0-rc.1 Release

Describe the bug doris数据源，创建视图，limit不生效，并且页面一直在执行状态，后端接口已经报错，页面卡死 image

最终执行的sql

SELECT test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.brand_format AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","brand_format"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.brand_id AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","brand_id"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.bill_cancel_food_cnt AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","bill_cancel_food_cnt"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.shop_cuisineid_2 AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","shop_cuisineid_2"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.report_date AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","report_date"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.bill_food_bill_cnt AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","bill_food_bill_cnt"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.bill_send_food_amt AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","bill_send_food_amt"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.bill_discount_food_amt AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","bill_discount_food_amt"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.bill_food_cost_amt AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","bill_food_cost_amt"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.bill_food_cnt AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","bill_food_cnt"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.quter_id AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","quter_id"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.city_id AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","city_id"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.group_id AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","group_id"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.province_id AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","province_id"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.bill_food_profit_amt AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","bill_food_profit_amt"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.shop_name AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","shop_name"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.shop_cuisinename_1 AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","shop_cuisinename_1"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.year_id AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","year_id"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.is_recommend AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","is_recommend"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.bill_food_person_cnt AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","bill_food_person_cnt"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.is_sfdetail AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","is_sfdetail"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.is_specialty AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","is_specialty"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.weekofyear_id AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","weekofyear_id"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.city_level AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","city_level"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.shop_opening_hours AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","shop_opening_hours"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.shop_business_model_name AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","shop_business_model_name"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.shop_operation_model AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","shop_operation_model"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.business_area AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","business_area"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.bill_real_food_cnt AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","bill_real_food_cnt"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.unit_key AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","unit_key"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.food_key AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","food_key"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.is_tempfood AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","is_tempfood"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.bill_real_food_amt AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","bill_real_food_amt"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.shop_operation_model_name AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","shop_operation_model_name"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.is_batching AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","is_batching"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.hot_tag AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","hot_tag"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.food_name AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","food_name"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.bill_cancel_food_amt AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","bill_cancel_food_amt"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.area_name AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","area_name"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.shop_cuisineid_1 AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","shop_cuisineid_1"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.group_type AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","group_type"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.shop_attribute_name AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","shop_attribute_name"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.bill_send_food_cnt AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","bill_send_food_cnt"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.org_name AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","org_name"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.brand_cuisine AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","brand_cuisine"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.foodcategory_name AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","foodcategory_name"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.mealperiod_name AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","mealperiod_name"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.foodcategory_key AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","foodcategory_key"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.is_new AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","is_new"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.month_id AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","month_id"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.is_setfood AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","is_setfood"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.shop_source AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","shop_source"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.food_code AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","food_code"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.pt AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","pt"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.city_name AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","city_name"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.shop_business_model AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","shop_business_model"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.hour_id AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","hour_id"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.shop_cuisinename_2 AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","shop_cuisinename_2"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.shop_id AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","shop_id"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.week_start_id AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","week_start_id"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.brand_name AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","brand_name"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.week_end_id AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","week_end_id"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.unit AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","unit"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.imge_path AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","imge_path"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.business_district AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","business_district"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.province_name AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","province_name"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.order_subtype AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","order_subtype"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.is_setmealfood AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","is_setmealfood"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.org_id AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","org_id"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.shop_attribute_value AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","shop_attribute_value"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.bill_food_amt AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","bill_food_amt"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.is_customer AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","is_customer"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.group_name AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","group_name"], test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day.is_test_shop AS ["test_db","aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day","is_test_shop"] FROM test_db.aggr_bill_shop_iscustomer_ordersubtype_mealperiod_hour_food_day ORDER BY NULL

Environmental details: (optional, depending on where the bug occurs)

suchasplus commented 2 years ago

2.3.0是starrocks吧

luyaozhi commented 2 years ago

2.3.0是starrocks吧

是的