Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-7476

Info in some sys schema tables are missing if queried with limit clause

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 1.17.0
    • Fix Version/s: 1.17.0
    • Component/s: None
    • Labels:

      Description

      Affected schema: sys
      Affected tables: connections, threads, memory

      If query is executed with limit clause, information for some fields is missing:

      Connections

      apache drill (sys)> select * from connections;
      +-----------+---------------+------------+-------------------------+-------------------+---------+-----------------+-------------+----------+--------------------------------------+
      |   user    |    client     |  drillbit  |       established       |     duration      | queries | isAuthenticated | isEncrypted | usingSSL |               session                |
      +-----------+---------------+------------+-------------------------+-------------------+---------+-----------------+-------------+----------+--------------------------------------+
      | anonymous | xxx.xxx.x.xxx | xxx | 2019-12-10 13:45:01.766 | 59 min 42.393 sec | 27      | false           | false       | false    | xxx |
      +-----------+---------------+------------+-------------------------+-------------------+---------+-----------------+-------------+----------+--------------------------------------+
      1 row selected (0.1 seconds)
      apache drill (sys)> select * from connections limit 1;
      +------+--------+----------+-------------------------+----------+---------+-----------------+-------------+----------+---------+
      | user | client | drillbit |       established       | duration | queries | isAuthenticated | isEncrypted | usingSSL | session |
      +------+--------+----------+-------------------------+----------+---------+-----------------+-------------+----------+---------+
      |      |        |          | 2019-12-10 13:45:01.766 |          | 28      | false           | false       | false    |         |
      +------+--------+----------+-------------------------+----------+---------+-----------------+-------------+----------+---------+
      

      Threads

      apache drill (sys)> select * from threads;
      +------------+-----------+---------------+--------------+
      |  hostname  | user_port | total_threads | busy_threads |
      +------------+-----------+---------------+--------------+
      | xxx | 31010     | 27            | 23           |
      +------------+-----------+---------------+--------------+
      1 row selected (0.119 seconds)
      apache drill (sys)> select * from threads limit 1; 
      +----------+-----------+---------------+--------------+
      | hostname | user_port | total_threads | busy_threads |
      +----------+-----------+---------------+--------------+
      |          | 31010     | 27            | 24           |
      

      Memory

      apache drill (sys)> select * from memory;
      +------------+-----------+--------------+------------+----------------+--------------------+------------+
      |  hostname  | user_port | heap_current |  heap_max  | direct_current | jvm_direct_current | direct_max |
      +------------+-----------+--------------+------------+----------------+--------------------+------------+
      | xxx | 31010     | 493974480    | 4116185088 | 5048576        | 122765             | 8589934592 |
      +------------+-----------+--------------+------------+----------------+--------------------+------------+
      1 row selected (0.115 seconds)
      apache drill (sys)> select * from memory limit 1;
      +----------+-----------+--------------+------------+----------------+--------------------+------------+
      | hostname | user_port | heap_current |  heap_max  | direct_current | jvm_direct_current | direct_max |
      +----------+-----------+--------------+------------+----------------+--------------------+------------+
      |          | 31010     | 499343272    | 4116185088 | 9048576        | 122765             | 8589934592 |
      +----------+-----------+--------------+------------+----------------+--------------------+------------+
      

      When selecting data from Drillbits table which has similar fields (ex: hostname), everything is fine:

      apache drill (sys)> select * from drillbits;
      +------------+-----------+--------------+-----------+-----------+---------+---------+--------+
      |  hostname  | user_port | control_port | data_port | http_port | current | version | state  |
      +------------+-----------+--------------+-----------+-----------+---------+---------+--------+
      | xxx | 31010     | 31011        | 31012     | 8047      | true    | 1.17.0  | ONLINE |
      +------------+-----------+--------------+-----------+-----------+---------+---------+--------+
      1 row selected (0.114 seconds)
      apache drill (sys)> select * from drillbits limit 1;
      +------------+-----------+--------------+-----------+-----------+---------+---------+--------+
      |  hostname  | user_port | control_port | data_port | http_port | current | version | state  |
      +------------+-----------+--------------+-----------+-----------+---------+---------+--------+
      | xxx | 31010     | 31011        | 31012     | 8047      | true    | 1.17.0  | ONLINE |
      +------------+-----------+--------------+-----------+-----------+---------+---------+--------+
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Paul.Rogers Paul Rogers
                Reporter:
                arina Arina Ielchiieva
                Reviewer:
                Vova Vysotskyi
              • Votes:
                1 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: