[
https://issues.apache.org/jira/browse/HIVE-18685?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16364210#comment-16364210
]
Peter Vary commented on HIVE-18685:
-----------------------------------
Can not attach file, here is the log snippet:
{code:java}
INSERT INTO `DBS`
(`DB_ID`,`OWNER_NAME`,`DB_LOCATION_URI`,`NAME`,`OWNER_TYPE`,`DESC`) VALUES
([..])
------- TRX HAS BEEN WAITING 26 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 13229 page no 4 n bits 320 index "UNIQUE_DATABASE" of
table "hive"."DBS" trx id 0 3583341725 lock mode S waiting
[..]
INSERT INTO `TBLS`
(`TBL_ID`,`VIEW_EXPANDED_TEXT`,`LAST_ACCESS_TIME`,`OWNER`,`TBL_TYPE`,`DB_ID`,`TBL_NAME`,`RETENTION`,`CREATE_TIME`,`SD_ID`,`VIEW_ORIGINAL_TEXT`)
VALUES ([..])
------- TRX HAS BEEN WAITING 25 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 496 page no 877 n bits 400 index "UNIQUETABLE" of table
"hive"."TBLS" trx id 0 3583341724 lock mode S waiting
[..]
UPDATE `NOTIFICATION_SEQUENCE` SET `NEXT_EVENT_ID`=865944 WHERE `NNI_ID`=1
------- TRX HAS BEEN WAITING 26 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 24190 page no 3 n bits 72 index "PRIMARY" of table
"hive"."NOTIFICATION_SEQUENCE" trx id 0 3583341715 lock_mode X locks rec but
not gap waiting
[..]
UPDATE `NOTIFICATION_SEQUENCE` SET `NEXT_EVENT_ID`=865944 WHERE `NNI_ID`=1
------- TRX HAS BEEN WAITING 116 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 24190 page no 3 n bits 72 index "PRIMARY" of table
"hive"."NOTIFICATION_SEQUENCE" trx id 0 3583314822 lock_mode X locks rec but
not gap waiting{code}
> Add catalogs to metastore
> -------------------------
>
> Key: HIVE-18685
> URL: https://issues.apache.org/jira/browse/HIVE-18685
> Project: Hive
> Issue Type: New Feature
> Components: Metastore
> Affects Versions: 3.0.0
> Reporter: Alan Gates
> Assignee: Alan Gates
> Priority: Major
> Attachments: HMS Catalog Design Doc.pdf
>
>
> SQL supports two levels of namespaces, called in the spec catalogs and
> schemas (with schema being equivalent to Hive's database). I propose to add
> the upper level of catalog. The attached design doc covers the use cases,
> requirements, and brief discussion of how it will be implemented in a
> backwards compatible way.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
