[
https://issues.apache.org/jira/browse/SPARK-34673?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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
