[
https://issues.apache.org/jira/browse/DRILL-6693?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anton Gozhiy updated DRILL-6693:
--------------------------------
Description:
*Steps:*
# From Web UI, run the following query:
{noformat}
select *
from (
select employee_id, full_name, first_name, last_name, position_id,
position_title, store_id, department_id, birth_date, hire_date, salary,
supervisor_id, education_level, marital_status, gender, management_role
from cp.`employee.json`
union
select employee_id, full_name, first_name, last_name, position_id,
position_title, store_id, department_id, birth_date, hire_date, salary,
supervisor_id, education_level, marital_status, gender, management_role
from cp.`employee.json`
union
select employee_id, full_name, first_name, last_name, position_id,
position_title, store_id, department_id, birth_date, hire_date, salary,
supervisor_id, education_level, marital_status, gender, management_role
from cp.`employee.json`)
where last_name = 'Blumberg'
{noformat}
# While query is running, try open the Profiles page (or any other). If It
completes too fast, add some unions to the query above.
*Expected result:*
Profiles page should be opened. The running query should be listed.
*Actual result:*
The Web UI hangs until the query completes.
*Notes:*
- If you open another tab with Web Console, it also stuck when the query is
running.
- If the query is started from sqlline, everything is fine.
was:
*Steps:*
# From Web UI, run the following query:
{noformat}
select *
from (
select employee_id, full_name, first_name, last_name, position_id,
position_title, store_id, department_id, birth_date, hire_date, salary,
supervisor_id, education_level, marital_status, gender, management_role
from cp.`employee.json`
union
select employee_id, full_name, first_name, last_name, position_id,
position_title, store_id, department_id, birth_date, hire_date, salary,
supervisor_id, education_level, marital_status, gender, management_role
from cp.`employee.json`
union
select employee_id, full_name, first_name, last_name, position_id,
position_title, store_id, department_id, birth_date, hire_date, salary,
supervisor_id, education_level, marital_status, gender, management_role
from cp.`employee.json`)
where last_name = 'Blumberg'
{noformat}
# While query is running, try open the Profiles page (or any other). If It
completes too fast, add some unions to the query above.
*Expected result:*
Profiles page should be opened. The running query should be listed.
*Actual result:*
The Web UI hangs until the query completes.
*Note:*
If the query is started from sqlline, everything is fine.
> When a query is started from Drill Web Console, the UI becomes inaccessible
> until the query is completed
> --------------------------------------------------------------------------------------------------------
>
> Key: DRILL-6693
> URL: https://issues.apache.org/jira/browse/DRILL-6693
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.13.0, 1.14.0, 1.15.0
> Reporter: Anton Gozhiy
> Priority: Major
>
> *Steps:*
> # From Web UI, run the following query:
> {noformat}
> select *
> from (
> select employee_id, full_name, first_name, last_name, position_id,
> position_title, store_id, department_id, birth_date, hire_date, salary,
> supervisor_id, education_level, marital_status, gender, management_role
> from cp.`employee.json`
> union
> select employee_id, full_name, first_name, last_name, position_id,
> position_title, store_id, department_id, birth_date, hire_date, salary,
> supervisor_id, education_level, marital_status, gender, management_role
> from cp.`employee.json`
> union
> select employee_id, full_name, first_name, last_name, position_id,
> position_title, store_id, department_id, birth_date, hire_date, salary,
> supervisor_id, education_level, marital_status, gender, management_role
> from cp.`employee.json`)
> where last_name = 'Blumberg'
> {noformat}
> # While query is running, try open the Profiles page (or any other). If It
> completes too fast, add some unions to the query above.
> *Expected result:*
> Profiles page should be opened. The running query should be listed.
> *Actual result:*
> The Web UI hangs until the query completes.
> *Notes:*
> - If you open another tab with Web Console, it also stuck when the query is
> running.
> - If the query is started from sqlline, everything is fine.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
