mujohiddin commented on issue #28644: URL: https://github.com/apache/superset/issues/28644#issuecomment-2126256653
> “ROW_LIMIT” sozlamasining to‘g‘ri qo‘llanilmasligi bilan bog‘liq muammo bir necha omillarga, jumladan, Superset kod bazasidagi so‘nggi o‘zgarishlar, backend konfiguratsiyalari yoki frontend boshqaruv mantig‘iga bog‘liq bo‘lishi mumkin. Ushbu muammoni hal qilishda sizga yordam beradigan ba'zi qadamlar va fikrlar: > > ### Backend konfiguratsiyalari > Backend konfiguratsiyasi `config.py`sizning “ROW_LIMIT” sozlamangizni bekor qilmasligiga ishonch hosil qiling. Tekshirish uchun asosiy sozlamalar: > > * **SQL_MAX_ROW** : Har qanday analitik ma'lumotlar bazasi so'rovi uchun qaytarilgan satrlarning maksimal sonini belgilaydi. > * **DISPLAY_MAX_ROW** : SQL Lab UI da ko'rsatiladigan qatorlar sonini cheklaydi. > * **DEFAULT_SQLLAB_LIMIT** : SQL Lab soʻrovlari uchun standart qator chegarasi. > * **SUPERSET_META_DB_LIMIT** : Xususiyat bayrog'i `ENABLE_SUPERSET_META_DB`yoqilganda cheklash. > * **SQLLAB_CTAS_NO_LIMIT** : SQL Lab-ga CTAS funksiyasidan foydalanganda qator cheklovisiz so'rovlarni bajarishga ruxsat beradi. > > ### Frontend boshqaruv mantiqi > Siz oʻrnatgan qiymat (20.000.000) ruxsat etilgan parametrlar ichida ekanligiga yoki erkin shakldagi kiritish sifatida toʻgʻri tasdiqlanganligiga ishonch hosil qiling. Tekshirish `row_limit`maxsus variantlar va tekshirish mantig'i bilan belgilanadi. > > ### Superset kod bazasidagi so'nggi o'zgarishlar > "ROW_LIMIT" sozlamasiga ta'sir qilishi mumkin bo'lgan Superset kod bazasida yaqinda o'zgarishlar bo'ldi. Ta'kidlash joizki, [№27700](https://github.com/apache/superset/pull/27700) va [№26151](https://github.com/apache/superset/pull/26151) so'rovlari qator chegaralari bilan bog'liq muammolarni hal qiladi. > > ### Jurnal va disk raskadrovka > Supersetda “ROW_LIMIT” sozlamasi qanday qoʻllanilishi yoki soʻrovni bajarish vaqtida eʼtiborga olinmasligini kuzatishga yordam beradigan jurnalga yozish mexanizmlari mavjud. Kalit ro'yxatga olish bayonotlari faylda mavjud `superset/commands/sql_lab/execute.py`. > > ### `row_limit`Nazoratning ko'rinishi > Boshqaruv yoqilmaganligiga ishonch hosil qiling `server_pagination`, chunki bu "ROW_LIMIT" sozlamasining e'tiborsiz qolishiga olib kelishi mumkin. > > Muammo davom etsa, "ROW_LIMIT" sozlamasining ishlashiga ta'sir qilishi mumkin bo'lgan Superset kod bazasidagi so'nggi o'zgarishlarni ko'rib chiqing. > > Bu masala chuqurroq ko'rib chiqishni talab qiladi shekilli,@rusackasIltimos, o'z tajribangizni taqdim eta olasizmi? > > #### Tafsilotlar > **Sources** > > * [Limit issue](https://github.com/apache/superset/issues/20132) > * [superset/migrations/versions/2019-06-04_10-12_d7c1a0d6f2da_remove_limit_used_from_query_model.py](https://github.com/apache/superset/blob/master/superset/migrations/versions/2019-06-04_10-12_d7c1a0d6f2da_remove_limit_used_from_query_model.py) > * [superset-frontend/plugins/plugin-chart-handlebars/src/plugin/controls/limits.ts](https://github.com/apache/superset/blob/master/superset-frontend/plugins/plugin-chart-handlebars/src/plugin/controls/limits.ts) > * [superset-frontend/src/explore/controls.jsx](https://github.com/apache/superset/blob/master/superset-frontend/src/explore/controls.jsx) > * [superset/config.py](https://github.com/apache/superset/blob/master/superset/config.py) > * [docker/pythonpath_dev/superset_config.py](https://github.com/apache/superset/blob/master/docker/pythonpath_dev/superset_config.py) > * [superset/sql_lab.py](https://github.com/apache/superset/blob/master/superset/sql_lab.py) > * [superset/commands/sql_lab/execute.py](https://github.com/apache/superset/blob/master/superset/commands/sql_lab/execute.py) > * [CHANGELOG/3.1.0.md](https://github.com/apache/superset/blob/master/CHANGELOG/3.1.0.md) > * [CHANGELOG/4.0.1.md](https://github.com/apache/superset/blob/master/CHANGELOG/4.0.1.md) > * [superset-frontend/packages/superset-ui-chart-controls/src/shared-controls/sharedControls.tsx](https://github.com/apache/superset/blob/master/superset-frontend/packages/superset-ui-chart-controls/src/shared-controls/sharedControls.tsx) > * [superset-frontend/src/SqlLab/components/ResultSet/index.tsx](https://github.com/apache/superset/blob/master/superset-frontend/src/SqlLab/components/ResultSet/index.tsx) > > > **About Dosu** This response is meant to be useful and save you time. It is **not meant to be a precise solution**, but rather a starting point for your own research. > > Help me be more useful! Please leave a 👍 if this is helpful and 👎 if it is irrelevant. > > _Suhbatni davom ettirish uchun zikr qiling@dosu._ I have run my superset project version for the first time since September October last year, I tried the above solutions and it didn't work -- 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. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
