[jira] [Comment Edited] (SPARK-34673) 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)
[
https://issues.apache.org/jira/browse/SPARK-34673?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17306772#comment-17306772
]
Ankit Raj Boudh edited comment on SPARK-34673 at 3/23/21, 5:02 AM:
---
[~dongjoon], I have tried with Spar 3.1.1 also and found there is 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
[jira] [Comment Edited] (SPARK-34673) 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)
[
https://issues.apache.org/jira/browse/SPARK-34673?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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
[jira] [Comment Edited] (SPARK-34673) 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)
[
https://issues.apache.org/jira/browse/SPARK-34673?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17306703#comment-17306703
]
Ankit Raj Boudh edited comment on SPARK-34673 at 3/23/21, 4:50 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*:
{code:java}
== 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
{code}
Spark-2.4 branch plans for this query (create temporary view temp1_33 as select
*20E2*:
{code:java}
== 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
{code}
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*:
{code:java}
== 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
{code}
Spark-2.4 branch plans for this query (create temporary view temp1_33 as select
*20E2*:
{code:java}
== 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
{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)
[jira] [Comment Edited] (SPARK-34673) 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)
[
https://issues.apache.org/jira/browse/SPARK-34673?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17306703#comment-17306703
]
Ankit Raj Boudh edited comment on SPARK-34673 at 3/23/21, 4:45 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*:
{code:java}
== 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
{code}
Spark-2.4 branch plans for this query (create temporary view temp1_33 as select
*20E2*:
{code:java}
== 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
{code}
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)
[jira] [Comment Edited] (SPARK-34673) 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)
[ https://issues.apache.org/jira/browse/SPARK-34673?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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) -
[jira] [Comment Edited] (SPARK-34673) 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)
[ https://issues.apache.org/jira/browse/SPARK-34673?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17306703#comment-17306703 ] Ankit Raj Boudh edited comment on SPARK-34673 at 3/23/21, 4:43 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) -
[jira] [Comment Edited] (SPARK-34673) 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)
[ https://issues.apache.org/jira/browse/SPARK-34673?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17306703#comment-17306703 ] Ankit Raj Boudh edited comment on SPARK-34673 at 3/23/21, 2:38 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 `kajal_1`, select *20E2*, false, false, LocalTempView +- 'Project [unresolvedalias(*2.0E+3*, None)] +- OneRowRelation == Analyzed Logical Plan == CreateViewCommand `kajal_1`, select 20E2, false, false, LocalTempView +- 'Project [unresolvedalias(2.0E+3, None)] +- OneRowRelation == Optimized Logical Plan == CreateViewCommand `kajal_1`, select 20E2, false, false, LocalTempView +- 'Project [unresolvedalias(2.0E+3, None)] +- OneRowRelation == Physical Plan == Execute CreateViewCommand +- CreateViewCommand `kajal_1`, 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
[jira] [Comment Edited] (SPARK-34673) 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)
[ https://issues.apache.org/jira/browse/SPARK-34673?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17306703#comment-17306703 ] Ankit Raj Boudh edited comment on SPARK-34673 at 3/23/21, 2:36 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 `kajal_1`, select *20E2*, false, false, LocalTempView +- 'Project [unresolvedalias(*2.0E+3*, None)] +- OneRowRelation == Analyzed Logical Plan == CreateViewCommand `kajal_1`, select 20E2, false, false, LocalTempView +- 'Project [unresolvedalias(2.0E+3, None)] +- OneRowRelation == Optimized Logical Plan == CreateViewCommand `kajal_1`, select 20E2, false, false, LocalTempView +- 'Project [unresolvedalias(2.0E+3, None)] +- OneRowRelation == Physical Plan == Execute CreateViewCommand +- CreateViewCommand `kajal_1`, 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*;): > 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
[jira] [Comment Edited] (SPARK-34673) 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)
[ https://issues.apache.org/jira/browse/SPARK-34673?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17306703#comment-17306703 ] Ankit Raj Boudh edited comment on SPARK-34673 at 3/23/21, 2:35 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*;): was (Author: ankitraj): I can see the difference b/w plan which is creating in spark master branch and spark branch-2.4 > 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
[jira] [Comment Edited] (SPARK-34673) 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)
[ https://issues.apache.org/jira/browse/SPARK-34673?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17304736#comment-17304736 ] Ankit Raj Boudh edited comment on SPARK-34673 at 3/19/21, 9:10 AM: --- [~dongjoon] and [~hyukjin.kwon] , I have checked this case in sparl-sql and i found we are allow to create temporary view with Negative scale *decimal(2, -2)* and able to query the data from temporary table. !Screenshot 2021-03-19 at 1.33.54 PM.png! I think we should not allow to create view with negative scale *decimal(2, -2)*. I have checked master branch behaviour and found during creation for temporary view data_type is showing *double*. was (Author: ankitraj): [~dongjoon] and [~hyukjin.kwon] , I have checked this case in sparl-sql and i found we are allow to create temporary view with Negative scale *decimal(2, -2)* and able to query the data from temporary table. !Screenshot 2021-03-19 at 1.33.54 PM.png! I think it's wrong. I have checked master branch behaviour and found during creation for temporary view data_type is showing *double*. > 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
[jira] [Comment Edited] (SPARK-34673) 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)
[ https://issues.apache.org/jira/browse/SPARK-34673?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17304736#comment-17304736 ] Ankit Raj Boudh edited comment on SPARK-34673 at 3/19/21, 9:05 AM: --- [~dongjoon] and [~hyukjin.kwon] , I have checked this case in sparl-sql and i found we are allow to create temporary view with Negative scale *decimal(2, -2)* and able to query the data from temporary table. !Screenshot 2021-03-19 at 1.33.54 PM.png! I think it's wrong. I have checked master branch behaviour and found during creation for temporary view data_type is showing *double*. was (Author: ankitraj): [~hyukjin.kwon] , I have checked this case in sparl-sql and i found we are allow to create temporary view with Negative scale *decimal(2, -2)* and able to query the data from temporary table. !Screenshot 2021-03-19 at 1.33.54 PM.png! I think it's wrong. I have checked master branch behaviour and found during creation for temporary view data_type is showing *double*. > 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
[jira] [Comment Edited] (SPARK-34673) 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)
[ https://issues.apache.org/jira/browse/SPARK-34673?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17304736#comment-17304736 ] Ankit Raj Boudh edited comment on SPARK-34673 at 3/19/21, 9:03 AM: --- [~hyukjin.kwon] , I have checked this case in sparl-sql and i found we are allow to create temporary view with Negative scale *decimal(2, -2)* and able to query the data from temporary table. !Screenshot 2021-03-19 at 1.33.54 PM.png! I think it's wrong. I have checked master branch behaviour and found during creation for temporary view data_type is showing *double*. was (Author: ankitraj): [~hyukjin.kwon] , I have checked this case in sparl-sql and i found we are allow to create temporary view with Negative scale *decimal(2, -2)* and able to query the data from temporary table. !Screenshot 2021-03-19 at 1.33.54 PM.png! I think it's wrong. > 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
[jira] [Comment Edited] (SPARK-34673) 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)
[
https://issues.apache.org/jira/browse/SPARK-34673?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17298896#comment-17298896
]
Ankit Raj Boudh edited comment on SPARK-34673 at 3/10/21, 3:18 PM:
---
[~hyukjin.kwon], Here is the testing scenario
this is in hive beeline mode in spark branch-2.4
{code:java}
1. create temporary view kajal1 as select * from values ("t2", 20E2) as t2(t2,
t2i);
2. select * from kajal1;
{code}
!Screenshot 2021-03-10 at 8.47.00 PM.png!
was (Author: ankitraj):
[~hyukjin.kwon], Here is the testing scenario
this is in hive beeline mode
{code:java}
1. create temporary view kajal1 as select * from values ("t2", 20E2) as t2(t2,
t2i);
2. select * from kajal1;
{code}
!Screenshot 2021-03-10 at 8.47.00 PM.png!
> 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
>
>
> 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
[jira] [Comment Edited] (SPARK-34673) 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)
[ https://issues.apache.org/jira/browse/SPARK-34673?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17298819#comment-17298819 ] Ankit Raj Boudh edited comment on SPARK-34673 at 3/10/21, 1:18 PM: --- [~hyukjin.kwon], i will raise pr for this soon. was (Author: ankitraj): [~hyukjin.kwon], i will raise pr for this. > 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 > > 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
