MONGODB BI CONNECTOR 2.2 scalar function is not supported

38 views

Skip to first unread message

sourav biswas

unread,

Sep 21, 2017, 5:52:24 PM9/21/17

to mongodb-user

VERSION : MONGODB BI CONNECTOR 2.2 (MySQL)

QUERY : SELECT DATE(CURDATE()) as `creationdate`, `apiActivityLog`.`trackingId` AS `trackingId`, `apiActivityLog`.`activationChannel` AS `activationChannel`, GROUP_CONCAT(`apiActivityLog`.`taskCode`) FROM `sparrow`.`apiActivityLog` where `lastModifiedDate` between DATE(CURDATE() - interval 1 day) and DATE(CURDATE()) and `taskCode` in ('101002', '101004', '101006') group by `trackingId` ,`activationChannel`

RESPONSE : LIMIT 0, 1000 Error Code: 1105. scalar function 'group_concat' is not supported 0.062 sec

Stephen Steneker

unread,

Oct 9, 2017, 2:30:02 AM10/9/17

to mongodb-user

Hi Sourav,

The error message is correct. The MongoDB Connector for BI (as at 2.2) does not include support for group_concat(), which is currently a MySQL extension to standard SQL.

You can find a list of Supported SQL Functions and Operators in the documentation.

Regards,

Stennie

Reply all

Reply to author

Forward

0 new messages