[
https://issues.apache.org/jira/browse/HIVE-19710?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16491096#comment-16491096
]
Alan Gates commented on HIVE-19710:
-----------------------------------
This is a duplicate of HIVE-19686, which I'm already working through the patch
queue.
And yes, Miklos is right, this works fine with all the databases. If two
people try to use the tool at the same time one will fail because the key value
being inserted is a primary key. With the for update clause the second one
would have blocked instead of failed. But since this is an admin only tool
multiple simultaneous use shouldn't be the norm.
> Hive Schema Tool createCatalog command is not working with postgres DB
> ----------------------------------------------------------------------
>
> Key: HIVE-19710
> URL: https://issues.apache.org/jira/browse/HIVE-19710
> Project: Hive
> Issue Type: Bug
> Components: Hive
> Affects Versions: 3.0.0
> Reporter: Miklos Gergely
> Assignee: Miklos Gergely
> Priority: Major
> Fix For: 3.0.0
>
> Attachments: HIVE-19710.01.patch
>
>
> Hive Schema Tool can't create catalogs if the db is postgres due to trying to
> run an aggregated query in FOR UPDATE mode which is not supported.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
