/**
   * Gets a connection to the Hive server.
   *
   * @return
   * @throws Exception
   */
  private Connection getConnection() throws Exception {
    // dynamically load the Hive JDBC driver
    Class.forName(DRIVERNAME);

    // return a connection based on the Hive JDBC driver
    LOGGER.debug(
        "Connecting to jdbc:hive://"
            + hiveServer
            + ":"
            + hivePort
            + "/default?user="******"&password=XXXXXXXXXX");
    return DriverManager.getConnection(
        "jdbc:hive://"
            + hiveServer
            + ":"
            + hivePort
            + "/default?user="******"&password="
            + hadoopPassword);
  } // getConnection