[jira] [Updated] (HIVE-18075) verify commands on a cluster

["Sergey Shelukhin (JIRA)" <ji...@apache.org>]

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

Sergey Shelukhin updated HIVE-18075:
------------------------------------
    Description: 
I was running the commands in the cluster, with potentially a slightly outdated version of the DB on mysql (yet, the DB was created with a script from master and I didn't hit any schema issues, so it's fairly recent); however, recent master code + the pools commands patch. I've hit the following issues.
# Cannot drop pool or RP with a mapping (see also 3).
# Cannot drop pool that is set as default (probably correct, but the error message is bad).
# When I dropped an RP with a mapping, and then created it again with the same name, the pool creation in that RP would fail with an error that a unique query returned multiple results. In the DB, there were actually 2 RPs with the same name. Not sure how exactly that happened, there might have been intermediate states, but I didn't mess with mysql. I think the name uniqueness is either missing from some script or doesn't work.
# Setting RP default pool no longer works. I think I might have broken it with one of the rebases in that area, but it could also be something else (or like other things, it works in q tests but not on cluster for whatever reason).
# Resource plan rename doesn't check the disable state. It probably should. Also need to see for other commands.
Need to figure out which are real issues and which aren't and fix.

  was:
I was running the commands in the cluster, with potentially a slightly outdated version of the DB; however, recent master code + the pools commands patch. I've hit the following issues.
# Cannot drop pool or RP with a mapping (see also 3).
# Cannot drop pool that is set as default (probably correct, but the error message is bad).
# When I dropped an RP with a mapping, and then created it again with the same name, the pool creation in that RP would fail with an error that a unique query returned multiple results. In the DB, there were actually 2 RPs with the same name. Not sure how exactly that happened, there might have been intermediate states, but I didn't mess with mysql. I think the name uniqueness is either missing from some script or doesn't work.
# Setting RP default pool no longer works. I think I might have broken it with one of the rebases in that area, but it could also be something else (or like other things, it works in q tests but not on cluster for whatever reason).
# Resource plan rename doesn't check the disable state. It probably should. Also need to see for other commands.


> verify commands on a cluster
> ----------------------------
>
>                 Key: HIVE-18075
>                 URL: https://issues.apache.org/jira/browse/HIVE-18075
>             Project: Hive
>          Issue Type: Sub-task
>            Reporter: Sergey Shelukhin
>
> I was running the commands in the cluster, with potentially a slightly outdated version of the DB on mysql (yet, the DB was created with a script from master and I didn't hit any schema issues, so it's fairly recent); however, recent master code + the pools commands patch. I've hit the following issues.
> # Cannot drop pool or RP with a mapping (see also 3).
> # Cannot drop pool that is set as default (probably correct, but the error message is bad).
> # When I dropped an RP with a mapping, and then created it again with the same name, the pool creation in that RP would fail with an error that a unique query returned multiple results. In the DB, there were actually 2 RPs with the same name. Not sure how exactly that happened, there might have been intermediate states, but I didn't mess with mysql. I think the name uniqueness is either missing from some script or doesn't work.
> # Setting RP default pool no longer works. I think I might have broken it with one of the rebases in that area, but it could also be something else (or like other things, it works in q tests but not on cluster for whatever reason).
> # Resource plan rename doesn't check the disable state. It probably should. Also need to see for other commands.
> Need to figure out which are real issues and which aren't and fix.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)