Unanimad commented on issue #16723: URL: https://github.com/apache/superset/issues/16723#issuecomment-1129834025
hello everyone! I'm currently work in a project needing to connect the SuperSet and OpenSearch. I forked the [elasticsearch-dbapi](https://github.com/preset-io/elasticsearch-dbapi) project and changed the opendistro for [opensearch dependencies](https://opensearch.org/docs/latest/clients/python/). It's worked well, enabled to connect, create the database and datasets, everything was perfect until the SQL aggregations for the Charts. When the SuperSet parse a SQL statement with aggretation it's put an alias using same aggregation function name and, in this point, the OpenSearch don't recognize this alias. > SELECT count(codigo) AS count(codigo) FROM cnes_estabelecimento_saude LIMIT 50000; It's worked if only has the colunm name as alias or into quotation marks. So, I'm trying to figure out how don't create the alias or to not use the aggregation function in the alias. @stockholmux please, could you check if that make sense? -- 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]
