[ 
https://issues.apache.org/jira/browse/SPARK-34673?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17306772#comment-17306772
 ] 

Ankit Raj Boudh edited comment on SPARK-34673 at 3/23/21, 4:54 AM:
-------------------------------------------------------------------

[~dongjoon], I have tried with Spar 3.1.1 also and found there difference 
during creation of Parsed Logical Plan

 

Spar 3.1.1 Parsed Logical Plan: 
{code:java}
== Parsed Logical Plan == 'CreateViewStatement [temp1_33], select 20E2, 
'Project [unresolvedalias(2000.0, None)], false, false, LocalTempView{code}
Spar 2.4 Parsed Logical Plan: 
{code:java}
== Parsed Logical Plan == CreateViewCommand `temp1_33`, select 20E2, false, 
false, LocalTempView    +- 'Project [unresolvedalias(2.0E+3, None)]       +- 
OneRowRelation {code}


was (Author: ankitraj):
[~dongjoon], I have tried with Spar 3.1.1 also and found there difference 
during creation of Parsed Logical Plan

 

Spar 3.1.1 Parsed Logical Plan: 
{code:java}
== Parsed Logical Plan == 'CreateViewStatement [temp1_33], select 20E2, 
'Project [unresolvedalias(2000.0, None)], false, false, LocalTempView{code}
Spar 2.4 Parsed Logical Plan: 
{code:java}
== Parsed Logical Plan == CreateViewCommand `temp1_33`, select 20E2, false, 
false, LocalTempView    +- 'Project [unresolvedalias(2.0E+3, None)]       +- 
OneRowRelation {code}

> 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

Reply via email to