azkaban mysql参数_mysql + Azkaban：阅读“LongBlob”

所以在经过大量挖掘azkaban之后，我发现这就是人们应该如何在azkaban-Database中查询LongBlobs：

public String getErrorLog(){

String returnString = "";

try {

Connection conn = AzkabanClient.getPhoenixConnection(conf);

String s = " select exec_id, enc_type, log from execution_logs where exec_id = 3964 and name = 'http-time-series-hourly' ";

PreparedStatement pstmt = conn.prepareStatement(s);

ResultSet rs = pstmt.executeQuery();

while (rs.next()) {

int i = rs.getInt("exec_id");

ByteArrayOutputStream byteStream = new ByteArrayOutputStream();

EncodingType encType = EncodingType.fromInteger(rs.getInt("enc_type"));

int debug = 0;

byte[] data = rs.getBytes("log");

try {

byte[] buffer = data;

ByteArrayOutputStream byteArrayOutputStream = null;

if (encType == EncodingType.GZIP) {

byteArrayOutputStream = GZIPUtils.unGzipBytesOutputStream(data);

}

returnString = new String(byteArrayOutputStream.toByteArray(), "UTF-8");

} catch (IOException e) {

throw new SQLException(e);

}

}

conn.close();

} catch (Exception e) {

LOGGER.error("Error =>" + e);

}

return returnString;

}其中：

GZIPUtils是：

public class GZIPUtils {

public static ByteArrayOutputStream unGzipBytesOutputStream(byte[] bytes) throws IOException {

ByteArrayInputStream byteInputStream = new ByteArrayInputStream(bytes);

GZIPInputStream gzipInputStream = new GZIPInputStream(byteInputStream);

ByteArrayOutputStream byteOutputStream = new ByteArrayOutputStream();

IOUtils.copy(gzipInputStream, byteOutputStream);

return byteOutputStream;

}

}和EncodingType：

public static enum EncodingType {

PLAIN(1), GZIP(2);

private int numVal;

EncodingType(int numVal) {

this.numVal = numVal;

}

public int getNumVal() {

return numVal;

}

public static EncodingType fromInteger(int x) {

switch (x) {

case 1:

return PLAIN;

case 2:

return GZIP;

default:

return PLAIN;

}

}

}