Search Results for group_concat in hive

MySQL/Hive/Presto/Impala Transposition

Rows to Columns Rows to Comma Separated String

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        |
+-----+----------+

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. Incoming search terms:group concat hivehive group concatHIVE group_concathive transpose column to rowhive transpose columns to rowsimpala concatwavempotransposing from row to coloumn in impalatranspose in hiveqltranspose function impalatranspopse function in hivesummerurqpresto concat_wsmysql/hive/presto/impala transpositionimpala row column convertArgument 2 of … Continue reading “MySQL/Hive/Presto/Impala Transposition”