[jira] [Commented] (HIVE-11510) Metatool updateLocation warning on views

["Wei Zheng (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-11510?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14720352#comment-14720352 ] 

Wei Zheng commented on HIVE-11510:
----------------------------------

[~sushanth] Can you review?

> Metatool updateLocation warning on views
> ----------------------------------------
>
>                 Key: HIVE-11510
>                 URL: https://issues.apache.org/jira/browse/HIVE-11510
>             Project: Hive
>          Issue Type: Bug
>          Components: Database/Schema
>    Affects Versions: 0.14.0
>            Reporter: Eric Czech
>            Assignee: Wei Zheng
>         Attachments: HIVE-11510.1.patch
>
>
> If views are present in a hive database, issuing a 'hive metatool -updateLocation' command will result in an error like this:
> ...
> Warning: Found records with bad LOCATION in SDS table.. 
> bad location URI: null
> bad location URI: null
> bad location URI: null
> ....
> Based on the source code for Metatool, it looks like there would then be a "bad location URI: null" message for every view and it also appears this is happening simply because the 'sds' table in the hive schema has a column called location that is NULL only for views.



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