Impala | @sskaje

PHP ODBC Connect Cloudera Impala and Hive

Dependencies

UnixODBC

UnixODBC can be installed from yum repo

yum install unixODBC unixODBC-devel

1	yum install unixODBC unixODBC-devel

I built a unixODBC 2.3.2 from source, installed to /usr/local/unixODBC

ODBC Connectors

Follow the install guide on urls above, only wget and yum –nogpgcheck localinstall xxx.rpm required.

Incoming search terms:

MySQL/Hive/Presto/Impala Transposition

By @sskaje
Link: https://sskaje.me/2014/02/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.

MySQL/Hive/Presto/Impala Transposition by @sskaje: https://sskaje.me/2014/02/mysql-hive-presto-impala-transposition/

Environment

Dependencies

UnixODBC

ODBC Connectors

Incoming search terms:

Rows to Columns

Rows to Comma Separated String

MySQL

Incoming search terms: