vertica中没有类似Oracle中的ws_concat函数功能,需要开发UDF,自己对C++不熟悉,所有只有想其他方法解决了。上代码:SELECTnode_state,MAX(DECODE(row_number,1, a.node_name)) ||NVL(MAX(DECODE(row_number,2,','|| a.node_name)),'') ||NVL(MAX(DECODE(row_number,3,','|| a.node_name)),'') ||NVL(MAX(DECODE(row_number,4,','|| a.node_name)),'') ||NVL(MAX(DECODE(row_number,5,','|| a.node_name)),'') ||NVL(MAX(DECODE(row_number,6,','|| a.node_name)),'') ||NVL(MAX(DECODE(row_number,7,','|| a.node_name)),'') ||NVL(MAX(DECODE(row_number,8,','|| a.node_name)),'') ||NVL(MAX(DECODE(row_number,9,','|| a.node_name)),'') ||NVL(MAX(DECODE(row_number,10,','|| a.node
...
继续阅读
(15)