Comments (4)
Hey! Do you have a reproduction?
Outer join will use retractions to retract the early "not matched" record if the left table receives a record before the right one.
StreamJoin only sends matches so should work regardless of retractions.
from octosql.
Thanks for your reply.
How is this retractions triggered? When I look at with output is print, I judge whether to use the produce function according to a quarter of the time.
from octosql.
Try using batch_table or stream_native output formats. With JSON it will indeed print both the send and the retraction as normal records (which is not good). Could be improved by doing a batch JSON printer as the output if retractions are possible, or by adding an undo
field that is true on JSON outputs that are retractions.
You can actually work around this by using an ORDER BY, that forces buffering and will process all retractions before outputting anything. Basically
SELECT .... ORDER BY true
from octosql.
thanks for your reply
from octosql.
Related Issues (20)
- Add REPL HOT 1
- Add Statistical Window Functions HOT 1
- Refactor to support Apache Arrow HOT 3
- queries using filenames that start with non-alpha characters fail HOT 4
- CSV parameter to secify separator
- Support HAVING of GROUP BY HOT 1
- Offset clause in csv query is ignored HOT 1
- File line by line HOT 4
- Four arithmetic operations between aggregation functions are not supported HOT 12
- GroupBy dimension not work, need replace with distinct HOT 3
- unsupported expression CaseExpr HOT 2
- Add charindex(String, String) function HOT 3
- Add substring_index(String, String, Int) function HOT 2
- Panic in parquet query
- Can this project be used as a Go dependency library?
- Decoding Error when Reading Parquet File - "RLE: Decoded Run-Length Block"
- Add Int64 type
- 't' and 'f' strings in csv are considered as boolean
- Complex CTE usage
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 octosql.