Polignao opened a new issue #13321: URL: https://github.com/apache/superset/issues/13321
As the self explanatory title says, I'm getting this error when trying to use elasticsearch as database for a filterbox. **Superset versions I tested this on: 0.990-dev, 1.0.1** Superset is installed using Docker Desktop on Windows 10 19042.804 _https://hub.docker.com/r/amancevice/superset/ **for 1.0.1** https://hub.docker.com/r/apache/incubator-superset for **0.990-dev**_ Elasticsearch is in Docker too, following guide here: _https://www.elastic.co/guide/en/elasticsearch/reference/current/docker.html_ _WARNING:elasticsearch:POST http://host.docker.internal:9200/_sql/ [status:400 request:0.015s] DEBUG:elasticsearch:> {"query":"SELECT \"street.keyword\" AS \"street.keyword\"\nFROM \"italy-addresses\"\nWHERE ((lower(city.keyword) like '%roma%'))\nGROUP BY \"street.keyword\"\nLIMIT 1000"} DEBUG:elasticsearch:< {"error":{"root_cause":[{"type":"verification_exception","reason":"Found 1 problem\nline 3:9: Unknown function [lower], did you mean [POWER]?"}],"type":"verification_exception","reason":"Found 1 problem\nline 3:9: Unknown function [lower], did you mean [POWER]?"},"status":400}_ I don't know if it's only me getting this or if I'm just missing something. In the Elasticsearch's official documentation it is possible to find the equivalent for the function lower(<string>) as LCASE: _https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-functions-string.html#sql-functions-string-lcase_ Steps to reproduce: - Create a filterbox from an elasticsearch dataset - Create a dashboard with the filterbox in it - Type something in the filterbox and wait for error to occur It seems noone is getting this error so I think I might be doing something wrong. Since I don't know who generates the query with the lower() function I explored the code that manipulates SQL in Superset, Elasticsearch db engine and elasticsearch-dbapi, but had no luck. Any advice is welcome! Thanks! ---------------------------------------------------------------- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
