PHP ODBC Connect Cloudera Impala and Hive

Environment CentOS 5.5 PHP 5.3.10 (This article also works for PHP 5.3.3 on CentOS 6). Dependencies UnixODBC UnixODBC can be installed from yum repo

I built a unixODBC 2.3.2 from source, installed to /usr/local/unixODBC ODBC Connectors Cloudera offers ODBC libs for both Hive and Impala: http://www.cloudera.com/content/support/en/downloads/connectors/impala/impala-odbc-v2-5-15.html http://www.cloudera.com/content/support/en/downloads/connectors/hive/hive-odbc-v2-5-9.html Follow the install guide on urls above, … Continue reading “PHP ODBC Connect Cloudera Impala and Hive”

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:hive transposeimpala concatimpala sql for transposeallowcfpcompletelyv53group_concatimpalahive group by column and concat columnhive sql transposeHow to join row values to column names impalaimpala groupconcatimpala group_concatimpala中的group_concatjustvgxsql column to row impalaturnyy7wrong75uLink to this post!

Manually Upgrade CDH 5.2 in CM 5

I was interrupted again when upgrading CDH. HDFS This time, NameNode was not started, I have to bring them up and resume the upgrade progress. I didn’t save any log about NN’s error, stop all HDFS components and ran ‘Upgrade HDFS Metadata‘, then start HDFS.

YARN Next, YARN. I started YARN, and then all … Continue reading “Manually Upgrade CDH 5.2 in CM 5”