记录:FINEBI整合Kylin4查询无数据异常问题

问题描述:

kylin开启数据下压,select * 查询正常返回数据,finebi sql数据集查询无数据,使用字段查询,部分字段能正常查询返回数据,但加上部分字段后,查询返回无数据,未报错

解决办法:

使用kylin的jdbc连接方式,执行sql,根据报错调整,一般为数据类型问题

驱动依赖:

        <dependency>
            <groupId>org.apache.kylin</groupId>
            <artifactId>kylin-jdbc</artifactId>
            <version>4.0.0</version>
        </dependency>

测试代码:

    public static void main(String[] args) {
        Driver driver = null;
        try {
            Class.forName("org.apache.kylin.jdbc.Driver");
            Connection conn = DriverManager.getConnection("jdbc:kylin://HOST:7070/PROJECT_NAME", "ADMIN","KYLIN");
            Statement state = conn.createStatement();
            ResultSet resultSet = state.executeQuery("select * from TABLE_NAME");
            XMysqlUtils.showResultSet(resultSet);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

  def showResultSet(resultSet: ResultSet) = {
    val metaData = resultSet.getMetaData
    val count = metaData.getColumnCount
    for (i <- 1 to count) {
      val value = metaData.getColumnName(i)
      print(s"${value}\t")
    }

    while (resultSet.next()) {
      println()
      for (i <- 1 to count) {
        val value = resultSet.getObject(i)
        print(s"${value}\t")
      }
    }
  }