Uploaded image for project: 'CDH (READ-ONLY)'
  1. CDH (READ-ONLY)
  2. DISTRO-751

Hive metastore MySQL instructions refer to non-existent file on Ubuntu

          Details

          • Type: Bug
          • Status: Open
          • Priority: Trivial
          • Resolution: Unresolved
          • Affects Version/s: CDH 5.4.4, CDH 5.4.5
          • Fix Version/s: None
          • Component/s: Docs, Hive
          • Labels:
            None

            Description

            The instructions for installing the MySQL connector for the Hive Metastore on an Ubuntu platform (http://www.cloudera.com/content/cloudera/en/documentation/core/latest/topics/cdh_ig_hive_metastore_configure.html) are misleading.

            In the "To install the MySQL connector on a Debian/Ubuntu system:" section, the code block currently reads:

            $ sudo apt-get install libmysql-java
$ ln -s /usr/share/java/libmysql-java.jar /usr/lib/hive/lib/libmysql-java.jar

            I believe it should read

            $ sudo apt-get install libmysql-java
$ ln -s /usr/share/java/mysql-connector-java.jar /usr/lib/hive/lib/mysql-connector-java.jar

            based on http://packages.ubuntu.com/precise/all/libmysql-java/filelist and http://packages.ubuntu.com/trusty/all/libmysql-java/filelist.

            This caused a confusing schematool error:

            $ /usr/lib/hive/bin/schematool -dbType mysql -upgradeSchema
org.apache.hadoop.hive.metastore.HiveMetaException: Failed to load driver
*** schemaTool failed ***

              Attachments

                Activity

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    seshadri Seshadri Mahalingam
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    1 Start watching this issue

                    Dates

                    • Created:
                      Updated: