{"action":"created","issue":{"url":"https://api.github.com/repos/s-u/RJDBC/issues/25","labels_url":"https://api.github.com/repos/s-u/RJDBC/issues/25/labels{/name}","comments_url":"https://api.github.com/repos/s-u/RJDBC/issues/25/comments","events_url":"https://api.github.com/repos/s-u/RJDBC/issues/25/events","html_url":"https://github.com/s-u/RJDBC/issues/25","id":104310712,"number":25,"title":"hive jdbc execute vs executeQuery","user":{"login":"piccolbo","id":905563,"avatar_url":"https://avatars.githubusercontent.com/u/905563?v=3","gravatar_id":"","url":"https://api.github.com/users/piccolbo","html_url":"https://github.com/piccolbo","followers_url":"https://api.github.com/users/piccolbo/followers","following_url":"https://api.github.com/users/piccolbo/following{/other_user}","gists_url":"https://api.github.com/users/piccolbo/gists{/gist_id}","starred_url":"https://api.github.com/users/piccolbo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/piccolbo/subscriptions","organizations_url":"https://api.github.com/users/piccolbo/orgs","repos_url":"https://api.github.com/users/piccolbo/repos","events_url":"https://api.github.com/users/piccolbo/events{/privacy}","received_events_url":"https://api.github.com/users/piccolbo/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-09-01T16:56:42Z","updated_at":"2015-09-01T20:20:25Z","closed_at":null,"body":"Hi \r\nI am using RJDBC to connect to a HIVE JDBC server. Create statements fail. I found that RJDBC prepares a create statement and then calls executeQuery on it. Tracking down forum discussion, I found out that it used to work, but it's become more strict and that now one is supposed to call execute to create tables, which returns a boolean. I verified that's the case with\r\n\r\n```\r\n.jcall(s, \"Z\", \"execute\", as.character(statement)[1],  check = TRUE)\r\n[1] TRUE\r\n```\r\n\r\nIt's not clear to me that this is a RJDBC bug, but for them it is an \"improvement\" and I see it as unlikely they are going to backtrack. What's the way forward? Thanks"},"comment":{"url":"https://api.github.com/repos/s-u/RJDBC/issues/comments/136849591","html_url":"https://github.com/s-u/RJDBC/issues/25#issuecomment-136849591","issue_url":"https://api.github.com/repos/s-u/RJDBC/issues/25","id":136849591,"user":{"login":"s-u","id":2073427,"avatar_url":"https://avatars.githubusercontent.com/u/2073427?v=3","gravatar_id":"","url":"https://api.github.com/users/s-u","html_url":"https://github.com/s-u","followers_url":"https://api.github.com/users/s-u/followers","following_url":"https://api.github.com/users/s-u/following{/other_user}","gists_url":"https://api.github.com/users/s-u/gists{/gist_id}","starred_url":"https://api.github.com/users/s-u/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/s-u/subscriptions","organizations_url":"https://api.github.com/users/s-u/orgs","repos_url":"https://api.github.com/users/s-u/repos","events_url":"https://api.github.com/users/s-u/events{/privacy}","received_events_url":"https://api.github.com/users/s-u/received_events","type":"User","site_admin":false},"created_at":"2015-09-01T20:20:25Z","updated_at":"2015-09-01T20:20:25Z","body":"That branch is for queries w/o additional arguments (i.e., no `?` substitution) - `createStatement` is just a method in Java to create a statement object, regardless of the type of the statement."}}