Member since
11-14-2017
1
Post
0
Kudos Received
0
Solutions
11-14-2017
05:28 PM
Using Cloudera JDBC41_2.5.38. Tried various combinations but no luck using JDBC, user is empty. DataSource ds = new com.cloudera.impala.jdbc41.DataSource(); ds.setURL("jdbc:impala://<host>:21050;UseSasl=0;UID=test;AuthMech=0"); ds.setUserID("test"); ds.setLoginTimeout(60); ds.setCustomProperty("UID", "test"); ds.setCustomProperty("USER", "test"); ds.setLogLevel(LogLevel.TRACE.toString()); ds.setLogDirectory("C:\\temp\\impala_log"); String sql = "select ...."; try (Connection connection = ds.getConnection(); ResultSet rs = connection.createStatement().executeQuery(sql) { // print We do not have authentication turned on so I do get result back but "user" is empty on impalad host http://<impaladhost>:25000/queries 25000/queries I see that in python -> impala/hiveserver2.py it tries to read from os environment variable ('USER', 'USERNAME') etc. I tried to do TRACE log for cloudera but could not make much sense of logs. If I use hue from cloudera manager then I do see user in impalad. Any idea what can I do in Java JDBC without turning on User or User/Password authentication.
... View more