We encountered a series of problems using dremio to query ES, we need to modify the calcite-core-1.12.0 code to solve these problems, but now we found that the source code of calcite-core-1.12.0 modified by dremio team is not open source Can you send us a source alone?
Question one: SELECT count (distinct device_id) It is recommended to use the (ES, MySQL, MongoDB) API rather than in the dremio executor
In fact, the SQL query only tens of thousands of data, but dremio implementation plan is to scan these hundreds of millions of tables of data, we need to fix a lot of similar problems and custom development
The enterprise edition comes with some additional features and dedicated support channels. Don’t hesitate to contact us by visiting https://www.dremio.com/lp/contact/ if you want more details about it.