The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
v_txtindex.StringTokenizerDelim not working well since upgrade to 10.1

Hi,
I used this function : v_txtindex.StringTokenizerDelim
and the output was : "words", "input" columns (two columns)
now, when I use it I have only one output column "words"
how can I get the second column also ?
Thanks!
Tagged:
0
Answers
It is still showing 2 columns in 10.1. please find the sample example below.
dbadmin=> select version();
version
Vertica Analytic Database v10.1.0-1
(1 row)
dbadmin=>
dbadmin=> CREATE TABLE string_table (word VARCHAR(100), delim VARCHAR);
CREATE TABLE
dbadmin=> COPY string_table FROM STDIN DELIMITER ',';
Enter data to be copied followed by a newline.
End with a backslash and a period on a line by itself.
dbadmin=> SELECT * FROM string_table;
word | delim
-----------------+-------
SingleWord | dd
Break On Spaces | ' '
Break:On:Colons | :
(3 rows)
dbadmin=> SELECT v_txtindex.StringTokenizerDelim(word,delim) OVER (PARTITION BY word), word as input FROM string_table;
words | input
-----------------+-----------------
SingleWor | SingleWord
Break On Spaces | Break On Spaces
Break | Break:On:Colons
On | Break:On:Colons
Colons | Break:On:Colons
(5 rows)
@SruthiA in your example query, v_txtindex.StringTokenizerDelim returns only 1 column. The query adds a second output column
word as input
.