Details
-
Bug
-
Status: Resolved
-
Blocker
-
Resolution: Fixed
-
1.17.0
-
None
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
- links to