Comments (3)
Might have been caused by #20947
from presto.
I added the stats information to the "actual" plan that gets printed for failures. So far I've gotten one failure out of several thousand runs. It looks like sometimes the HBO stats for the filter node are logged as 0 rows and 0 bytes (in the test we check that it's 2 rows and 199 bytes). The output node stats for that same run are noted as 2 rows and 199 bytes. Possibly a real bug or race condition of some kind for HBO.
- Output[PlanNodeId 6][nationkey, name, regionkey, comment] => [nationkey:bigint, name:varchar(25), regionkey:bigint, comment:varchar(152)]
Estimates: {source: HistoryBasedSourceInfo, rows: 2 (199B), cpu: ?, memory: ?, network: ?}
- ScanFilter[PlanNodeId 0,108][table = TableHandle {connectorId='tpch', connectorHandle='nation:sf0.01', layout='Optional[nation:sf0.01]'}, filterPredicate = (substr(name, BIGINT'1', BIGINT'1')) = (VARCHAR'A')] => [nationkey:bigint, name:varchar(25), regionkey:bigint, comment:varchar(152)]
Estimates: {source: CostBasedSourceInfo, rows: 25 (2.67kB), cpu: ?, memory: ?, network: ?}/{source: HistoryBasedSourceInfo, rows: 0 (0B), cpu: ?, memory: ?, network: ?}
regionkey := tpch:regionkey (1:15)
name := tpch:name (1:15)
nationkey := tpch:nationkey (1:15)
comment := tpch:comment (1:15)
from presto.
Meet the error in another method TestHistoryBasedStatsTracking.testRowNumber
:
https://github.com/prestodb/presto/actions/runs/9208530744/job/25330959486?pr=22659#step:7:6454
[ERROR] TestHistoryBasedStatsTracking.testRowNumber:242->AbstractTestQueryFramework.assertPlan:446->AbstractTestQueryFramework.assertPlan:451->AbstractTestQueryFramework.assertPlan:459->AbstractTestQueryFramework.lambda$assertPlan$7:461 Plan does not match, expected [
- anyTree
- node(RowNumberNode)
expectedOutputRowCount(2.0)
- anyTree
- node
] but found [
- Output[PlanNodeId 9][nationkey, _col1] => [nationkey:bigint, row_number_1:bigint]
Estimates: {source: HistoryBasedSourceInfo, rows: 2 (36B), cpu: ?, memory: ?, network: ?}
_col1 := row_number_1 (1:19)
- Project[PlanNodeId 5][projectLocality = LOCAL] => [nationkey:bigint, row_number_1:bigint]
- RowNumber[PlanNodeId 250][partition by (regionkey)][$hashvalue] => [nationkey:bigint, regionkey:bigint, $hashvalue:bigint, row_number_1:bigint]
row_number_1 := row_number()
- LocalExchange[PlanNodeId 378][SINGLE] () => [nationkey:bigint, regionkey:bigint, $hashvalue:bigint]
Estimates: {source: CostBasedSourceInfo, rows: 2 (36B), cpu: ?, memory: ?, network: ?}
- ScanFilterProject[PlanNodeId 0,202,2][table = TableHandle {connectorId='tpch', connectorHandle='nation:sf0.01', layout='Optional[nation:sf0.01]'}, filterPredicate = (substr(name, BIGINT'1', BIGINT'1')) = (VARCHAR'A'), projectLocality = LOCAL] => [nationkey:bigint, regionkey:bigint, $hashvalue_9:bigint]
Estimates: {source: CostBasedSourceInfo, rows: 25 (450B), cpu: ?, memory: ?, network: ?}/{source: CostBasedSourceInfo, rows: ? (?), cpu: ?, memory: ?, network: ?}/{source: HistoryBasedSourceInfo, rows: 2 (38B), cpu: ?, memory: ?, network: ?}
$hashvalue_9 := combine_hash(BIGINT'0', COALESCE($operator$hash_code(regionkey), BIGINT'0')) (1:68)
regionkey := tpch:regionkey (1:67)
nationkey := tpch:nationkey (1:67)
name := tpch:name (1:67)
]
from presto.
Related Issues (20)
- JDBC DatabaseMetadata.getTables to describe VIEWS as VIEWS and not tables. Duplicates responses in getTables.
- Pull up constants from join HOT 1
- Project all fields from the probe side (for inner joins) when possible
- HiveWriterFactory.createPartitionValues doesn't handle spaces HOT 1
- Incorrect result of lower('Შ') HOT 4
- Wrong results for count (and probably correlated subqueries) over empty grouping sets
- Wrong timezone conversions for "America/Scoresbysund" HOT 8
- presto memory usage mechanism problem, after the execution of the calculation task, the memory usage is not reduced HOT 1
- Not able to build presto project HOT 9
- [native] Possible SEGV in HttpClient::createTransaction HOT 8
- Add a UDF for splitting array into slices of given length
- Add fail-fast function validation support for Presto C++
- Allow C++-defined system session properties
- Differential privacy primitives use insecure noise generation
- Missing pushdown
- Flaky SingleStore tests HOT 1
- CI job SingleStore tests failing HOT 1
- Add ARM64 Support for Building Prestissimo Docker Image on Mac M1 HOT 3
- Backport https://github.com/prestodb/presto/pull/22926 into 0.285, 0.286 and 0.287
- Pushdown (partial) rowNumber under join
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from presto.