在Vertica 7中安装group_concat UDAF聚合函数

Question

我想安装Vertica 7中预装的UDAF字符串函数，特别是group_concat。

我之前在Vertica 6中安装了这个，但情况似乎有了一些变化。例如，没有make文件，但有install.sql/

下面是我所做的：

$ vsql -U dbadmin -w secret
> \i /opt/vertica/packages/txtindex/ddl/install.sql

这将产生以下输出：

------------------------------------
 Vertica Analytic Database v7.2.0-0
(1 row)

ALTER SESSION
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:5: ROLLBACK 4650:  Schema "TxtIndex" does not exist
vsql:/opt/vertica/packages/txtindex/ddl/install.sql:6: NOTICE 4214:  Object "v_txtindex" already exists; nothing was done
CREATE SCHEMA
ALTER SESSION
CREATE LIBRARY
CREATE FUNCTION
GRANT PRIVILEGE
CREATE FUNCTION
GRANT PRIVILEGE
CREATE FUNCTION
GRANT PRIVILEGE
CREATE TRANSFORM FUNCTION
GRANT PRIVILEGE
CREATE TRANSFORM FUNCTION
GRANT PRIVILEGE
CREATE TRANSFORM FUNCTION
GRANT PRIVILEGE
CREATE TRANSFORM FUNCTION
GRANT PRIVILEGE
CREATE TRANSFORM FUNCTION
GRANT PRIVILEGE
CREATE TRANSFORM FUNCTION
GRANT PRIVILEGE
CREATE TRANSFORM FUNCTION
GRANT PRIVILEGE

它看起来可以工作，但安装失败：

dbadmin=> \i /opt/vertica/packages/txtindex/ddl/isinstalled.sql 
 ?column? 
----------
 f
(1 row)

以下查询也会失败

  SELECT id, group_concat(distinct organization) AS orgs FROM myschema.mytable GROUP BY id;

具体地说，我得到了这个错误：

ERROR 3457:  Function group_concat(varchar) does not exist, or permission is denied for group_concat(varchar)
HINT:  No function matches the given name and argument types. You may need to add explicit type casts

Answer 1

据我所知，在/opt/vertica/packages/txtindex/ddl/install.sql中注释了group_concat()安装(此文件中的最后两行)。

group_concat()源代码可能在HAVEN市场中可用。