val DRIVER = “com.cloudera.impala.jdbc41.Driver”
val URL = “jdbc:impala://10.3.1.100:21050/Default”
Class.forName(DRIVER)
val client = DriverManager.getConnection(URL)
//注意:sql语句后面添加分号,估计是impala的一个bug,不加分号会报错
//报错信息:Caused by: com.cloudera.support.exceptions.GeneralException: [Simba]ImpalaJDBCDriver Error during translation: code translation error, type {1}, message {2}
val sql = “delete from table where date <= '” + date + “’;”
println(sql)
val ret = client.createStatement().execute(sql)
println("ret = " + ret)
//execute返回一个Boolean值,有结果为true,无结果为false,所以删除和更新操作均返回false
if(!ret){
println(“ok”)
}
scala通过jdbc操作kudu
最新推荐文章于 2022-02-17 14:03:38 发布