{"action":"created","issue":{"url":"https://api.github.com/repos/confluentinc/ksql/issues/1265","repository_url":"https://api.github.com/repos/confluentinc/ksql","labels_url":"https://api.github.com/repos/confluentinc/ksql/issues/1265/labels{/name}","comments_url":"https://api.github.com/repos/confluentinc/ksql/issues/1265/comments","events_url":"https://api.github.com/repos/confluentinc/ksql/issues/1265/events","html_url":"https://github.com/confluentinc/ksql/issues/1265","id":319717467,"number":1265,"title":"When KSQL service restarts an existing JOIN stream does not work as expected","user":{"login":"robertrbruno","id":34684082,"avatar_url":"https://avatars2.githubusercontent.com/u/34684082?v=4","gravatar_id":"","url":"https://api.github.com/users/robertrbruno","html_url":"https://github.com/robertrbruno","followers_url":"https://api.github.com/users/robertrbruno/followers","following_url":"https://api.github.com/users/robertrbruno/following{/other_user}","gists_url":"https://api.github.com/users/robertrbruno/gists{/gist_id}","starred_url":"https://api.github.com/users/robertrbruno/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/robertrbruno/subscriptions","organizations_url":"https://api.github.com/users/robertrbruno/orgs","repos_url":"https://api.github.com/users/robertrbruno/repos","events_url":"https://api.github.com/users/robertrbruno/events{/privacy}","received_events_url":"https://api.github.com/users/robertrbruno/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2018-05-02T21:24:08Z","updated_at":"2018-05-03T20:52:27Z","closed_at":null,"author_association":"NONE","body":"When KSQL service restarts existing JOIN streams are resumed, but seems like it resumes the left stream and the right table of the JOIN with existing group offsets.\r\n\r\nThis makes sense for the stream but not the table at least in my use case.  It seems like the table should reset to the beginning on restart.  If I manually delete the group offsets for the JOIN stream all works as expected.\r\n\r\nPerhaps there could be parameters in the JOIN that let you change the offsets of reset to earliest (for the table), latest (for the stream) and if left blank it would just use the existing offsets?"},"comment":{"url":"https://api.github.com/repos/confluentinc/ksql/issues/comments/386432951","html_url":"https://github.com/confluentinc/ksql/issues/1265#issuecomment-386432951","issue_url":"https://api.github.com/repos/confluentinc/ksql/issues/1265","id":386432951,"user":{"login":"robertrbruno","id":34684082,"avatar_url":"https://avatars2.githubusercontent.com/u/34684082?v=4","gravatar_id":"","url":"https://api.github.com/users/robertrbruno","html_url":"https://github.com/robertrbruno","followers_url":"https://api.github.com/users/robertrbruno/followers","following_url":"https://api.github.com/users/robertrbruno/following{/other_user}","gists_url":"https://api.github.com/users/robertrbruno/gists{/gist_id}","starred_url":"https://api.github.com/users/robertrbruno/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/robertrbruno/subscriptions","organizations_url":"https://api.github.com/users/robertrbruno/orgs","repos_url":"https://api.github.com/users/robertrbruno/repos","events_url":"https://api.github.com/users/robertrbruno/events{/privacy}","received_events_url":"https://api.github.com/users/robertrbruno/received_events","type":"User","site_admin":false},"created_at":"2018-05-03T20:52:27Z","updated_at":"2018-05-03T20:52:27Z","author_association":"NONE","body":"Ran more testing.  I apparently was not giving ksql enough time to reinitialize.  If i waited a few minutes things do resume correctly.  Sorry for the false alarm."}}
{"actor":{"display_login":"robertrbruno"}}