[jira] [Updated] (CALCITE-3054) ElasticSearch adapter. Avoid scripting for simple projections

["Andrei Sereda (JIRA)" <ji...@apache.org>]

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

Andrei Sereda updated CALCITE-3054:
-----------------------------------
    Description: 
No [scripting|https://www.elastic.co/guide/en/elasticsearch/reference/current/modules-scripting.html] should be used for simple field projection(s).

In some cases elastic adapter uses {{script}} instead of {{_source}} for simple field projections.

{code:sql}
select  _MAP['a'], _MAP['b.a'] from elastic
{code}

  was:
No [scripting|https://www.elastic.co/guide/en/elasticsearch/reference/current/modules-scripting.html] should be used for simple field projection(s).

In some cases elastic adapter uses {{script_fields}} instead of {{_source}} for simple field projections.

{code:sql}
select  _MAP['a'], _MAP['b.a'] from elastic
{code}


> ElasticSearch adapter. Avoid scripting for simple projections
> -------------------------------------------------------------
>
>                 Key: CALCITE-3054
>                 URL: https://issues.apache.org/jira/browse/CALCITE-3054
>             Project: Calcite
>          Issue Type: Bug
>          Components: elasticsearch-adapter
>    Affects Versions: 1.19.0
>            Reporter: Andrei Sereda
>            Assignee: Andrei Sereda
>            Priority: Major
>
> No [scripting|https://www.elastic.co/guide/en/elasticsearch/reference/current/modules-scripting.html] should be used for simple field projection(s).
> In some cases elastic adapter uses {{script}} instead of {{_source}} for simple field projections.
> {code:sql}
> select  _MAP['a'], _MAP['b.a'] from elastic
> {code}



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