[Question]: elasticsearch.BadRequestError: BadRequestError(400, 'verification_exception'

[dongyuya]

I used the default configuration to parse an excel file as a knowledge base. When communicating with a conversation assistant using this knowledge base, the following error message will appear.

`2025-02-12 15:12:19,705 INFO 20 HTTP Request: POST http://ollama:11434/api/chat "HTTP/1.1 200 OK" 2025-02-12 15:12:19,738 INFO 20 POST http://es01:9200/_sql?format=json [status:400 duration:0.031s] 2025-02-12 15:12:19,739 ERROR 20 ESConnection.sql got exception

Traceback (most recent call last): File "/ragflow/rag/utils/es_conn.py", line 538, in sql res = self.es.sql.query(body={"query": sql, "fetch_size": fetch_size}, format=format, File "/ragflow/.venv/lib/python3.10/site-packages/elasticsearch/_sync/client/utils.py", line 446, in wrapped return api(*args, **kwargs) File "/ragflow/.venv/lib/python3.10/site-packages/elasticsearch/_sync/client/sql.py", line 330, in query return self.perform_request( # type: ignore[return-value] File "/ragflow/.venv/lib/python3.10/site-packages/elasticsearch/_sync/client/_base.py", line 389, in perform_request return self._client.perform_request( File "/ragflow/.venv/lib/python3.10/site-packages/elasticsearch/_sync/client/_base.py", line 320, in perform_request raise HTTP_EXCEPTIONS.get(meta.status, ApiError)( elasticsearch.BadRequestError: BadRequestError(400, 'verification_exception', 'Found 1 problem\nline 1:8: Cannot use non-grouped columns [doc_id, docnm_kwd], expected []') `

[KevinHuSh]

Please use General to parse Execl.

[dongyuya]

Please use General to parse Execl.

Thanks for your reply! However, after using General to parse excel, the following error message will appear in the dialogue.

Traceback (most recent call last): File "/ragflow/rag/utils/es_conn.py", line 538, in sql res = self.es.sql.query(body={"query": sql, "fetch_size": fetch_size}, format=format, File "/ragflow/.venv/lib/python3.10/site-packages/elasticsearch/_sync/client/utils.py", line 446, in wrapped return api(*args, **kwargs) File "/ragflow/.venv/lib/python3.10/site-packages/elasticsearch/_sync/client/sql.py", line 330, in query return self.perform_request( # type: ignore[return-value] File "/ragflow/.venv/lib/python3.10/site-packages/elasticsearch/_sync/client/_base.py", line 389, in perform_request return self._client.perform_request( File "/ragflow/.venv/lib/python3.10/site-packages/elasticsearch/_sync/client/_base.py", line 320, in perform_request raise HTTP_EXCEPTIONS.get(meta.status, ApiError)( elasticsearch.BadRequestError: BadRequestError(400, 'parsing_exception', "line 1:262: mismatched input '创' expecting {'(', 'ANALYZE', 'ANALYZED', 'CASE', 'CAST', 'CATALOGS', 'COLUMNS', 'CONVERT', 'CURRENT_DATE', 'CURRENT_TIME', 'CURRENT_TIMESTAMP', 'DAY', 'DEBUG', 'EXECUTABLE', 'EXISTS', 'EXPLAIN', 'EXTRACT', 'FALSE', 'FIRST', 'FORMAT', 'FULL', 'FUNCTIONS', 'GRAPHVIZ', 'HOUR', 'INTERVAL', 'LAST', 'LEFT', 'LIMIT', 'MAPPED', 'MATCH', 'MINUTE', 'MONTH', 'NOT', 'NULL', 'OPTIMIZED', 'PARSED', 'PHYSICAL', 'PIVOT', 'PLAN', 'RIGHT', 'RLIKE', 'QUERY', 'SCHEMAS', 'SECOND', 'SHOW', 'SYS', 'TABLES', 'TEXT', 'TRUE', 'TOP', 'TYPE', 'TYPES', 'VERIFY', 'YEAR', FUNCTION_ESC, DATE_ESC, TIME_ESC, TIMESTAMP_ESC, GUID_ESC, '+', '-', '*', '?', STRING, INTEGER_VALUE, DECIMAL_VALUE, IDENTIFIER, DIGIT_IDENTIFIER, QUOTED_IDENTIFIER, BACKQUOTED_IDENTIFIER}")

[KevinHuSh]

Create a new KB using General as the chunking method.

[1823616178]

I use CSV data, which can only be imported in TABLE mode, and this error is also reported. What should I do

[KevinHuSh]

CSV has already supported by General.

[1823616178]

CSV has already supported by General.General 已经支持 CSV。

Thank you very much