[GitHub] [superset] Unanimad commented on issue #16723: Support AWS OpenSearch / Elasticsearch

[GitBox <gi...@apache.org>]

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: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org