payload: {"action":"created","issue":{"url":"https://api.github.com/repos/harryprince/geospark/issues/2","repository_url":"https://api.github.com/repos/harryprince/geospark","labels_url":"https://api.github.com/repos/harryprince/geospark/issues/2/labels{/name}","comments_url":"https://api.github.com/repos/harryprince/geospark/issues/2/comments","events_url":"https://api.github.com/repos/harryprince/geospark/issues/2/events","html_url":"https://github.com/harryprince/geospark/pull/2","id":415826474,"node_id":"MDExOlB1bGxSZXF1ZXN0MjU3MjMwNzk2","number":2,"title":"Support for Livy, Spark 2.4, dplyr example","user":{"login":"javierluraschi","id":3478847,"node_id":"MDQ6VXNlcjM0Nzg4NDc=","avatar_url":"https://avatars1.githubusercontent.com/u/3478847?v=4","gravatar_id":"","url":"https://api.github.com/users/javierluraschi","html_url":"https://github.com/javierluraschi","followers_url":"https://api.github.com/users/javierluraschi/followers","following_url":"https://api.github.com/users/javierluraschi/following{/other_user}","gists_url":"https://api.github.com/users/javierluraschi/gists{/gist_id}","starred_url":"https://api.github.com/users/javierluraschi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/javierluraschi/subscriptions","organizations_url":"https://api.github.com/users/javierluraschi/orgs","repos_url":"https://api.github.com/users/javierluraschi/repos","events_url":"https://api.github.com/users/javierluraschi/events{/privacy}","received_events_url":"https://api.github.com/users/javierluraschi/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2019-02-28T21:15:12Z","updated_at":"2019-04-11T23:52:01Z","closed_at":"2019-03-31T09:40:43Z","author_association":"CONTRIBUTOR","pull_request":{"url":"https://api.github.com/repos/harryprince/geospark/pulls/2","html_url":"https://github.com/harryprince/geospark/pull/2","diff_url":"https://github.com/harryprince/geospark/pull/2.diff","patch_url":"https://github.com/harryprince/geospark/pull/2.patch"},"body":"@harryprince this is such a great extension! Nice job putting it together! I couldn't help myself to play with it and send some improvements for you to consider:\r\n- Support for Spark 2.4.\r\n- Enable support when using Livy connections.\r\n- Add `dplyr` example to README, move data files to data folder and config/benchmarks to their own section.\r\n\r\nWe are also adding your extension to spark.rstudio.com, you can probably consider publishing to CRAN at some point, it's already quite useful!"},"comment":{"url":"https://api.github.com/repos/harryprince/geospark/issues/comments/482375996","html_url":"https://github.com/harryprince/geospark/pull/2#issuecomment-482375996","issue_url":"https://api.github.com/repos/harryprince/geospark/issues/2","id":482375996,"node_id":"MDEyOklzc3VlQ29tbWVudDQ4MjM3NTk5Ng==","user":{"login":"harryprince","id":5362577,"node_id":"MDQ6VXNlcjUzNjI1Nzc=","avatar_url":"https://avatars2.githubusercontent.com/u/5362577?v=4","gravatar_id":"","url":"https://api.github.com/users/harryprince","html_url":"https://github.com/harryprince","followers_url":"https://api.github.com/users/harryprince/followers","following_url":"https://api.github.com/users/harryprince/following{/other_user}","gists_url":"https://api.github.com/users/harryprince/gists{/gist_id}","starred_url":"https://api.github.com/users/harryprince/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/harryprince/subscriptions","organizations_url":"https://api.github.com/users/harryprince/orgs","repos_url":"https://api.github.com/users/harryprince/repos","events_url":"https://api.github.com/users/harryprince/events{/privacy}","received_events_url":"https://api.github.com/users/harryprince/received_events","type":"User","site_admin":false},"created_at":"2019-04-11T23:52:01Z","updated_at":"2019-04-11T23:52:01Z","author_association":"OWNER","body":"@javierluraschi \r\n\r\nin this PR, the `dplyr` related example does not work.\r\n\r\nAnd I added another example, see more discussion in #9 \r\n\r\n```\r\nlibrary(dplyr)\r\npolygons_wkt <- mutate(polygons_wkt, y = st_geomfromwkt(geom))\r\npoints_wkt <- mutate(points_wkt, x = st_geomfromwkt(geom))\r\n\r\nsc_res = full_join(polygons_wkt  %>% mutate(dummy=TRUE) %>% compute(),\r\n                   points_wkt %>% mutate(dummy=TRUE) %>% compute(),\r\n                   by = \"dummy\") %>% \r\n   filter(sql(\"st_contains(y,x)\")) %>%\r\n  group_by(area, state) %>%\r\n  summarise(cnt = n()) \r\n  \r\nsc_res %>%\r\n  head()\r\n```"}}
other: {"actor":{"display_login":"harryprince"}}