Feedback
Did this article resolve your question/issue?

   

Article

NullPointerException when calling getColumns() with the Connect for JDBC Impala driver

Information

 
TitleNullPointerException when calling getColumns() with the Connect for JDBC Impala driver
URL NameNullPointerException-when-calling-getColumns-with-the-Connect-for-JDBC-Impala-driver
Article Number000184364
EnvironmentProduct: Connect for JDBC Impala
Version: 5.1
OS: Java
Database: Impala
Application: N/A
Question/Problem Description
I created a new table using beeline in hdfs, then insert data.  After that, I invalidated metadata in impala-shell on the same node.  And new table became visible and I could query it using impala-shell.

However, when I use progress JDBC driver to get the metadata, I can see the table, but no column is shown.  Progress JDBC driver just returned an empty table with no clumns.

And I am using version:
[Impala JDBC Driver]Driver Version: 5.1.3.000030 (F000190.U000086)

Note:  this issue is not reproducible using SIMBA impala driver.
Steps to ReproduceCreate the following table:

create table testtable(id BIGINT, column_boolean BOOLEAN, column_char CHAR(1), column_decimal DECIMAL(9,4), column_double DOUBLE, column_float FLOAT, column_int INT, column_smallint SMALLINT, column_string STRING, column_timestamp TIMESTAMP, column_tinyint TINYINT, column_varchar VARCHAR(64))

Call getColumns() for this table
Clarifying Information
Error MessageException in thread "main" java.lang.NullPointerException
at com.ddtek.jdbc.impalabase.ddc9.j(Unknown Source)
at com.ddtek.jdbc.impalabase.ddc9.a(Unknown Source)
at com.ddtek.jdbc.impalabase.ddc9.i(Unknown Source)
at com.ddtek.jdbc.impalabase.ddc9.a(Unknown Source)
at com.ddtek.jdbc.impalabase.dddc.e(Unknown Source)
at com.ddtek.jdbc.impalabase.dddc.s(Unknown Source)
at com.ddtek.jdbc.impalabase.ddd3.a(Unknown Source)
at com.ddtek.jdbc.impalabase.dds.a(Unknown Source)
at com.ddtek.jdbc.impalabase.dde0.e(Unknown Source)
at com.ddtek.jdbc.impalabase.dde0.v(Unknown Source)
at com.ddtek.jdbc.impalabase.dde0.a(Unknown Source)
at com.ddtek.jdbc.impalabase.BaseDatabaseMetaData.getColumns(Unknown Source)
at MiniConnectTest.testConnect(MiniConnectTest.java:105)
at MiniConnectTest.main(MiniConnectTest.java:64)
Defect Number
Enhancement Number
Cause
Unknown
Resolution
Upgrade to version 5.1.4.000062 and higher
Workaround
Notes
Last Modified Date4/20/2016 7:24 PM
Files
Disclaimer The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.