{"action":"created","issue":{"url":"https://api.github.com/repos/apache/phoenix/issues/606","repository_url":"https://api.github.com/repos/apache/phoenix","labels_url":"https://api.github.com/repos/apache/phoenix/issues/606/labels{/name}","comments_url":"https://api.github.com/repos/apache/phoenix/issues/606/comments","events_url":"https://api.github.com/repos/apache/phoenix/issues/606/events","html_url":"https://github.com/apache/phoenix/pull/606","id":511654384,"node_id":"MDExOlB1bGxSZXF1ZXN0MzMxODEyNzE3","number":606,"title":"PHOENIX-5543: Implement SHOW TABLES/SCHEMAS sql commands","user":{"login":"bharathv","id":248754,"node_id":"MDQ6VXNlcjI0ODc1NA==","avatar_url":"https://avatars2.githubusercontent.com/u/248754?v=4","gravatar_id":"","url":"https://api.github.com/users/bharathv","html_url":"https://github.com/bharathv","followers_url":"https://api.github.com/users/bharathv/followers","following_url":"https://api.github.com/users/bharathv/following{/other_user}","gists_url":"https://api.github.com/users/bharathv/gists{/gist_id}","starred_url":"https://api.github.com/users/bharathv/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bharathv/subscriptions","organizations_url":"https://api.github.com/users/bharathv/orgs","repos_url":"https://api.github.com/users/bharathv/repos","events_url":"https://api.github.com/users/bharathv/events{/privacy}","received_events_url":"https://api.github.com/users/bharathv/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2019-10-24T01:40:32Z","updated_at":"2019-11-01T22:31:23Z","closed_at":null,"author_association":"NONE","pull_request":{"url":"https://api.github.com/repos/apache/phoenix/pulls/606","html_url":"https://github.com/apache/phoenix/pull/606","diff_url":"https://github.com/apache/phoenix/pull/606.diff","patch_url":"https://github.com/apache/phoenix/pull/606.patch"},"body":"This patch adds new SQL grammar like following\r\n\r\n- SHOW SCHEMAS [like '<pattern>']\r\n- SHOW TABLES [IN <schema>] [like '<pattern']\r\n\r\nExample invocations:\r\n\r\n- show schemas\r\n- show scemas like 'SYS%'\r\n- show tables\r\n- show tables in SYSTEM\r\n- show tables in SYSTEM like 'CAT%'\r\n\r\nThe current way of fetching this information is by using\r\n!tables and !schemas via sqlline JDBC support but that is\r\nnot flexible enough for the end users to add more fitlers.\r\nThis approach is more inline with what other databases do.\r\n\r\nAdded test coverage in parser tests and core e2e tests."},"comment":{"url":"https://api.github.com/repos/apache/phoenix/issues/comments/548972349","html_url":"https://github.com/apache/phoenix/pull/606#issuecomment-548972349","issue_url":"https://api.github.com/repos/apache/phoenix/issues/606","id":548972349,"node_id":"MDEyOklzc3VlQ29tbWVudDU0ODk3MjM0OQ==","user":{"login":"yanxinyi","id":11622374,"node_id":"MDQ6VXNlcjExNjIyMzc0","avatar_url":"https://avatars2.githubusercontent.com/u/11622374?v=4","gravatar_id":"","url":"https://api.github.com/users/yanxinyi","html_url":"https://github.com/yanxinyi","followers_url":"https://api.github.com/users/yanxinyi/followers","following_url":"https://api.github.com/users/yanxinyi/following{/other_user}","gists_url":"https://api.github.com/users/yanxinyi/gists{/gist_id}","starred_url":"https://api.github.com/users/yanxinyi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yanxinyi/subscriptions","organizations_url":"https://api.github.com/users/yanxinyi/orgs","repos_url":"https://api.github.com/users/yanxinyi/repos","events_url":"https://api.github.com/users/yanxinyi/events{/privacy}","received_events_url":"https://api.github.com/users/yanxinyi/received_events","type":"User","site_admin":false},"created_at":"2019-11-01T22:31:23Z","updated_at":"2019-11-01T22:31:23Z","author_association":"CONTRIBUTOR","body":"+1 from my side."}}
{"actor":{"display_login":"yanxinyi"}}