I have configured the BQL.TRA to my tangosol coherence cluster, and when I run the query select count(*) fromfrom /Concept/myconcept it fails, but select * from /Concept/myconcept works fine. How do I solve this ?
Article ID: KB0091324
Updated On:
| Products | Versions |
|---|---|
| TIBCO BusinessEvents Enterprise Edition | - |
| Not Applicable | - |
Description
Resolution:
When using count(*) you should always use group by clause, since aggregate functions require a group by clause. If needed you can have a fixed GROUP BY clause like the following.
select count(*) from /Concept/myconcept GROUP BY 1 , or like select count(*) from /Concept/myconcept GROUP BY true
Issue/Introduction
I have configured the BQL.TRA to my tangosol coherence cluster, and when I run the query select count(*) fromfrom /Concept/myconcept it fails, but select * from /Concept/myconcept works fine. How do I solve this ?
Feedback
Yes
No
Powered by
