[
https://issues.apache.org/jira/browse/DRILL-7476?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Arina Ielchiieva updated DRILL-7476:
------------------------------------
Description:
Affected schema: sys
Affected tables: connections, threads, memory
If query is executed with limit clause, information for some fields is 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}
When selecting data from *Drillbits* table which has similar fields (ex:
hostname), everything is fine:
{noformat}
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 |
+------------+-----------+--------------+-----------+-----------+---------+---------+--------+
{noformat}
was:
Affected schema: sys
Affected tables: connections, threads, memory
If query is executed with limit clause, information for some fields is 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}
> 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
> Assignee: Paul Rogers
> Priority: Blocker
> Fix For: 1.17.0
>
>
> Affected schema: sys
> Affected tables: connections, threads, memory
> If query is executed with limit clause, information for some fields is
> 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}
> When selecting data from *Drillbits* table which has similar fields (ex:
> hostname), everything is fine:
> {noformat}
> 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 |
> +------------+-----------+--------------+-----------+-----------+---------+---------+--------+
> {noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
