You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Arina Ielchiieva (Jira)" <ji...@apache.org> on 2019/12/10 13:10:00 UTC
[jira] [Created] (DRILL-7476) Info in some sys schema tables are
missing if queried with limit clause
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)