hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chaoyu Tang (JIRA)" <>
Subject [jira] [Commented] (HIVE-8485) HMS on Oracle incompatibility
Date Sat, 24 Jan 2015 16:35:34 GMT


Chaoyu Tang commented on HIVE-8485:

[~sushanth] I was initially concerned about the impacts probably caused by the change to other
dbs, thanks for the clarification! 
+1 (non-binding)

> HMS on Oracle incompatibility
> -----------------------------
>                 Key: HIVE-8485
>                 URL:
>             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
> 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

View raw message