You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@datafusion.apache.org by "andygrove (via GitHub)" <gi...@apache.org> on 2024/05/28 14:58:36 UTC

[I] bug: log10 returns different results than Spark in some cases [datafusion-comet]

andygrove opened a new issue, #484:
URL: https://github.com/apache/datafusion-comet/issues/484

   ### Describe the bug
   
   I discovered this bug using [Comet Fuzz](https://github.com/apache/datafusion-comet/pull/472).
   
   ```sql
   SELECT Log10(c6) FROM test1
   ```
   
   [ERROR] Spark and Comet produced different results.
   
   ### Spark Plan
   ```
   *(1) Project [LOG10(cast(c6#26 as double)) AS LOG10(c6)#9078]
   +- *(1) ColumnarToRow
      +- FileScan parquet [c6#26] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/Users/andy/git/apple/comet-fuzz/test1.parquet], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<c6:tinyint>
   
   ```
   ### Comet Plan
   ```
   *(1) ColumnarToRow
   +- CometProject [LOG10(c6)#9082], [LOG10(cast(c6#26 as double)) AS LOG10(c6)#9082]
      +- CometScan parquet [c6#26] Batched: true, DataFilters: [], Format: CometParquet, Location: InMemoryFileIndex(1 paths)[file:/Users/andy/git/apple/comet-fuzz/test1.parquet], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<c6:tinyint>
   
   ```
   ### Results 
   Spark produced 200 rows and Comet produced 200 rows.
   First difference at row 0:
   Spark: `[0.0]`
   Comet: `[-Infinity]`
   
   ### Steps to reproduce
   
   _No response_
   
   ### Expected behavior
   
   _No response_
   
   ### Additional context
   
   _No response_


-- 
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.

To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org

Re: [I] bug: log10 returns different results than Spark in some cases [datafusion-comet]

Posted by "andygrove (via GitHub)" <gi...@apache.org>.
andygrove closed issue #484: bug: log10 returns different results than Spark in some cases
URL: https://github.com/apache/datafusion-comet/issues/484


-- 
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.

To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org

Re: [I] bug: log10 returns different results than Spark in some cases [datafusion-comet]

Posted by "andygrove (via GitHub)" <gi...@apache.org>.
andygrove commented on issue #484:
URL: https://github.com/apache/datafusion-comet/issues/484#issuecomment-2144052886

   This is likely a duplicate of https://github.com/apache/datafusion-comet/issues/485


-- 
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.

To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org