String url = "jdbc:cdap://<cdap-explore-host>:<port>/<namespace>";
String username = "username";
String password = "password";
Class.forName("co.cask.cdap.explore.jdbc.ExploreDriver");
java
Connection connection = DriverManager.getConnection(url, username, password);
Statement statement = connection.createStatement();
String sql = "SELECT * FROM my_dataset";
ResultSet resultSet = statement.executeQuery(sql);
while (resultSet.next()) {
}
resultSet.close();
statement.close();
connection.close();