gnodet opened a new pull request, #22107:
URL: https://github.com/apache/camel/pull/22107
## Summary
- Add SQL++ (N1QL) query support as an alternative to deprecated MapReduce
Views in the camel-couchbase consumer
- New `statement` endpoint option: when set, uses `scope.query()` instead of
`bucket.viewQuery()`
- Deprecate `designDocumentName` and `viewName` options (MapReduce Views
were deprecated in Couchbase 7.0 and don't work with Magma, the default storage
backend since Couchbase 8.0)
- Add `ConsumeSqlQueryIT` integration test for SQL++ consumer
- Update documentation and upgrade guide
## Usage
```java
from("couchbase:http://localhost?bucket=myBucket&username=user&password=pass";
+ "&statement=SELECT META().id AS __id, * FROM `myCollection` WHERE type
= 'order' LIMIT 100")
.to("direct:result");
```
The query must include `META().id AS __id` in the SELECT clause so the
consumer can identify each document.
## Test plan
- [x] All 27 existing unit tests pass
- [x] New `ConsumeSqlQueryIT` integration test validates SQL++ consumer with
primary index
- [ ] CI validation
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
