[jira] [Updated] (CALCITE-2236) Druid adapter: Avoid duplication of fields names during Druid query planing

["Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CALCITE-2236?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jesus Camacho Rodriguez updated CALCITE-2236:
---------------------------------------------
    Summary: Druid adapter: Avoid duplication of fields names during Druid query planing  (was: Avoid duplications of fields names during Druid query planing)

> Druid adapter: Avoid duplication of fields names during Druid query planing
> ---------------------------------------------------------------------------
>
>                 Key: CALCITE-2236
>                 URL: https://issues.apache.org/jira/browse/CALCITE-2236
>             Project: Calcite
>          Issue Type: Bug
>          Components: druid
>    Affects Versions: 1.16.0
>            Reporter: slim bouguerra
>            Assignee: slim bouguerra
>            Priority: Major
>             Fix For: 1.17.0
>
>
> This issue occurs if two projects layers use the same fields name, it will lead to a Druid query with a duplicated field names.
> I can not reproduce this in Calcite but it is reproducible in [Hive|https://issues.apache.org/jira/browse/HIVE-19044] (it has to deal on how different layers of project are getting names)
> Here is an example of faulty query where "$f4" is used twice.
> {code}
> {"queryType":"groupBy","dataSource":"druid_tableau.calcs","granularity":"all","dimensions":[{"type":"default","dimension":"key","outputName":"key","outputType":"STRING"}],"limitSpec":{"type":"default"},"aggregations":[{"type":"doubleSum","name":"$f1","fieldName":"num0"},{"type":"filtered","filter":{"type":"not","field":{"type":"selector","dimension":"num0","value":null}},"aggregator":{"type":"count","name":"$f2","fieldName":"num0"}},{"type":"doubleSum","name":"$f3","expression":"(\"num0\" * \"num0\")"},{"type":"doubleSum","name":"$f4","expression":"(\"num0\" * \"num0\")"}],"postAggregations":[{"type":"expression","name":"$f4","expression":"pow(((\"$f4\" - ((\"$f1\" * \"$f1\") / \"$f2\")) / \"$f2\"),0.5)"}],"intervals":["1900-01-01T00:00:00.000Z/3000-01-01T00:00:00.000Z"]}
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)