{"action":"created","issue":{"url":"https://api.github.com/repos/elastic/elasticsearch/issues/31894","repository_url":"https://api.github.com/repos/elastic/elasticsearch","labels_url":"https://api.github.com/repos/elastic/elasticsearch/issues/31894/labels{/name}","comments_url":"https://api.github.com/repos/elastic/elasticsearch/issues/31894/comments","events_url":"https://api.github.com/repos/elastic/elasticsearch/issues/31894/events","html_url":"https://github.com/elastic/elasticsearch/issues/31894","id":339401865,"node_id":"MDU6SXNzdWUzMzk0MDE4NjU=","number":31894,"title":"SQL: Investigate the way text manipulating functions extract the value from the fields","user":{"login":"astefan","id":893749,"node_id":"MDQ6VXNlcjg5Mzc0OQ==","avatar_url":"https://avatars2.githubusercontent.com/u/893749?v=4","gravatar_id":"","url":"https://api.github.com/users/astefan","html_url":"https://github.com/astefan","followers_url":"https://api.github.com/users/astefan/followers","following_url":"https://api.github.com/users/astefan/following{/other_user}","gists_url":"https://api.github.com/users/astefan/gists{/gist_id}","starred_url":"https://api.github.com/users/astefan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/astefan/subscriptions","organizations_url":"https://api.github.com/users/astefan/orgs","repos_url":"https://api.github.com/users/astefan/repos","events_url":"https://api.github.com/users/astefan/events{/privacy}","received_events_url":"https://api.github.com/users/astefan/received_events","type":"User","site_admin":false},"labels":[{"id":912794284,"node_id":"MDU6TGFiZWw5MTI3OTQyODQ=","url":"https://api.github.com/repos/elastic/elasticsearch/labels/:Search/SQL","name":":Search/SQL","color":"0e8a16","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-07-09T10:58:11Z","updated_at":"2018-07-09T10:58:13Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"At the moment, if a `text` field is passed to a text manipulating function, we try to see if the fields has a `keyword` subfield and if it does, we use that one and extract the value from doc_values. Should we look into see if the fields has the source stored and extract that instead? (and pay the performance penalty of retrieving the source and extract it)"},"comment":{"url":"https://api.github.com/repos/elastic/elasticsearch/issues/comments/403440677","html_url":"https://github.com/elastic/elasticsearch/issues/31894#issuecomment-403440677","issue_url":"https://api.github.com/repos/elastic/elasticsearch/issues/31894","id":403440677,"node_id":"MDEyOklzc3VlQ29tbWVudDQwMzQ0MDY3Nw==","user":{"login":"elasticmachine","id":15837671,"node_id":"MDQ6VXNlcjE1ODM3Njcx","avatar_url":"https://avatars3.githubusercontent.com/u/15837671?v=4","gravatar_id":"","url":"https://api.github.com/users/elasticmachine","html_url":"https://github.com/elasticmachine","followers_url":"https://api.github.com/users/elasticmachine/followers","following_url":"https://api.github.com/users/elasticmachine/following{/other_user}","gists_url":"https://api.github.com/users/elasticmachine/gists{/gist_id}","starred_url":"https://api.github.com/users/elasticmachine/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/elasticmachine/subscriptions","organizations_url":"https://api.github.com/users/elasticmachine/orgs","repos_url":"https://api.github.com/users/elasticmachine/repos","events_url":"https://api.github.com/users/elasticmachine/events{/privacy}","received_events_url":"https://api.github.com/users/elasticmachine/received_events","type":"User","site_admin":false},"created_at":"2018-07-09T10:58:13Z","updated_at":"2018-07-09T10:58:13Z","author_association":"NONE","body":"Pinging @elastic/es-search-aggs"}}
{"actor":{"display_login":"elasticmachine"}}