public static CompactionInfo loadFullFromCompactionQueue(ResultSet rs) throws SQLException {
    CompactionInfo fullCi = new CompactionInfo();
    fullCi.id = rs.getLong(1);
    fullCi.dbname = rs.getString(2);
    fullCi.tableName = rs.getString(3);
    fullCi.partName = rs.getString(4);
    fullCi.state = rs.getString(5).charAt(0);//cq_state
    fullCi.type = TxnUtils.dbCompactionType2ThriftType(rs.getString(6).charAt(0));
    fullCi.properties = rs.getString(7);
    fullCi.workerId = rs.getString(8);
    fullCi.start = rs.getLong(9);
    fullCi.runAs = rs.getString(10);
    fullCi.highestWriteId = rs.getLong(11);
    fullCi.metaInfo = rs.getBytes(12);
    fullCi.hadoopJobId = rs.getString(13);
    fullCi.errorMessage = rs.getString(14);
    fullCi.enqueueTime = rs.getLong(15);
    fullCi.workerVersion = rs.getString(16);
    fullCi.initiatorId = rs.getString(17);
    fullCi.initiatorVersion = rs.getString(18);
    fullCi.retryRetention = rs.getLong(19);
    fullCi.nextTxnId = rs.getLong(20);
    fullCi.txnId = rs.getLong(21);
    fullCi.commitTime = rs.getLong(22);
    fullCi.poolName = rs.getString(23);
    fullCi.numberOfBuckets = rs.getInt(24);
    fullCi.orderByClause = rs.getString(25);
    return fullCi;
  }
loads object from a row in Select * from COMPACTION_QUEUE
@param rs ResultSet after call to rs.next()
@throws SQLException
standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/txn/entities/CompactionInfo.java