[ 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: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