Arina Ielchiieva created DRILL-7476:
---------------------------------------
Summary: Info in some sys schema tables are missing if queried
with limit clause
Key: DRILL-7476
URL: https://issues.apache.org/jira/browse/DRILL-7476
Project: Apache Drill
Issue Type: Bug
Affects Versions: 1.17.0
Reporter: Arina Ielchiieva
Affected schema: sys
Affected tables: connections, threads, memory
If query is executed with limit clause, information for some fields are missing:
*Connections*
{noformat}
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 | |
+------+--------+----------+-------------------------+----------+---------+-----------------+-------------+----------+---------+
{noformat}
*Threads*
{noformat}
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 |
{noformat}
*Memory*
{noformat}
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 |
+----------+-----------+--------------+------------+----------------+--------------------+------------+
{noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
