Comments (4)
Changes committed to trunk:
QueryFactory.existsIn(IndexedCollection<F> foreignCollection, Attribute<O, A>
localKeyAttribute, Attribute<F, A> foreignKeyAttribute)
and
QueryFactory.existsIn(IndexedCollection<F> foreignCollection, Attribute<O, A>
localKeyAttribute, Attribute<F, A> foreignKeyAttribute, Query<F>
foreignRestrictions)
Example usage:
http://cqengine.googlecode.com/svn/cqengine/trunk/src/test/java/com/googlecode/c
qengine/examples/join/SqlExists.java
Also, using this support for JOINs between indexed collections:
http://cqengine.googlecode.com/svn/cqengine/trunk/src/test/java/com/googlecode/c
qengine/examples/join/SqlExistsBasedJoin.java
Original comment by [email protected]
on 27 Jan 2013 at 10:11
- Changed title: Add support for SQL EXISTS and exists-based JOIN
- Added labels: Type-Enhancement
- Removed labels: Type-Defect
from cqengine.
Original comment by [email protected]
on 27 Jan 2013 at 10:12
- Changed state: Done
from cqengine.
Hi Niall, I've been looking at using cqengine for a project and came across this functionality you added. When I try to use the SQL WHERE EXISTS statement as in the example above with the SQLParser, I keep getting parser failure:
Request was not successful: Failed to parse query at line 1:30: extraneous input 'EXISTS' expecting {'(', K_NOT, IDENTIFIER, STRING_LITERAL}
Browsing through the examples in your test, I'm guessing this functionality has only been added to the CQN dialects, but not currently supported in SQL parser?
Thanks,
Ann
from cqengine.
See Niall's reply at https://groups.google.com/forum/#!topic/cqengine-discuss/V-GsNSPIHAA.
from cqengine.
Related Issues (20)
- FilteringIterator returns hasNext as true after the collection is consumed HOT 1
- Update data automatically HOT 1
- Pagination Over data HOT 4
- Perfomance index HOT 3
- Consider exposing utility static method taking collections
- Reenable cached hashCode
- Support for java.util.Optional
- [Question] How does CQEngine pick the appropriate index to query?
- most longest prefix value exist in the column value but it doesn't intersect with other columns values in the query that we need part of query retrieval HOT 7
- Support STRICT_REPLACEMENT in ObjectLockingIndexedCollection/ConcurrentIndexedCollection
- TransactionalIndexedCollection support for UniqueIndex is broken
- Support for attribute accessors for Java record type HOT 1
- Kryo generates InaccessibleObjectException - Make Dependencies "Java 17 compatible"
- Bug in AttributeOrdersComparator HOT 5
- Offheap cache visibility HOT 1
- Support for ANTLR 4.10.1 HOT 12
- Does it support SQL statistics queries HOT 3
- Thread blocked when using Materialized View Sort For the Longest Prefix for CSV that contain more than 11 K rows HOT 3
- Error while parsing SQL NOT LIKE query HOT 1
- Error while parsing SQL LIKE '%%%' query
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 cqengine.