Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-17483

HS2 kill command to kill queries using query id

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 3.0.0
    • HiveServer2
    • Hide
      In HiveConnection -
      static List<JdbcConnectionParams> getAllUrls(String zookeeperBasedHS2Url)
      You can call
      JdbcConnectionParams.toString() to get the actual URL

      In HiveStatement -
      You can get query id of a running query using -
      String getQueryId()

      You can kill hive queries using
      "KILL QUERY <queryid1> <queryid2>"
      Show
      In HiveConnection - static List<JdbcConnectionParams> getAllUrls(String zookeeperBasedHS2Url) You can call JdbcConnectionParams.toString() to get the actual URL In HiveStatement - You can get query id of a running query using - String getQueryId() You can kill hive queries using "KILL QUERY <queryid1> <queryid2>"

    Description

      For administrators, it is important to be able to kill queries if required.
      Currently, there is no clean way to do it.
      It would help to have a "kill query <query id>" command that can be run using odbc/jdbc against a HiveServer2 instance, to kill a query with that queryid running in that instance.
      Authorization will have to be done to ensure that the user that is invoking the API is allowed to perform this action.
      In case of SQL std authorization, this would require admin role.

      Attachments

        1. HIVE-17483.1.patch
          231 kB
          Teddy Choi
        2. HIVE-17483.10.patch
          181 kB
          Teddy Choi
        3. HIVE-17483.2.patch
          173 kB
          Teddy Choi
        4. HIVE-17483.2.patch
          179 kB
          Teddy Choi
        5. HIVE-17483.3.patch
          173 kB
          Teddy Choi
        6. HIVE-17483.4.patch
          181 kB
          Teddy Choi
        7. HIVE-17483.5.patch
          181 kB
          Teddy Choi
        8. HIVE-17483.6.patch
          181 kB
          Teddy Choi
        9. HIVE-17483.7.patch
          176 kB
          Teddy Choi
        10. HIVE-17483.8.patch
          179 kB
          Teddy Choi
        11. HIVE-17483.9.patch
          181 kB
          Teddy Choi

        Issue Links

          Activity

            People

              teddy.choi Teddy Choi
              thejas Thejas Nair
              Votes:
              1 Vote for this issue
              Watchers:
              12 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: