boris chmiel created DRILL-3671:
-----------------------------------
Summary: UNION infinite PENDING status
Key: DRILL-3671
URL: https://issues.apache.org/jira/browse/DRILL-3671
Project: Apache Drill
Issue Type: Bug
Components: Query Planning & Optimization
Affects Versions: 1.1.0
Environment: Drill embedded Win7 x64
Reporter: boris chmiel
Assignee: Jinfeng Ni
Querying a View containing more than 7 UNION clause on the same table, leads
the query to remain infinitely in PENDING status. The Physical Plan is not
created.
data_balance_sheet.csv :
account|m1|m2|m3|m4|m5|m6|m7|m8|m9|m10|m11|m12
A|3058.77|450.12|257390.92|58104.74|9376.08|109.28|13.24|2149.25|1962.30|1076.59|530.98|44918.63
SELECT columns[0] FROM dfs.tmp.`data_balance_sheet.csv`
=>
+---------+
| EXPR$0 |
+---------+
| A |
+---------+
View:
CREATE OR REPLACE VIEW dfs.tmp.view_balance_sheet AS (
SELECT CAST(columns[0] AS Varchar(20)) account, '01' Period, CAST(columns[1] AS
Varchar(20)) Val FROM dfs.tmp.`data_balance_sheet.csv`
UNION
SELECT CAST(columns[0] AS Varchar(20)) account, '02' Period, CAST(columns[2] AS
Varchar(20)) Val FROM dfs.tmp.`data_balance_sheet.csv`
UNION
SELECT CAST(columns[0] AS Varchar(20)) account, '03' Period, CAST(columns[3] AS
Varchar(20)) Val FROM dfs.tmp.`data_balance_sheet.csv`
UNION
SELECT CAST(columns[0] AS Varchar(20)) account, '04' Period, CAST(columns[4] AS
Varchar(20)) Val FROM dfs.tmp.`data_balance_sheet.csv`
UNION
SELECT CAST(columns[0] AS Varchar(20)) account, '05' Period, CAST(columns[5] AS
Varchar(20)) Val FROM dfs.tmp.`data_balance_sheet.csv`
UNION
SELECT CAST(columns[0] AS Varchar(20)) account, '06' Period, CAST(columns[6] AS
Varchar(20)) Val FROM dfs.tmp.`data_balance_sheet.csv`
UNION
SELECT CAST(columns[0] AS Varchar(20)) account, '07' Period, CAST(columns[7] AS
Varchar(20)) Val FROM dfs.tmp.`data_balance_sheet.csv`
UNION
SELECT CAST(columns[0] AS Varchar(20)) account, '08' Period, CAST(columns[8] AS
Varchar(20)) Val FROM dfs.tmp.`data_balance_sheet.csv`
UNION
SELECT CAST(columns[0] AS Varchar(20)) account, '09' Period, CAST(columns[9] AS
Varchar(20)) Val FROM dfs.tmp.`data_balance_sheet.csv`
UNION
SELECT CAST(columns[0] AS Varchar(20)) account, '10' Period, CAST(columns[10]
AS Varchar(20)) Val FROM dfs.tmp.`data_balance_sheet.csv`
UNION
SELECT CAST(columns[0] AS Varchar(20)) account, '11' Period, CAST(columns[11]
AS Varchar(20)) Val FROM dfs.tmp.`data_balance_sheet.csv`
UNION
SELECT CAST(columns[0] AS Varchar(20)) account, '12' Period, CAST(columns[12]
AS Varchar(20)) Val FROM dfs.tmp.`data_balance_sheet.csv`
);
=>
View 'view_balance_sheet' replaced successfully in 'dfs.tmp' schema
SELECT * FROM dfs.tmp.view_balance_sheet;
=> Nothing appends, status remains PENDING, no Physical Plan is created
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
