{"action":"created","issue":{"url":"https://api.github.com/repos/JSQLParser/JSqlParser/issues/593","repository_url":"https://api.github.com/repos/JSQLParser/JSqlParser","labels_url":"https://api.github.com/repos/JSQLParser/JSqlParser/issues/593/labels{/name}","comments_url":"https://api.github.com/repos/JSQLParser/JSqlParser/issues/593/comments","events_url":"https://api.github.com/repos/JSQLParser/JSqlParser/issues/593/events","html_url":"https://github.com/JSQLParser/JSqlParser/issues/593","id":308264881,"number":593,"title":"Snowflake compatible query not parseable","user":{"login":"Shivasish","id":12492314,"avatar_url":"https://avatars2.githubusercontent.com/u/12492314?v=4","gravatar_id":"","url":"https://api.github.com/users/Shivasish","html_url":"https://github.com/Shivasish","followers_url":"https://api.github.com/users/Shivasish/followers","following_url":"https://api.github.com/users/Shivasish/following{/other_user}","gists_url":"https://api.github.com/users/Shivasish/gists{/gist_id}","starred_url":"https://api.github.com/users/Shivasish/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Shivasish/subscriptions","organizations_url":"https://api.github.com/users/Shivasish/orgs","repos_url":"https://api.github.com/users/Shivasish/repos","events_url":"https://api.github.com/users/Shivasish/events{/privacy}","received_events_url":"https://api.github.com/users/Shivasish/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-03-24T14:01:53Z","updated_at":"2018-03-24T19:25:41Z","closed_at":null,"author_association":"NONE","body":"Trying to parse this query using JSqlParser : \r\nselect count(distinct case when client_organic_search_drop_flag=1 then brand end) over (partition by client,category_1,category_2,category_3,category_4 order)as client_brand_org_drop_count\r\n from sometable .\r\n\r\nGetting the below stack trace :                                                                                       \r\n Caused by: net.sf.jsqlparser.parser.ParseException: Encountered \" \"(\" \"( \"\" at line 1, column 88.\r\nWas expecting one of:\r\n\r\nThis query runs fine on Snowflake. Can someone help me out with tweaking the syntax so that it gets parsed by the parser.\r\n\r\nUsing maven version: 0.9.5 with java 1.8\r\n"},"comment":{"url":"https://api.github.com/repos/JSQLParser/JSqlParser/issues/comments/375918364","html_url":"https://github.com/JSQLParser/JSqlParser/issues/593#issuecomment-375918364","issue_url":"https://api.github.com/repos/JSQLParser/JSqlParser/issues/593","id":375918364,"user":{"login":"Shivasish","id":12492314,"avatar_url":"https://avatars2.githubusercontent.com/u/12492314?v=4","gravatar_id":"","url":"https://api.github.com/users/Shivasish","html_url":"https://github.com/Shivasish","followers_url":"https://api.github.com/users/Shivasish/followers","following_url":"https://api.github.com/users/Shivasish/following{/other_user}","gists_url":"https://api.github.com/users/Shivasish/gists{/gist_id}","starred_url":"https://api.github.com/users/Shivasish/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Shivasish/subscriptions","organizations_url":"https://api.github.com/users/Shivasish/orgs","repos_url":"https://api.github.com/users/Shivasish/repos","events_url":"https://api.github.com/users/Shivasish/events{/privacy}","received_events_url":"https://api.github.com/users/Shivasish/received_events","type":"User","site_admin":false},"created_at":"2018-03-24T19:25:40Z","updated_at":"2018-03-24T19:25:40Z","author_association":"NONE","body":"Yup this statement works on Snowflake. I removed the order by statement and\nstill tried. Same result.\n\nOn Sun, Mar 25, 2018 at 12:44 AM, Tobias <notifications@github.com> wrote:\n\n> My first guess is to write out a complete *order by* statement. I\n> reviewed the documentation of snowflake and could not find any hint of\n>\n> over (partition by a,b,c order) ...\n>\n> Are you positive, the statement of yours is correct?\n>\n> —\n> You are receiving this because you authored the thread.\n> Reply to this email directly, view it on GitHub\n> <https://github.com/JSQLParser/JSqlParser/issues/593#issuecomment-375917615>,\n> or mute the thread\n> <https://github.com/notifications/unsubscribe-auth/AL6eGrZnpE_2OQCS0wmpRBEOd_cRR-2eks5thpsFgaJpZM4S5vue>\n> .\n>\n"}}
{"actor":{"display_login":"Shivasish"}}