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/10/05 20:44:30 UTC
[GitHub] [arrow-datafusion] avantgardnerio opened a new issue, #3729: TPC-H Query 1 has regressed
avantgardnerio opened a new issue, #3729:
URL: https://github.com/apache/arrow-datafusion/issues/3729
**Describe the bug**
When running TPC-H query 1, this is the result:
```
2022-10-05 14:42:16,272 [2560011] WARN - #c.i.d.d.BaseDatabaseErrorHandler$UnknownErrorInfo - Error while executing SQL "select l_returnflag, l_linestatus, sum(l_quantity) as sum_qty, sum(l_extendedprice) as sum_base_price,
sum(l_extendedprice * (1 - l_discount)) as sum_disc_price,
sum(l_extendedprice * (1 - l_discount) * (1 + l_tax)) as sum_charge, avg(l_quantity) as avg_qty,
avg(l_extendedprice) as avg_price, avg(l_discount) as avg_disc, count(*) as count_order
from lineitem
where l_shipdate <= date '1998-09-02'
group by l_returnflag, l_linestatus
order by l_returnflag, l_linestatus": Error executing plan: Error planning job l6OLwA0: DataFusionError(Internal("The type of Timestamp(Nanosecond, None) <= Date32 of binary physical should be same"))
java.sql.SQLException: Error while executing SQL "select l_returnflag, l_linestatus, sum(l_quantity) as sum_qty, sum(l_extendedprice) as sum_base_price,
sum(l_extendedprice * (1 - l_discount)) as sum_disc_price,
sum(l_extendedprice * (1 - l_discount) * (1 + l_tax)) as sum_charge, avg(l_quantity) as avg_qty,
avg(l_extendedprice) as avg_price, avg(l_discount) as avg_disc, count(*) as count_order
from lineitem
where l_shipdate <= date '1998-09-02'
group by l_returnflag, l_linestatus
order by l_returnflag, l_linestatus": Error executing plan: Error planning job l6OLwA0: DataFusionError(Internal("The type of Timestamp(Nanosecond, None) <= Date32 of binary physical should be same"))
```
**To Reproduce**
Run TPC-H query 1.
**Expected behavior**
A result is returned.
--
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] Dandandan commented on issue #3729: TPC-H Query 1 has regressed
Posted by GitBox <gi...@apache.org>.
Dandandan commented on issue #3729:
URL: https://github.com/apache/arrow-datafusion/issues/3729#issuecomment-1295798894
`tests::run_q1` is working on master (just confirmed). Hopefully when the TPC-H regression tests are there we can avoid errors creeping in.
--
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] andygrove commented on issue #3729: TPC-H Query 1 has regressed
Posted by GitBox <gi...@apache.org>.
andygrove commented on issue #3729:
URL: https://github.com/apache/arrow-datafusion/issues/3729#issuecomment-1272356385
Could be related to https://github.com/apache/arrow-datafusion/pull/3764
--
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 #3729: TPC-H Query 1 has regressed
Posted by GitBox <gi...@apache.org>.
alamb commented on issue #3729:
URL: https://github.com/apache/arrow-datafusion/issues/3729#issuecomment-1271824633
We have fixed a few bugs in this coercion area recently -- it "might" work if you try with latest master.
Now that we have the optimizer integration test, it would be great to at least get tests for all tpch querries into that
--
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] Dandandan closed issue #3729: TPC-H Query 1 has regressed
Posted by GitBox <gi...@apache.org>.
Dandandan closed issue #3729: TPC-H Query 1 has regressed
URL: https://github.com/apache/arrow-datafusion/issues/3729
--
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] avantgardnerio commented on issue #3729: TPC-H Query 1 has regressed
Posted by GitBox <gi...@apache.org>.
avantgardnerio commented on issue #3729:
URL: https://github.com/apache/arrow-datafusion/issues/3729#issuecomment-1271826779
I need to look into this again - @andygrove said he ran it and it worked. I think my schema inference may have picked the wrong data type for this timestamp and gotten different results.
--
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 #3729: TPC-H Query 1 has regressed
Posted by GitBox <gi...@apache.org>.
alamb commented on issue #3729:
URL: https://github.com/apache/arrow-datafusion/issues/3729#issuecomment-1274636454
@andygrove has proposed an improvement to testing https://github.com/apache/arrow-datafusion/pull/3790
--
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