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 transposetranspose row to columns in impalaimpala concatimpala sql for transposeimpala group_concatwrong75usql column to row impalasplit5gvpresto concat_wspleasant3drjustvgximpala中的group_concatimpala group_concat 顺序allowcfpimpala groupconcatHow to join row values to column names impalahive sql transposehive group by column and concat … Continue reading “MySQL/Hive/Presto/Impala Transposition”

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”