{"action":"created","issue":{"url":"https://api.github.com/repos/prestodb/presto/issues/10999","repository_url":"https://api.github.com/repos/prestodb/presto","labels_url":"https://api.github.com/repos/prestodb/presto/issues/10999/labels{/name}","comments_url":"https://api.github.com/repos/prestodb/presto/issues/10999/comments","events_url":"https://api.github.com/repos/prestodb/presto/issues/10999/events","html_url":"https://github.com/prestodb/presto/pull/10999","id":339297306,"node_id":"MDExOlB1bGxSZXF1ZXN0MTk5OTg2MDg1","number":10999,"title":"add elasticsearch connector","user":{"login":"harbby","id":19815755,"node_id":"MDQ6VXNlcjE5ODE1NzU1","avatar_url":"https://avatars0.githubusercontent.com/u/19815755?v=4","gravatar_id":"","url":"https://api.github.com/users/harbby","html_url":"https://github.com/harbby","followers_url":"https://api.github.com/users/harbby/followers","following_url":"https://api.github.com/users/harbby/following{/other_user}","gists_url":"https://api.github.com/users/harbby/gists{/gist_id}","starred_url":"https://api.github.com/users/harbby/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/harbby/subscriptions","organizations_url":"https://api.github.com/users/harbby/orgs","repos_url":"https://api.github.com/users/harbby/repos","events_url":"https://api.github.com/users/harbby/events{/privacy}","received_events_url":"https://api.github.com/users/harbby/received_events","type":"User","site_admin":false},"labels":[{"id":196992743,"node_id":"MDU6TGFiZWwxOTY5OTI3NDM=","url":"https://api.github.com/repos/prestodb/presto/labels/CLA%20Signed","name":"CLA Signed","color":"ededed","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-07-09T03:58:28Z","updated_at":"2018-07-10T01:42:04Z","closed_at":null,"author_association":"NONE","pull_request":{"url":"https://api.github.com/repos/prestodb/presto/pulls/10999","html_url":"https://github.com/prestodb/presto/pull/10999","diff_url":"https://github.com/prestodb/presto/pull/10999.diff","patch_url":"https://github.com/prestodb/presto/pull/10999.patch"},"body":"# presto-elasticsearch\r\npresto connector for elasticsearch\r\n\r\n## install\r\nes 2.x\r\n```\r\nconnector.name=elasticsearch\r\n\r\nelasticsearch.cluster.name=ideal-bigdata\r\nelasticsearch.transport.hosts=localhost:9300\r\n```\r\n\r\nes 5.x\r\n```\r\nconnector.name=elasticsearch5\r\n\r\nelasticsearch.cluster.name=ideal-bigdata\r\nelasticsearch.transport.hosts=localhost:9300\r\n```\r\n\r\nes 6.x\r\n```\r\nconnector.name=elasticsearch6\r\n\r\nelasticsearch.cluster.name=ideal-bigdata\r\nelasticsearch.transport.hosts=localhost:9300\r\n```\r\nlook: Cannot be used simultaneously\r\n\r\n## SQL Usage\r\n\r\n```SELECT * FROM test1 WHERE age >30 AND city = 'world'```\r\n\r\n```desc test1```\r\n\r\n\r\n## Beyond SQL\r\n\r\n* Search\r\n\r\nselect * from test1 where  _name = match_query('Lucy')\r\n\r\n* Search match_phrase\r\n\r\nselect * from test1 where  _name = match_phrase('Lucy')\r\n\r\n* Strong pushDown\r\n\r\nselect * from test1 where _dsl = '{\"query\":{\"match\":{\"city\":{\"query\":\"world\"}}}}' and _name = match_query('Lucy')\r\n\r\n### pushDown\r\n+ _ field is an extension field\r\nUse the _ field and it will be pushed down to es for search\r\n\r\n+ -dsl field will be fully pushed down for custom dsl\r\n\r\n## session parameter\r\n\r\n| Name                                    | Default        | Type    | Description\r\n| -------------------------------------   | -------------- | ------- | ----------------------------------------------------------------------------------\r\n| es6.optimize_split_shards_enabled       | true           | boolean | Set to true to split non-indexed queries by shards splits. Should generally be\r\n| es6.scroll_search_batch_size            | 100            | integer | max of 100 hits will be returned for each scroll. Default 100                 \r\n| es6.scroll_search_timeout               | 60000          | bigint  | If set, will enable scrolling of the search request for the specified timeout\r\n\r\n\r\ndemo:```set session es6.scroll_search_batch_size=150```\r\n\r\n## Does not support features\r\n+ insert into(Already supported)\r\n+ create table as (Already supported)\r\n+ create table (Already supported)\r\n+ drop table(Already supported)\r\n+ update\r\n+ delete\r\n"},"comment":{"url":"https://api.github.com/repos/prestodb/presto/issues/comments/403672025","html_url":"https://github.com/prestodb/presto/pull/10999#issuecomment-403672025","issue_url":"https://api.github.com/repos/prestodb/presto/issues/10999","id":403672025,"node_id":"MDEyOklzc3VlQ29tbWVudDQwMzY3MjAyNQ==","user":{"login":"harbby","id":19815755,"node_id":"MDQ6VXNlcjE5ODE1NzU1","avatar_url":"https://avatars0.githubusercontent.com/u/19815755?v=4","gravatar_id":"","url":"https://api.github.com/users/harbby","html_url":"https://github.com/harbby","followers_url":"https://api.github.com/users/harbby/followers","following_url":"https://api.github.com/users/harbby/following{/other_user}","gists_url":"https://api.github.com/users/harbby/gists{/gist_id}","starred_url":"https://api.github.com/users/harbby/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/harbby/subscriptions","organizations_url":"https://api.github.com/users/harbby/orgs","repos_url":"https://api.github.com/users/harbby/repos","events_url":"https://api.github.com/users/harbby/events{/privacy}","received_events_url":"https://api.github.com/users/harbby/received_events","type":"User","site_admin":false},"created_at":"2018-07-10T01:42:04Z","updated_at":"2018-07-10T01:42:04Z","author_association":"NONE","body":"@nezihyigitbasi  \r\nThank you very much for your attention, I will add a detailed instructions for use.\r\nI think this program is very interesting.\r\nI implemented a very cool predicate pushdown method that can very well leverage the search capabilities of elasticsearch.\r\nThis method can also be used in the mogodb connector.\r\nIn addition, she also supports the latest elasticsearch5 and elasticsearch6\r\n"}}
{"actor":{"display_login":"harbby"}}