AST is too big. Maximum: 500000 處理
當操作CLICKHOUSE時,出現以下錯誤。
<Error> void DB::BackgroundProcessingPool::threadFunction(): Code: 168, e.displayText() = DB::Exception: AST is too big. Maximum: 500000: (after expansion of aliases), e.what() = DB::Exception, Stack trace:
需要設定max_ast_elements及max_expanded_ast_elements
max_ast_elements:
Maximum number of elements in a query syntactic tree. If exceeded, an exception is thrown. In the same way as the previous setting, it is checked only after parsing the query. By default, 10,000.
查詢語法樹中的最大元素數。 如果超出,則丟擲異常。 與先前設定相同,僅在解析查詢後進行檢查。 預設情況下,10,000。
max_expanded_ast_elements
在遞迴擴充套件別名後,對AST大小新增了max_expanded_ast_elements限制。(新加的一個屬性)
再user.xml 新增
<max_ast_elements>10000000</max_ast_elements>
<max_expanded_ast_elements>10000000</max_expanded_ast_elements>
就可以解決這個問題。
相關文章
- Too many open files in system處理
- Too many open files報錯處理
- ORA-00059: maximum number of DB_FILES exceeded 處理
- Index column size too large. The maximum column size is 767 bytesIndex
- 轉:AIX中The largest dump device is too small的處理AIdev
- 【故障處理】-0403-027 The parameter list is too long
- mysql specified key was too long與Index column size too large. The maximum column size is 767 bytes.MySqlIndex
- Index column size too large. The maximum column size is 767 bytes.Index
- ORA-00494 enqueue [CF] held for too long故障分析處理ENQ
- ES報錯Result window is too large問題處理薦
- MySQL問題處理——1040錯誤Too many connectionsMySql
- CF 375B Maximum Submatrix 2[預處理 計數排序]排序
- 1709 - Index column size too large. The maximum column size is 767 bytes.Index
- 【效能優化】處理ORA-01555:Snapshot Too Old優化
- [Err] 1709 - Index column size too large. The maximum column size is 767 bytes.Index
- MySQL建立表失敗:Index column size too large. The maximum column size is 767 bytesMySqlIndex
- Android Studio錯誤處理Plugin is too old, please update to a more recent versionAndroidPlugin
- ORA-00059: maximum number of DB_FILES exceeded 情況分析及實驗處理
- MySQL 5.7 到 5.6,出現 Index column size too large. The maximum column size is 767 bytesMySqlIndex
- MySQL資料庫index column size too large. the maximum column size is 767 bytes問題解決MySql資料庫Index
- AST in JSASTJS
- 【問題處理】diagcollection.pl採集指令碼執行出錯——Argument list too longGC指令碼
- mysql5.7 資料匯入5.6 Index column size too large. The maximum column size is 767 bytes.MySqlIndex
- AST 原理分析AST
- babel 與 astBabelAST
- 多對一處理 和一對多處理的處理
- AST抽象語法樹AST抽象語法樹
- 從babel講到ASTBabelAST
- JSP 異常處理如何處理?JS
- windows批處理之一:字串處理Windows字串
- 影像處理或其他多媒體處理中的值溢位處理
- oracle 9i dataguard 由MAXIMUM PERFORMANCE模式變為MAXIMUM PROTECTIONOracleORM模式
- PHP錯誤處理和異常處理PHP
- 處理百萬級以上的資料處理
- 帶你揭開神秘的javascript AST面紗之AST 基礎與功能JavaScriptAST
- Swift AST的一點研究SwiftAST
- Babylon-AST初探-實戰AST
- 模板處理