Return-Path: 
 <dev-return-121168-apmail-hive-dev-archive=hive.apache.org@hive.apache.org>
X-Original-To: apmail-hive-dev-archive@www.apache.org
Delivered-To: apmail-hive-dev-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id F3ED010291
	for <apmail-hive-dev-archive@www.apache.org>;
 Wed,  7 Jan 2015 23:22:34 +0000 (UTC)
Received: (qmail 85383 invoked by uid 500); 7 Jan 2015 23:22:35 -0000
Delivered-To: apmail-hive-dev-archive@hive.apache.org
Received: (qmail 85318 invoked by uid 500); 7 Jan 2015 23:22:35 -0000
Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@hive.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@hive.apache.org>
List-Post: <mailto:dev@hive.apache.org>
List-Id: <dev.hive.apache.org>
Reply-To: dev@hive.apache.org
Delivered-To: mailing list dev@hive.apache.org
Received: (qmail 85299 invoked by uid 500); 7 Jan 2015 23:22:35 -0000
Delivered-To: apmail-hadoop-hive-dev@hadoop.apache.org
Received: (qmail 85296 invoked by uid 99); 7 Jan 2015 23:22:35 -0000
Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 07 Jan 2015 23:22:35 +0000
Date: Wed, 7 Jan 2015 23:22:35 +0000 (UTC)
From: "Sushanth Sowmyan (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: <JIRA.12748584.1413464385000.33082.1420672955470@Atlassian.JIRA>
In-Reply-To: <JIRA.12748584.1413464385000@Atlassian.JIRA>
References: <JIRA.12748584.1413464385000@Atlassian.JIRA>
 <JIRA.12748584.1413464385691@arcas>
Subject: [jira] [Updated] (HIVE-8485) HMS on Oracle incompatibility
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394


     [ https://issues.apache.org/jira/browse/HIVE-8485?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sushanth Sowmyan updated HIVE-8485:
-----------------------------------
    Status: Patch Available  (was: Open)

> HMS on Oracle incompatibility
> -----------------------------
>
>                 Key: HIVE-8485
>                 URL: https://issues.apache.org/jira/browse/HIVE-8485
>             Project: Hive
>          Issue Type: Bug
>          Components: Metastore
>         Environment: Oracle as metastore DB
>            Reporter: Ryan Pridgeon
>            Assignee: Chaoyu Tang
>         Attachments: HIVE-8485.2.patch, HIVE-8485.patch
>
>
> Oracle does not distinguish between empty strings and NULL,which proves problematic for DataNucleus.
> In the event a user creates a table with some property stored as an empty string the table will no longer be accessible.
> i.e. TBLPROPERTIES ('serialization.null.format'='')
> If they try to select, describe, drop, etc the client prints the following exception.
> ERROR ql.Driver: FAILED: SemanticException [Error 10001]: Table not found <table name>
> The work around for this was to go into the hive metastore on the Oracle database and replace NULL with some other string. Users could then drop the tables or alter their data to use the new null format they just set.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)