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”

Fix Alternatives for Cloudera Manager + CDH

Earlier post: Fix Hadoop Conf Alternatives for CDH5 I tried to upgrade Cloudera Manager + CDH 5.0.0 beta 1 and beta 2 from CM+CDH 4 then downgrade and delete, found many alternatives were installed on my small cluster, that made my lately installed CM+CDH 4 and CM+CDH 5 not working well, all because of the … Continue reading “Fix Alternatives for Cloudera Manager + CDH”

Cloudera Manager Drop Database/User on Embedded Postgresql

First, you have to find out where the password locates. https://gist.github.com/mrmichalis/5984131 I ran these on which Cloudera Manager locates.

The cloudera-scm is the superuser. And the first line in that file is the password. To drop a database, dropdb is the command:

Commands may like:

To drop a user, using dropuser: … Continue reading “Cloudera Manager Drop Database/User on Embedded Postgresql”

Cloudera Mirror

Currently available for CentOS/RHEL 6 x86_64. Address: http://cloudera.rst.im/ rsync://cloudera.rst.im/cloudera/ Cloudera Manager Cloudera Manager 5.0.2 Cloudera Manager 5: installer for CM5, yum repo file for CM5 Cloudera Manager 4.8.3 Cloudera Manager 4: installer for CM4, yum repo file for CM4 Cloudera Distribution of Hadoop CDH’s official product page: http://www.cloudera.com/content/cloudera/en/products-and-services/cdh.html Parcel is my favorite choice installing CDH … Continue reading “Cloudera Mirror”

Cloudera Archive Mirror Updated for CM5 & CDH5

Latest Updates @ https://sskaje.me/cloudera-mirror/ Cloudera just released it’s CDH 5 beta download here, this time their don’t use the beta.cloudera.com as non-release product’s repo. URL: http://cloudera.rst.im/ RHEL/CentOS 6 Only. You may download Cloudera Manager 4 installer from http://cloudera.rst.im/cm4/installer/latest/ And use http://cloudera.rst.im/cm4/redhat/6/x86_64/cm/4.7.2/ as your yum repo for CM 4.7.2. Or Cloudera Manager 5 installer from http://cloudera.rst.im/cm5/installer/latest/, … Continue reading “Cloudera Archive Mirror Updated for CM5 & CDH5”