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

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

Sergey Shelukhin created HIVE-18075:
---------------------------------------

             Summary: 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; 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.



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