Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi. I should lose points for asking this, it's such a simple question, but I keep getting a load error.
I have a table Table1 like:
column_1 | column_2 |
---|---|
A | AA |
A | BB |
A | CC |
B | DD |
B | EE |
B | FF |
I want to create the following Table2:
column_a | column_b |
---|---|
A | AA,BB,CC |
B | DD,EE,FF |
Table2:
load distinct column_1 as column_a,
concat(column_2,',') as column_b
resident Table1;
The above doesn't work. What should I be using?
Nevermind,. I forgot the Group BY clause.