[jira] [Commented] (HIVE-16668) Hive on Spark generates incorrect plan and result with window function and lateral view
[
https://issues.apache.org/jira/browse/HIVE-16668?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16551505#comment-16551505
]
Hive QA commented on HIVE-16668:
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12868568/HIVE-16668.3.patch
{color:red}ERROR:{color} -1 due to build exiting with an error
Test results:
https://builds.apache.org/job/PreCommit-HIVE-Build/12749/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/12749/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-12749/
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Tests exited with: NonZeroExitCodeException
Command 'bash /data/hiveptest/working/scratch/source-prep.sh' failed with exit
status 1 and output '+ date '+%Y-%m-%d %T.%3N'
2018-07-21 02:21:50.766
+ [[ -n /usr/lib/jvm/java-8-openjdk-amd64 ]]
+ export JAVA_HOME=/usr/lib/jvm/java-8-openjdk-amd64
+ JAVA_HOME=/usr/lib/jvm/java-8-openjdk-amd64
+ export
PATH=/usr/lib/jvm/java-8-openjdk-amd64/bin/:/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games
+
PATH=/usr/lib/jvm/java-8-openjdk-amd64/bin/:/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games
+ export 'ANT_OPTS=-Xmx1g -XX:MaxPermSize=256m '
+ ANT_OPTS='-Xmx1g -XX:MaxPermSize=256m '
+ export 'MAVEN_OPTS=-Xmx1g '
+ MAVEN_OPTS='-Xmx1g '
+ cd /data/hiveptest/working/
+ tee /data/hiveptest/logs/PreCommit-HIVE-Build-12749/source-prep.txt
+ [[ false == \t\r\u\e ]]
+ mkdir -p maven ivy
+ [[ git = \s\v\n ]]
+ [[ git = \g\i\t ]]
+ [[ -z master ]]
+ [[ -d apache-github-source-source ]]
+ [[ ! -d apache-github-source-source/.git ]]
+ [[ ! -d apache-github-source-source ]]
+ date '+%Y-%m-%d %T.%3N'
2018-07-21 02:21:50.769
+ cd apache-github-source-source
+ git fetch origin
+ git reset --hard HEAD
HEAD is now at e569ef0 HIVE-4367: enhance TRUNCATE syntax to drop data of
external table (Jason Dere, reviewed by Teddy Choi)
+ git clean -f -d
Removing standalone-metastore/metastore-server/src/gen/
+ git checkout master
Already on 'master'
Your branch is up-to-date with 'origin/master'.
+ git reset --hard origin/master
HEAD is now at e569ef0 HIVE-4367: enhance TRUNCATE syntax to drop data of
external table (Jason Dere, reviewed by Teddy Choi)
+ git merge --ff-only origin/master
Already up-to-date.
+ date '+%Y-%m-%d %T.%3N'
2018-07-21 02:21:52.214
+ rm -rf ../yetus_PreCommit-HIVE-Build-12749
+ mkdir ../yetus_PreCommit-HIVE-Build-12749
+ git gc
+ cp -R . ../yetus_PreCommit-HIVE-Build-12749
+ mkdir /data/hiveptest/logs/PreCommit-HIVE-Build-12749/yetus
+ patchCommandPath=/data/hiveptest/working/scratch/smart-apply-patch.sh
+ patchFilePath=/data/hiveptest/working/scratch/build.patch
+ [[ -f /data/hiveptest/working/scratch/build.patch ]]
+ chmod +x /data/hiveptest/working/scratch/smart-apply-patch.sh
+ /data/hiveptest/working/scratch/smart-apply-patch.sh
/data/hiveptest/working/scratch/build.patch
error: patch failed: itests/src/test/resources/testconfiguration.properties:31
Falling back to three-way merge...
Applied patch to 'itests/src/test/resources/testconfiguration.properties' with
conflicts.
Going to apply patch with: git apply -p0
/data/hiveptest/working/scratch/build.patch:56: trailing whitespace.
/data/hiveptest/working/scratch/build.patch:251: trailing whitespace.
Map 2
/data/hiveptest/working/scratch/build.patch:301: trailing whitespace.
Map 1
/data/hiveptest/working/scratch/build.patch:571: trailing whitespace.
Map 1
/data/hiveptest/working/scratch/build.patch:582: trailing whitespace.
Reducer 2
error: patch failed: itests/src/test/resources/testconfiguration.properties:31
Falling back to three-way merge...
Applied patch to 'itests/src/test/resources/testconfiguration.properties' with
conflicts.
U itests/src/test/resources/testconfiguration.properties
warning: squelched 1 whitespace error
warning: 6 lines add whitespace errors.
+ result=1
+ '[' 1 -ne 0 ']'
+ rm -rf yetus_PreCommit-HIVE-Build-12749
+ exit 1
'
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12868568 - PreCommit-HIVE-Build
> Hive on Spark generates incorrect plan and result with window function and
> lateral view
> ---
>
> Key: HIVE-16668
> URL: https://issues.apache.org/jira/browse/HIVE-16668
> Project: Hive
> Issue Type: Bug
> Components: Spark
>Reporter: Chao Sun
>Assignee: Chao Sun
>Priority: Major
> Attachments: HIVE-16668.1.patch, HIVE-16668.2.patch,
> HIVE-16668.3.patch
>
>
> To reproduce:
> {code}
> create table t1 (a string);
> create table t2 (a array);
> create table dummy (a string);
> insert into table dummy values ("a");
> insert into t1 values ("1"), ("2");
>
[jira] [Commented] (HIVE-16668) Hive on Spark generates incorrect plan and result with window function and lateral view
[
https://issues.apache.org/jira/browse/HIVE-16668?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16550943#comment-16550943
]
Sahil Takiar commented on HIVE-16668:
-
[~csun] do you know if this is still an issue? Is there anything else that
needs to be done for this JIRA (besides probably a rebase) before merging it?
> Hive on Spark generates incorrect plan and result with window function and
> lateral view
> ---
>
> Key: HIVE-16668
> URL: https://issues.apache.org/jira/browse/HIVE-16668
> Project: Hive
> Issue Type: Bug
> Components: Spark
>Reporter: Chao Sun
>Assignee: Chao Sun
>Priority: Major
> Attachments: HIVE-16668.1.patch, HIVE-16668.2.patch,
> HIVE-16668.3.patch
>
>
> To reproduce:
> {code}
> create table t1 (a string);
> create table t2 (a array);
> create table dummy (a string);
> insert into table dummy values ("a");
> insert into t1 values ("1"), ("2");
> insert into t2 select array("1", "2", "3", "4") from dummy;
> set hive.auto.convert.join.noconditionaltask.size=3;
> explain
> with tt1 as (
> select a as id, count(*) over () as count
> from t1
> ),
> tt2 as (
> select id
> from t2
> lateral view outer explode(a) a_tbl as id
> )
> select tt1.count
> from tt1 join tt2 on tt1.id = tt2.id;
> {code}
> For Hive on Spark, the plan is:
> {code}
> STAGE DEPENDENCIES:
> Stage-2 is a root stage
> Stage-1 depends on stages: Stage-2
> Stage-0 depends on stages: Stage-1
> STAGE PLANS:
> Stage: Stage-2
> Spark
> Edges:
> Reducer 2 <- Map 1 (PARTITION-LEVEL SORT, 3), Map 1 (PARTITION-LEVEL
> SORT, 3)
> DagName: chao_20170515133259_de9e0583-da24-4399-afc8-b881dfef0469:9
> Vertices:
> Map 1
> Map Operator Tree:
> TableScan
> alias: t1
> Statistics: Num rows: 2 Data size: 2 Basic stats: COMPLETE
> Column stats: NONE
> Reduce Output Operator
> key expressions: 0 (type: int)
> sort order: +
> Map-reduce partition columns: 0 (type: int)
> Statistics: Num rows: 2 Data size: 2 Basic stats:
> COMPLETE Column stats: NONE
> value expressions: a (type: string)
> Reducer 2
> Local Work:
> Map Reduce Local Work
> Reduce Operator Tree:
> Select Operator
> expressions: VALUE._col0 (type: string)
> outputColumnNames: _col0
> Statistics: Num rows: 2 Data size: 2 Basic stats: COMPLETE
> Column stats: NONE
> PTF Operator
> Function definitions:
> Input definition
> input alias: ptf_0
> output shape: _col0: string
> type: WINDOWING
> Windowing table definition
> input alias: ptf_1
> name: windowingtablefunction
> order by: 0 ASC NULLS FIRST
> partition by: 0
> raw input shape:
> window functions:
> window function definition
> alias: count_window_0
> name: count
> window function: GenericUDAFCountEvaluator
> window frame: PRECEDING(MAX)~FOLLOWING(MAX)
> isStar: true
> Statistics: Num rows: 2 Data size: 2 Basic stats: COMPLETE
> Column stats: NONE
> Filter Operator
> predicate: _col0 is not null (type: boolean)
> Statistics: Num rows: 2 Data size: 2 Basic stats:
> COMPLETE Column stats: NONE
> Select Operator
> expressions: _col0 (type: string), count_window_0
> (type: bigint)
> outputColumnNames: _col0, _col1
> Statistics: Num rows: 2 Data size: 2 Basic stats:
> COMPLETE Column stats: NONE
> Spark HashTable Sink Operator
> keys:
> 0 _col0 (type: string)
> 1 _col0 (type: string)
> Reduce Output Operator
> key expressions: _col0 (type: string)
> sort order: +
> Map-reduce partition columns: _col0 (type: string)
> Statistics: Num rows: 2 Data size: 2 Basic stats:
> COMPLETE Column stats: NONE
> value expressions: _col1 (type: bigint)
> Stage: Stage-1
> Spark
[jira] [Commented] (HIVE-16668) Hive on Spark generates incorrect plan and result with window function and lateral view
[
https://issues.apache.org/jira/browse/HIVE-16668?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16014719#comment-16014719
]
Hive QA commented on HIVE-16668:
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12868568/HIVE-16668.3.patch
{color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified.
{color:red}ERROR:{color} -1 due to 4 failed/errored test(s), 10731 tests
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[table_nonprintable]
(batchId=141)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_if_expr]
(batchId=145)
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[explainanalyze_3]
(batchId=97)
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[explainuser_3]
(batchId=97)
{noformat}
Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/5309/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/5309/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-5309/
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 4 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12868568 - PreCommit-HIVE-Build
> Hive on Spark generates incorrect plan and result with window function and
> lateral view
> ---
>
> Key: HIVE-16668
> URL: https://issues.apache.org/jira/browse/HIVE-16668
> Project: Hive
> Issue Type: Bug
> Components: Spark
>Reporter: Chao Sun
>Assignee: Chao Sun
> Attachments: HIVE-16668.1.patch, HIVE-16668.2.patch,
> HIVE-16668.3.patch
>
>
> To reproduce:
> {code}
> create table t1 (a string);
> create table t2 (a array);
> create table dummy (a string);
> insert into table dummy values ("a");
> insert into t1 values ("1"), ("2");
> insert into t2 select array("1", "2", "3", "4") from dummy;
> set hive.auto.convert.join.noconditionaltask.size=3;
> explain
> with tt1 as (
> select a as id, count(*) over () as count
> from t1
> ),
> tt2 as (
> select id
> from t2
> lateral view outer explode(a) a_tbl as id
> )
> select tt1.count
> from tt1 join tt2 on tt1.id = tt2.id;
> {code}
> For Hive on Spark, the plan is:
> {code}
> STAGE DEPENDENCIES:
> Stage-2 is a root stage
> Stage-1 depends on stages: Stage-2
> Stage-0 depends on stages: Stage-1
> STAGE PLANS:
> Stage: Stage-2
> Spark
> Edges:
> Reducer 2 <- Map 1 (PARTITION-LEVEL SORT, 3), Map 1 (PARTITION-LEVEL
> SORT, 3)
> DagName: chao_20170515133259_de9e0583-da24-4399-afc8-b881dfef0469:9
> Vertices:
> Map 1
> Map Operator Tree:
> TableScan
> alias: t1
> Statistics: Num rows: 2 Data size: 2 Basic stats: COMPLETE
> Column stats: NONE
> Reduce Output Operator
> key expressions: 0 (type: int)
> sort order: +
> Map-reduce partition columns: 0 (type: int)
> Statistics: Num rows: 2 Data size: 2 Basic stats:
> COMPLETE Column stats: NONE
> value expressions: a (type: string)
> Reducer 2
> Local Work:
> Map Reduce Local Work
> Reduce Operator Tree:
> Select Operator
> expressions: VALUE._col0 (type: string)
> outputColumnNames: _col0
> Statistics: Num rows: 2 Data size: 2 Basic stats: COMPLETE
> Column stats: NONE
> PTF Operator
> Function definitions:
> Input definition
> input alias: ptf_0
> output shape: _col0: string
> type: WINDOWING
> Windowing table definition
> input alias: ptf_1
> name: windowingtablefunction
> order by: 0 ASC NULLS FIRST
> partition by: 0
> raw input shape:
> window functions:
> window function definition
> alias: count_window_0
> name: count
> window function: GenericUDAFCountEvaluator
> window frame: PRECEDING(MAX)~FOLLOWING(MAX)
> isStar: true
> Statistics: Num rows: 2 Data size: 2 Basic stats:
[jira] [Commented] (HIVE-16668) Hive on Spark generates incorrect plan and result with window function and lateral view
[
https://issues.apache.org/jira/browse/HIVE-16668?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16014296#comment-16014296
]
Hive QA commented on HIVE-16668:
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12868538/HIVE-16668.2.patch
{color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified.
{color:red}ERROR:{color} -1 due to 4 failed/errored test(s), 10721 tests
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[lvj_ptf] (batchId=15)
org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[table_nonprintable]
(batchId=141)
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[explainanalyze_3]
(batchId=97)
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[explainuser_3]
(batchId=97)
{noformat}
Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/5304/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/5304/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-5304/
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 4 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12868538 - PreCommit-HIVE-Build
> Hive on Spark generates incorrect plan and result with window function and
> lateral view
> ---
>
> Key: HIVE-16668
> URL: https://issues.apache.org/jira/browse/HIVE-16668
> Project: Hive
> Issue Type: Bug
> Components: Spark
>Reporter: Chao Sun
>Assignee: Chao Sun
> Attachments: HIVE-16668.1.patch, HIVE-16668.2.patch
>
>
> To reproduce:
> {code}
> create table t1 (a string);
> create table t2 (a array);
> create table dummy (a string);
> insert into table dummy values ("a");
> insert into t1 values ("1"), ("2");
> insert into t2 select array("1", "2", "3", "4") from dummy;
> set hive.auto.convert.join.noconditionaltask.size=3;
> explain
> with tt1 as (
> select a as id, count(*) over () as count
> from t1
> ),
> tt2 as (
> select id
> from t2
> lateral view outer explode(a) a_tbl as id
> )
> select tt1.count
> from tt1 join tt2 on tt1.id = tt2.id;
> {code}
> For Hive on Spark, the plan is:
> {code}
> STAGE DEPENDENCIES:
> Stage-2 is a root stage
> Stage-1 depends on stages: Stage-2
> Stage-0 depends on stages: Stage-1
> STAGE PLANS:
> Stage: Stage-2
> Spark
> Edges:
> Reducer 2 <- Map 1 (PARTITION-LEVEL SORT, 3), Map 1 (PARTITION-LEVEL
> SORT, 3)
> DagName: chao_20170515133259_de9e0583-da24-4399-afc8-b881dfef0469:9
> Vertices:
> Map 1
> Map Operator Tree:
> TableScan
> alias: t1
> Statistics: Num rows: 2 Data size: 2 Basic stats: COMPLETE
> Column stats: NONE
> Reduce Output Operator
> key expressions: 0 (type: int)
> sort order: +
> Map-reduce partition columns: 0 (type: int)
> Statistics: Num rows: 2 Data size: 2 Basic stats:
> COMPLETE Column stats: NONE
> value expressions: a (type: string)
> Reducer 2
> Local Work:
> Map Reduce Local Work
> Reduce Operator Tree:
> Select Operator
> expressions: VALUE._col0 (type: string)
> outputColumnNames: _col0
> Statistics: Num rows: 2 Data size: 2 Basic stats: COMPLETE
> Column stats: NONE
> PTF Operator
> Function definitions:
> Input definition
> input alias: ptf_0
> output shape: _col0: string
> type: WINDOWING
> Windowing table definition
> input alias: ptf_1
> name: windowingtablefunction
> order by: 0 ASC NULLS FIRST
> partition by: 0
> raw input shape:
> window functions:
> window function definition
> alias: count_window_0
> name: count
> window function: GenericUDAFCountEvaluator
> window frame: PRECEDING(MAX)~FOLLOWING(MAX)
> isStar: true
> Statistics: Num rows: 2 Data size: 2 Basic stats: COMPLETE
> Column stats: NONE
>
[jira] [Commented] (HIVE-16668) Hive on Spark generates incorrect plan and result with window function and lateral view
[
https://issues.apache.org/jira/browse/HIVE-16668?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16013144#comment-16013144
]
Hive QA commented on HIVE-16668:
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12868374/HIVE-16668.1.patch
{color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified.
{color:red}ERROR:{color} -1 due to 9 failed/errored test(s), 10720 tests
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[auto_sortmerge_join_2]
(batchId=46)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[lvj_ptf] (batchId=15)
org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[table_nonprintable]
(batchId=141)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_if_expr]
(batchId=145)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_join30]
(batchId=150)
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[explainanalyze_3]
(batchId=97)
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[explainuser_3]
(batchId=97)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[union17]
(batchId=130)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[union31]
(batchId=100)
{noformat}
Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/5288/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/5288/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-5288/
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 9 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12868374 - PreCommit-HIVE-Build
> Hive on Spark generates incorrect plan and result with window function and
> lateral view
> ---
>
> Key: HIVE-16668
> URL: https://issues.apache.org/jira/browse/HIVE-16668
> Project: Hive
> Issue Type: Bug
> Components: Spark
>Reporter: Chao Sun
>Assignee: Chao Sun
> Attachments: HIVE-16668.1.patch
>
>
> To reproduce:
> {code}
> create table t1 (a string);
> create table t2 (a array);
> create table dummy (a string);
> insert into table dummy values ("a");
> insert into t1 values ("1"), ("2");
> insert into t2 select array("1", "2", "3", "4") from dummy;
> set hive.auto.convert.join.noconditionaltask.size=3;
> explain
> with tt1 as (
> select a as id, count(*) over () as count
> from t1
> ),
> tt2 as (
> select id
> from t2
> lateral view outer explode(a) a_tbl as id
> )
> select tt1.count
> from tt1 join tt2 on tt1.id = tt2.id;
> {code}
> For Hive on Spark, the plan is:
> {code}
> STAGE DEPENDENCIES:
> Stage-2 is a root stage
> Stage-1 depends on stages: Stage-2
> Stage-0 depends on stages: Stage-1
> STAGE PLANS:
> Stage: Stage-2
> Spark
> Edges:
> Reducer 2 <- Map 1 (PARTITION-LEVEL SORT, 3), Map 1 (PARTITION-LEVEL
> SORT, 3)
> DagName: chao_20170515133259_de9e0583-da24-4399-afc8-b881dfef0469:9
> Vertices:
> Map 1
> Map Operator Tree:
> TableScan
> alias: t1
> Statistics: Num rows: 2 Data size: 2 Basic stats: COMPLETE
> Column stats: NONE
> Reduce Output Operator
> key expressions: 0 (type: int)
> sort order: +
> Map-reduce partition columns: 0 (type: int)
> Statistics: Num rows: 2 Data size: 2 Basic stats:
> COMPLETE Column stats: NONE
> value expressions: a (type: string)
> Reducer 2
> Local Work:
> Map Reduce Local Work
> Reduce Operator Tree:
> Select Operator
> expressions: VALUE._col0 (type: string)
> outputColumnNames: _col0
> Statistics: Num rows: 2 Data size: 2 Basic stats: COMPLETE
> Column stats: NONE
> PTF Operator
> Function definitions:
> Input definition
> input alias: ptf_0
> output shape: _col0: string
> type: WINDOWING
> Windowing table definition
> input alias: ptf_1
> name: windowingtablefunction
> order by: 0 ASC NULLS FIRST
> partition by: 0
> raw input shape:
> window functions:
>
