MySQL/Hive/Presto/Impala Transposition

Rows to Columns Rows to Comma Separated String

MySQL Use GROUP_CONCAT(). This function also works in Infobright. Incoming search terms:presto concattranspose row to column in impalagroup concat hivehive group concatHIVE group_concatpresto concat_wsimpala Comma Separated String to Rowshive transpose columns to rowshive transpose column to rowgroup_concat in hiveArgument 2 of function CONCAT_WS must be string … Continue reading “MySQL/Hive/Presto/Impala Transposition”