You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@arrow.apache.org by GitBox <gi...@apache.org> on 2022/11/15 11:15:24 UTC

[GitHub] [arrow-datafusion] alamb opened a new issue, #4220: Bug displaying fractional seconds in `IntervalMonthDayNano`

alamb opened a new issue, #4220:
URL: https://github.com/apache/arrow-datafusion/issues/4220

           thank you @Jefffrey 
   
   there's a bug while displaying IntervalMonthDayNano
   ```bash
   ❯ select interval '0.0001 second';
   +----------------------------------------------------+
   | IntervalMonthDayNano("100000")                     |
   +----------------------------------------------------+
   | 0 years 0 mons 0 days 0 hours 0 mins 0.100000 secs |
   +----------------------------------------------------+
   1 row in set. Query took 0.002 seconds.
   ```
   i checked the underline value it's correct `(month: 0, day: 0, nanos: 100000)`
   i think this is the display issue
   
   _Originally posted by @waitingkuo in https://github.com/apache/arrow-datafusion/pull/4186#pullrequestreview-1178643913_
         


-- 
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@arrow.apache.org.apache.org

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


[GitHub] [arrow-datafusion] waitingkuo commented on issue #4220: Bug displaying fractional seconds in `IntervalMonthDayNano`

Posted by GitBox <gi...@apache.org>.
waitingkuo commented on issue #4220:
URL: https://github.com/apache/arrow-datafusion/issues/4220#issuecomment-1316551423

   @alamb i submit another issue since negative value isn't pure display issue


-- 
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@arrow.apache.org

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


[GitHub] [arrow-datafusion] alamb commented on issue #4220: Bug displaying fractional seconds in `IntervalMonthDayNano`

Posted by GitBox <gi...@apache.org>.
alamb commented on issue #4220:
URL: https://github.com/apache/arrow-datafusion/issues/4220#issuecomment-1315165042

   Oh, I think this will be fixed by https://github.com/apache/arrow-rs/pull/3093 (in the next release after arrow 27.0.0)


-- 
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@arrow.apache.org

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


[GitHub] [arrow-datafusion] Jefffrey commented on issue #4220: Bug displaying fractional seconds in `IntervalMonthDayNano`

Posted by "Jefffrey (via GitHub)" <gi...@apache.org>.
Jefffrey commented on issue #4220:
URL: https://github.com/apache/arrow-datafusion/issues/4220#issuecomment-1400117839

   Resolved by https://github.com/apache/arrow-rs/pull/3491 via arrow-rs v31 update https://github.com/apache/arrow-datafusion/pull/4927
   
   ```sql
   DataFusion CLI v16.0.0
   ❯ select interval '-0.0001 second';
   +--------------------------------------------------------+
   | IntervalMonthDayNano("18446744073709451616")           |
   +--------------------------------------------------------+
   | 0 years 0 mons 0 days 0 hours 0 mins -0.000100000 secs |
   +--------------------------------------------------------+
   1 row in set. Query took 0.002 seconds.
   ❯
   ```


-- 
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@arrow.apache.org

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


[GitHub] [arrow-datafusion] alamb commented on issue #4220: Bug displaying fractional seconds in `IntervalMonthDayNano`

Posted by "alamb (via GitHub)" <gi...@apache.org>.
alamb commented on issue #4220:
URL: https://github.com/apache/arrow-datafusion/issues/4220#issuecomment-1400168562

   ❤️ 


-- 
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@arrow.apache.org

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


[GitHub] [arrow-datafusion] alamb closed issue #4220: Bug displaying fractional seconds in `IntervalMonthDayNano`

Posted by "alamb (via GitHub)" <gi...@apache.org>.
alamb closed issue #4220: Bug displaying fractional seconds in `IntervalMonthDayNano` 
URL: https://github.com/apache/arrow-datafusion/issues/4220


-- 
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@arrow.apache.org

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


[GitHub] [arrow-datafusion] waitingkuo commented on issue #4220: Bug displaying fractional seconds in `IntervalMonthDayNano`

Posted by GitBox <gi...@apache.org>.
waitingkuo commented on issue #4220:
URL: https://github.com/apache/arrow-datafusion/issues/4220#issuecomment-1316477074

   @alamb just found another bug while displaying fraction seconds
   
   ```bash
   ❯ select interval '-0.0001 second';
   +-------------------------------------------------------+
   | IntervalMonthDayNano("-100000")                       |
   +-------------------------------------------------------+
   | 0 years -1 mons -1 days 0 hours 0 mins 0.-100000 secs |
   +-------------------------------------------------------+
   1 row in set. Query took 0.002 seconds.
   ```
   do you preferred submit another issue? I think it's arrow-rs's prettyprint issue as well


-- 
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@arrow.apache.org

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