Rows to Columns
Rows to Comma Separated String
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
FROM: +-----+-----+ | uid | tag | +-----+-----+ | 1 | 1 | | 1 | 2 | | 1 | 3 | | 2 | 1 | | 2 | 4 | | 3 | 5 | +-----+-----+ TO: +-----+----------+ | uid | tag_list | +-----+----------+ | 1 | 1,2,3 | | 2 | 1,4 | | 3 | 5 | +-----+----------+ |
MySQL
Use GROUP_CONCAT(). This function also works in Infobright.
Continue reading “MySQL/Hive/Presto/Impala Transposition” »
MySQL/Hive/Presto/Impala Transposition by @sskaje: https://sskaje.me/2014/02/mysql-hive-presto-impala-transposition/
Incoming search terms:
- presto concat
- transpose row to column in impala
- hive group concat
- group concat hive
- HIVE group_concat
- rows to columns impala
- hive transpose column to row
- hive transpose columns to rows
- impala Comma Separated String to Rows
- presto concat_ws
- goose2nd
- whisperedvcb
- group_concat in hive
- flykne
- Argument 2 of function CONCAT_WS must be string or array<string> but array<int> was found
- how to transpose data in impala
- impala concat
- convert row to column in impala
- manner79h
- cheesebzo