Resolutions of aliases and columns names is not done in Drill, on the contrary,
it done by Calcite.
There were some discussions around inconsistencies you mentioning but it's up
to the Calcite community to fix them.
[1] https://issues.apache.org/jira/browse/CALCITE-2799
Kind regards,
Arina
> O
The change in behavior occurred in Drill 1.15 when the group-by alias
support was added [1]. Before this, we could not even group by
an alias in the SELECT list. However, as Arina mentioned, the behavior is
dependent on Calcite which is used by Drill.
Does MySQL or other systems behave the same a
Yes. MySQL 8.0.7 behaves the same as PostgreSQL 9.6:
Query 1 --> returns 2 rows
Query 2 --> returns 1 row
-- Jiang
On Tue, Aug 20, 2019 at 8:09 AM Aman Sinha wrote:
> The change in behavior occurred in Drill 1.15 when the group-by alias
> support was added [1]. Before this, we could not eve