{"action":"created","issue":{"url":"https://api.github.com/repos/apache/spark/issues/11306","repository_url":"https://api.github.com/repos/apache/spark","labels_url":"https://api.github.com/repos/apache/spark/issues/11306/labels{/name}","comments_url":"https://api.github.com/repos/apache/spark/issues/11306/comments","events_url":"https://api.github.com/repos/apache/spark/issues/11306/events","html_url":"https://github.com/apache/spark/pull/11306","id":135495986,"number":11306,"title":"[SPARK-12941][SQL][MASTER] Spark-SQL JDBC Oracle dialect fails to map string datatypes to Oracle VARCHAR datatype","user":{"login":"thomastechs","id":2070810,"avatar_url":"https://avatars.githubusercontent.com/u/2070810?v=3","gravatar_id":"","url":"https://api.github.com/users/thomastechs","html_url":"https://github.com/thomastechs","followers_url":"https://api.github.com/users/thomastechs/followers","following_url":"https://api.github.com/users/thomastechs/following{/other_user}","gists_url":"https://api.github.com/users/thomastechs/gists{/gist_id}","starred_url":"https://api.github.com/users/thomastechs/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thomastechs/subscriptions","organizations_url":"https://api.github.com/users/thomastechs/orgs","repos_url":"https://api.github.com/users/thomastechs/repos","events_url":"https://api.github.com/users/thomastechs/events{/privacy}","received_events_url":"https://api.github.com/users/thomastechs/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":10,"created_at":"2016-02-22T18:08:51Z","updated_at":"2016-02-23T08:48:00Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/apache/spark/pulls/11306","html_url":"https://github.com/apache/spark/pull/11306","diff_url":"https://github.com/apache/spark/pull/11306.diff","patch_url":"https://github.com/apache/spark/pull/11306.patch"},"body":"## What changes were proposed in this pull request?\r\n\r\nThis Pull request is used for the fix SPARK-12941, creating a data type mapping to Oracle for the corresponding data type\"Stringtype\" from dataframe. This PR is for the master branch fix, where as another PR is already tested with the branch 1.4\r\n\r\n\r\n## How was the this patch tested?\r\n\r\n(Please explain how this patch was tested. E.g. unit tests, integration tests, manual tests)\r\nThis patch was tested using the Oracle docker .Created a new integration suite for the same.The oracle.jdbc jar was to be downloaded from the maven repository.Since there was no jdbc jar available in the maven repository, the jar was downloaded from oracle site manually and installed in the local; thus tested. So, for SparkQA test case run, the ojdbc jar might be manually placed in the local maven repository(com/oracle/ojdbc6/11.2.0.2.0) while Spark QA test run.\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/apache/spark/issues/comments/187604049","html_url":"https://github.com/apache/spark/pull/11306#issuecomment-187604049","issue_url":"https://api.github.com/repos/apache/spark/issues/11306","id":187604049,"user":{"login":"SparkQA","id":8108735,"avatar_url":"https://avatars.githubusercontent.com/u/8108735?v=3","gravatar_id":"","url":"https://api.github.com/users/SparkQA","html_url":"https://github.com/SparkQA","followers_url":"https://api.github.com/users/SparkQA/followers","following_url":"https://api.github.com/users/SparkQA/following{/other_user}","gists_url":"https://api.github.com/users/SparkQA/gists{/gist_id}","starred_url":"https://api.github.com/users/SparkQA/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SparkQA/subscriptions","organizations_url":"https://api.github.com/users/SparkQA/orgs","repos_url":"https://api.github.com/users/SparkQA/repos","events_url":"https://api.github.com/users/SparkQA/events{/privacy}","received_events_url":"https://api.github.com/users/SparkQA/received_events","type":"User","site_admin":false},"created_at":"2016-02-23T08:48:00Z","updated_at":"2016-02-23T08:48:00Z","body":"**[Test build #51741 has finished](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/51741/consoleFull)** for PR 11306 at commit [`87e3d7f`](https://github.com/apache/spark/commit/87e3d7f4de872852a3f16bf6a31761a8cfd1d46b).\n * This patch **fails Spark unit tests**.\n * This patch merges cleanly.\n * This patch adds no public classes."}}