How to resolve "GROUP_CONCAT is not being recognized" error in TIBCO Data Virtualization?
book
Article ID: KB0070965
calendar_today
Updated On:
TIBCO Data Virtualization
|
All Supported Versions
|
Description
When using the GROUP_CONCAT as referenced below, TDV throws an error "GROUP_CONCAT is not being recognized"
SELECT customerId,
GROUP_CONCAT(DISTINCT customerName ORDER BY customerName ASC SEPARATOR ';')
FROM t;
Environment
All Supported Environments
Resolution
Use the below query which has the correct syntax for GROUP_CONCAT:
select customerId,
GROUP_CONCAT(customerName,';')
as customer
from t group by customerId;
Issue/Introduction
This article provides an example of using the GROUP_CONCAT function in TIBCO Data Virtualization.
Feedback
thumb_up
Yes
thumb_down
No