Exemplo n.º 1
0
  /**
   * Kick-offer
   *
   * @param sql sql string
   * @return an intance
   * @throws SQLException
   */
  private Instance runClientSQL(String sql) throws SQLException {
    Instance instance;
    try {
      Map<String, String> hints = new HashMap<String, String>();
      Map<String, String> aliases = new HashMap<String, String>();

      // If the client forget to end with a semi-colon, append it.
      if (!sql.contains(";")) {
        sql += ";";
      }

      Odps odps = connHanlde.getOdps();
      instance = SQLTask.run(odps, odps.getDefaultProject(), sql, "SQL", hints, aliases);
      LogView logView = new LogView(odps);
      if (connHanlde.getLogviewHost() != null) {
        logView.setLogViewHost(connHanlde.getLogviewHost());
      }

      String logViewUrl = logView.generateLogView(instance, 7 * 24);
      connHanlde.log.fine("Run SQL: " + sql);
      connHanlde.log.info(logViewUrl);
      warningChain = new SQLWarning(logViewUrl);
    } catch (OdpsException e) {
      connHanlde.log.severe("fail to run sql: " + sql);
      throw new SQLException(e);
    }
    return instance;
  }
Exemplo n.º 2
0
 /**
  * Blocked SQL runner, do not print any log information
  *
  * @param sql sql string
  * @throws SQLException
  */
 private void runSilentSQL(String sql) throws SQLException {
   try {
     long begin = System.currentTimeMillis();
     Odps odps = connHanlde.getOdps();
     SQLTask.run(odps, sql).waitForSuccess();
     long end = System.currentTimeMillis();
     connHanlde.log.fine("It took me " + (end - begin) + " ms to run SQL: " + sql);
   } catch (OdpsException e) {
     throw new SQLException(e);
   }
 }