[
https://issues.apache.org/jira/browse/SPARK-34673?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17306703#comment-17306703
]
Ankit Raj Boudh edited comment on SPARK-34673 at 3/23/21, 4:44 AM:
-------------------------------------------------------------------
I can see the difference b/w plan which is creating in spark master branch and
spark branch-2.4
Spark-master branch plans for this query (create temporary view temp1_33 as
select *20E2*:
== Parsed Logical Plan ==
'CreateViewStatement [temp1_33], select *20E2*, 'Project
[unresolvedalias(2000.0, None)], false, false, LocalTempView
== Analyzed Logical Plan ==
CreateViewCommand `temp1_33`, select 20E2, false, false, LocalTempView
+- 'Project [unresolvedalias(2000.0, None)]
+- OneRowRelation
== Optimized Logical Plan ==
CreateViewCommand `temp1_33`, select 20E2, false, false, LocalTempView
+- 'Project [unresolvedalias(2000.0, None)]
+- OneRowRelation
== Physical Plan ==
Execute CreateViewCommand
+- CreateViewCommand `temp1_33`, select 20E2, false, false, LocalTempView
+- 'Project [unresolvedalias(2000.0, None)]
+- OneRowRelation
Spark-2.4 branch plans for this query (create temporary view temp1_33 as select
*20E2*:
== Parsed Logical Plan ==
CreateViewCommand `temp1_33`, select *20E2*, false, false, LocalTempView
+- 'Project [unresolvedalias(*2.0E+3*, None)]
+- OneRowRelation
== Analyzed Logical Plan ==
CreateViewCommand `temp1_33`, select 20E2, false, false, LocalTempView
+- 'Project [unresolvedalias(2.0E+3, None)]
+- OneRowRelation
== Optimized Logical Plan ==
CreateViewCommand `temp1_33`, select 20E2, false, false, LocalTempView
+- 'Project [unresolvedalias(2.0E+3, None)]
+- OneRowRelation
== Physical Plan ==
Execute CreateViewCommand
+- CreateViewCommand `temp1_33`, select 20E2, false, false, LocalTempView
+- 'Project [unresolvedalias(2.0E+3, None)]
+- OneRowRelation
was (Author: ankitraj):
I can see the difference b/w plan which is creating in spark master branch and
spark branch-2.4
Spark-master branch plans for this query (create temporary view temp1_33 as
select *20E2*:
== Parsed Logical Plan ==
'CreateViewStatement [temp1_33], select *20E2*, 'Project
[unresolvedalias(*2000.0*, None)], false, false, LocalTempView
== Analyzed Logical Plan ==
CreateViewCommand `temp1_33`, select 20E2, false, false, LocalTempView
+- 'Project [unresolvedalias(2000.0, None)]
+- OneRowRelation
== Optimized Logical Plan ==
CreateViewCommand `temp1_33`, select 20E2, false, false, LocalTempView
+- 'Project [unresolvedalias(2000.0, None)]
+- OneRowRelation
== Physical Plan ==
Execute CreateViewCommand
+- CreateViewCommand `temp1_33`, select 20E2, false, false, LocalTempView
+- 'Project [unresolvedalias(2000.0, None)]
+- OneRowRelation
Spark-2.4 branch plans for this query (create temporary view temp1_33 as select
*20E2*:
== Parsed Logical Plan ==
CreateViewCommand `temp1_33`, select *20E2*, false, false, LocalTempView
+- 'Project [unresolvedalias(*2.0E+3*, None)]
+- OneRowRelation
== Analyzed Logical Plan ==
CreateViewCommand `temp1_33`, select 20E2, false, false, LocalTempView
+- 'Project [unresolvedalias(2.0E+3, None)]
+- OneRowRelation
== Optimized Logical Plan ==
CreateViewCommand `temp1_33`, select 20E2, false, false, LocalTempView
+- 'Project [unresolvedalias(2.0E+3, None)]
+- OneRowRelation
== Physical Plan ==
Execute CreateViewCommand
+- CreateViewCommand `temp1_33`, select 20E2, false, false, LocalTempView
+- 'Project [unresolvedalias(2.0E+3, None)]
+- OneRowRelation
> Select queries fail with Error: java.lang.IllegalArgumentException: Error:
> name expected at the position 10 of 'decimal(2,-2)' but '-' is found.
> (state=,code=0)
> -----------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: SPARK-34673
> URL: https://issues.apache.org/jira/browse/SPARK-34673
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 2.4.5
> Environment: Spark 2.4.5
> Reporter: Chetan Bhat
> Priority: Minor
> Attachments: Screenshot 2021-03-10 at 8.47.00 PM.png, Screenshot
> 2021-03-19 at 1.33.54 PM.png
>
>
> Temporary views are created
> Select filter queries are executed on the Temporary views.
>
> [Actual Issue] : - Select queries fail with Error:
> java.lang.IllegalArgumentException: Error: name expected at the position 10
> of 'decimal(2,-2)' but '-' is found. (state=,code=0)
>
> [Expected Result] :- Select queries should be success on Temporary views.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
