DylanGuedes commented on issue #25331: [SPARK-27768][SQL] Support Infinity/NaN-related float/double literals case-insensitively URL: https://github.com/apache/spark/pull/25331#issuecomment-521383406 Hey @dilipbiswal , I get the following error for inline tables (although it work great for normal tables): ```sql SELECT a, b, SUM(b) OVER(ORDER BY A ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) FROM (VALUES(1,1),(2,2),(3,'NaN'),(4,3),(5,4)) t(a,b); ``` ``` org.apache.spark.sql.AnalysisException incompatible types found in column col2 for inline table; line 3 pos 6 ``` However, as I said, it works fine for normal tables: ```sql insert into numerics values (0, 'NaN', 'NaN', '-1000'); select f_float4, sum(f_float4) over (order by f_float8 rows between 1 preceding and current row) from numerics; ``` Do you know if this is related to me making use of a window function or it is related to case-insensitively NaN for inline tables?
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
