You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@camel.apache.org by "gnodet (via GitHub)" <gi...@apache.org> on 2026/03/19 15:21:45 UTC
[PR] CAMEL-23218: camel-couchbase - Add SQL++ (N1QL) query support for consumer [camel]
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: commits-unsubscribe@camel.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [PR] CAMEL-23218: camel-couchbase - Add SQL++ (N1QL) query support for consumer [camel]
Posted by "gnodet (via GitHub)" <gi...@apache.org>.
gnodet merged PR #22107:
URL: https://github.com/apache/camel/pull/22107
--
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: commits-unsubscribe@camel.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [PR] CAMEL-23218: camel-couchbase - Add SQL++ (N1QL) query support for consumer [camel]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #22107:
URL: https://github.com/apache/camel/pull/22107#issuecomment-4090910473
:star2: Thank you for your contribution to the Apache Camel project! :star2:
:robot: CI automation will test this PR automatically.
:camel: Apache Camel Committers, please review the following items:
* First-time contributors **require MANUAL approval** for the GitHub Actions to run
* You can use the command `/component-test (camel-)component-name1 (camel-)component-name2..` to request a test from the test bot although they are normally detected and executed by CI.
* You can label PRs using `build-all`, `build-dependents`, `skip-tests` and `test-dependents` to fine-tune the checks executed by this PR.
* Build and test logs are available in the summary page. **Only** [Apache Camel committers](https://camel.apache.org/community/team/#committers) have access to the summary.
:warning: Be careful when sharing logs. Review their contents before sharing them publicly.
--
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: commits-unsubscribe@camel.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org