Troubleshooting
Problem
How to install GROUP_CONCAT UDF
Symptom
N/A
Cause
N/A
Environment
N/A
Diagnosing The Problem
N/A
Resolving The Problem
GROUP_CONCAT comes with INZA, but it is not installed by
default. Need to install INZA first.
Once it is install we will have to install GROUP_CONCAT using the following steps -->
1. export PATH=$PATH:/nz/extensions/nz/nzlua/bin
2. export NZ_DATABASE=<db name where you want functions installed)
3. cd /nz/extensions/nz/nzlua/examples (here is the list of available optional functions)
4. nzl -d <db where functions is to be installed) group_concat.nzl
5. nzsql -db <db where functions is installed)
6. grant execute on group_concat(varchar(128)) to public;
7. If you want to install in separate databases repeat steps 2-6.
Was this topic helpful?
Document Information
Modified date:
17 October 2019
UID
swg21984349