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 transposeimpala group_concat 顺序wrong75uturnyy7sql column to row impalasplit5gvpresto concat_wspleasant3drjustvgximpala中的group_concatallowcfpimpala group_concatimpala groupconcatHow to join row values to column names impalahive sql transposehive group by column and concat columngroup_concatimpalacompletelyv53Link 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”