[
https://issues.apache.org/jira/browse/DRILL-3671?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Turton closed DRILL-3671.
-------------------------------
Resolution: Fixed
Query is plannable using the current Drill master.
> 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)
