{"action":"created","issue":{"url":"https://api.github.com/repos/greenplum-db/gpdb/issues/5987","repository_url":"https://api.github.com/repos/greenplum-db/gpdb","labels_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/5987/labels{/name}","comments_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/5987/comments","events_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/5987/events","html_url":"https://github.com/greenplum-db/gpdb/issues/5987","id":369424473,"node_id":"MDU6SXNzdWUzNjk0MjQ0NzM=","number":5987,"title":"[HTAP] Don't dispatch all values to every segment","user":{"login":"adam8157","id":153160,"node_id":"MDQ6VXNlcjE1MzE2MA==","avatar_url":"https://avatars0.githubusercontent.com/u/153160?v=4","gravatar_id":"","url":"https://api.github.com/users/adam8157","html_url":"https://github.com/adam8157","followers_url":"https://api.github.com/users/adam8157/followers","following_url":"https://api.github.com/users/adam8157/following{/other_user}","gists_url":"https://api.github.com/users/adam8157/gists{/gist_id}","starred_url":"https://api.github.com/users/adam8157/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/adam8157/subscriptions","organizations_url":"https://api.github.com/users/adam8157/orgs","repos_url":"https://api.github.com/users/adam8157/repos","events_url":"https://api.github.com/users/adam8157/events{/privacy}","received_events_url":"https://api.github.com/users/adam8157/received_events","type":"User","site_admin":false},"labels":[{"id":938818744,"node_id":"MDU6TGFiZWw5Mzg4MTg3NDQ=","url":"https://api.github.com/repos/greenplum-db/gpdb/labels/Feature","name":"Feature","color":"dd63ed","default":false},{"id":276736302,"node_id":"MDU6TGFiZWwyNzY3MzYzMDI=","url":"https://api.github.com/repos/greenplum-db/gpdb/labels/help%20wanted","name":"help wanted","color":"159818","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2018-10-12T07:03:35Z","updated_at":"2018-10-15T01:40:31Z","closed_at":null,"author_association":"MEMBER","body":"This is a feature very nice to have for some corner TP cases I guess, comes from a local user, Mr. Xu, who has queries with hundreds even thousands of values to insert but not fit for COPY.\r\n\r\n### Step to reproduce the behavior\r\n1, attach to a segment\r\n2,\r\n```\r\ngpadmin=# set gp_vmem_idle_resource_timeout=120000;\r\nSET\r\ngpadmin=# create table tbl (c1 int) distributed by (c1);\r\nCREATE TABLE\r\ngpadmin=# insert into tbl values (1),(2),(3),(4),(5);\r\n```\r\n3,\r\n```\r\n(gdb) b exec_mpp_query\r\n```\r\n\r\n### Expected behavior\r\nOnly the values which will be hashed to that segment are dispatched\r\n\r\n### Actual behavior\r\n```\r\nBreakpoint 3, exec_mpp_query (query_string=0x2ce3220 \"insert into tbl values (1),(2),(3),(4),(5);\"\r\n```"},"comment":{"url":"https://api.github.com/repos/greenplum-db/gpdb/issues/comments/429683471","html_url":"https://github.com/greenplum-db/gpdb/issues/5987#issuecomment-429683471","issue_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/5987","id":429683471,"node_id":"MDEyOklzc3VlQ29tbWVudDQyOTY4MzQ3MQ==","user":{"login":"adam8157","id":153160,"node_id":"MDQ6VXNlcjE1MzE2MA==","avatar_url":"https://avatars0.githubusercontent.com/u/153160?v=4","gravatar_id":"","url":"https://api.github.com/users/adam8157","html_url":"https://github.com/adam8157","followers_url":"https://api.github.com/users/adam8157/followers","following_url":"https://api.github.com/users/adam8157/following{/other_user}","gists_url":"https://api.github.com/users/adam8157/gists{/gist_id}","starred_url":"https://api.github.com/users/adam8157/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/adam8157/subscriptions","organizations_url":"https://api.github.com/users/adam8157/orgs","repos_url":"https://api.github.com/users/adam8157/repos","events_url":"https://api.github.com/users/adam8157/events{/privacy}","received_events_url":"https://api.github.com/users/adam8157/received_events","type":"User","site_admin":false},"created_at":"2018-10-15T01:40:31Z","updated_at":"2018-10-15T01:40:31Z","author_association":"MEMBER","body":"It's just the QE not utility mode.\r\n\r\nThe user has an ETL tool which generates INSERT statements, with lots of values to insert in every single line."}}
{"actor":{"display_login":"adam8157"}}