|
|
|
|
 |
|
在祐 / 2024-02-29 / 오전 11:20:06 / 165.246.204.254
조회수 : 11
|
| [기타] Vertica 텍스트 쪼개기 |
SELECT ANA_RowID, ORA_OPNAME
, v_txtindex.StringTokenizerDelim(ORA_OPNAME, ';') OVER (PARTITION BY ANA_RowID, ORA_OPNAME) AS Code
FROM EDW.TE_RV_OP_LIST_TEST
ORDER BY ANA_RowID
SELECT
EXPLODE(
ANA_RowID
, STRING_TO_ARRAY(REPLACE(ORA_OPNAME, ';', ','))
) OVER(PARTITION BEST)
FROM EDW.TE_RV_OP_LIST_TEST
ORDER BY ANA_RowID, position
SELECT ANA_RowID, EXPLODE(Codes) OVER(PARTITION BY ANA_RowID) AS (position, Code)
FROM (
SELECT ANA_RowID
, STRING_TO_ARRAY(REPLACE(ORA_OPNAME, ';', ',')) AS Codes
FROM EDW.TE_RV_OP_LIST_TEST
) T
ORDER BY ANA_RowID |
|
|
