doris同连接的元数据获取不到字段

Viewed 5

doris 版本:v4.0.1
通过连接的元数据获取字段获取不到。

PreparedStatement ps = connection.prepareStatement(querySql)) {
ps.setMaxRows(1);
// 关键:直接获取元数据,不执行查询!
ResultSetMetaData metaData = ps.getMetaData();

         for (int i = 1; i <= metaData.getColumnCount(); i++) {
        res.add(FiledColumnVO.builder()
                .columnName(metaData.getColumnLabel(i))
                .columnType(metaData.getColumnTypeName(i))
                .columnLength(Long.valueOf(metaData.getColumnDisplaySize(i)))
                .columnScale(Long.valueOf(metaData.getScale(i)))
                //.columnScale(String.valueOf(metaData.getScale(i)))
                .pkFlag("0")
                .nullableFlag(metaData.isNullable(i) == 1?"1":"0")
                .build());
    }
0 Answers