[
https://issues.apache.org/jira/browse/DRILL-3671?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vova Vysotskyi updated DRILL-3671:
----------------------------------
Description:
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 :
{noformat}
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
{noformat}
{code:sql}
SELECT columns[0] FROM dfs.tmp.`data_balance_sheet.csv`
{code}
=>
{noformat}
+---------+
| EXPR$0 |
+---------+
| A |
+---------+
{noformat}
View:
{code:sql}
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`
);
{code}
=>
{noformat}
View 'view_balance_sheet' replaced successfully in 'dfs.tmp' schema
{noformat}
{code:sql}
SELECT * FROM dfs.tmp.view_balance_sheet;
{code}
=> Nothing appends, status remains PENDING, no Physical Plan is created
was:
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
> 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
> Priority: Major
> Fix For: Future
>
>
> 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 :
> {noformat}
> 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
> {noformat}
> {code:sql}
> SELECT columns[0] FROM dfs.tmp.`data_balance_sheet.csv`
> {code}
> =>
> {noformat}
> +---------+
> | EXPR$0 |
> +---------+
> | A |
> +---------+
> {noformat}
> View:
> {code:sql}
> 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`
> );
> {code}
> =>
> {noformat}
> View 'view_balance_sheet' replaced successfully in 'dfs.tmp' schema
> {noformat}
> {code:sql}
> SELECT * FROM dfs.tmp.view_balance_sheet;
> {code}
> => Nothing appends, status remains PENDING, no Physical Plan is created
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
