[IMPALA-1613] Impala Driver Struggles with Tables with Decimals

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 1.4
• Fix Version/s: Impala 2.0
• Assignee: Unassigned
• Reporter: David Ross
• Created: 14/Dec/14 20:05
• Updated: 10/Feb/15 18:40
• Resolved: 10/Feb/15 18:40

Description

With this simple sequence:

create table decimal_test_1(d decimal(9,0))
select * from decimal_test_1;

I get this Exception:

java.sql.SQLException: [Simba][ImpalaJDBCDriver](500002) Error setting metadata result set: Metadata Result Set Error.
        at com.cloudera.impala.hivecommon.api.HS2Client.getResultSetMetadata(Unknown Source) ~[impala-jdbc41-2.5.14.1016.jar:ImpalaJDBC_2.5.14.1016]
        at com.cloudera.impala.hivecommon.dataengine.HiveJDBCResultSet.<init>(Unknown Source) ~[impala-jdbc41-2.5.14.1016.jar:ImpalaJDBC_2.5.14.1016]
        at com.cloudera.impala.hivecommon.dataengine.HiveJDBCNativeQueryExecutor.executeQuery(Unknown Source) ~[impala-jdbc41-2.5.14.1016.jar:ImpalaJDBC_2.5.14.1016]
        at com.cloudera.impala.hivecommon.dataengine.HiveJDBCQueryExecutorWithLimitZeroPreparedStatementMetadata.execute(Unknown Source) ~[impala-jdbc41-2.5.14.1016.jar:ImpalaJDBC_2.5.14.1016]
        at com.cloudera.impala.jdbc.common.SPreparedStatement.executeWithParams(Unknown Source) ~[impala-jdbc41-2.5.14.1016.jar:ImpalaJDBC_2.5.14.1016]
        at com.cloudera.impala.jdbc.common.SPreparedStatement.executeQuery(Unknown Source) ~[impala-jdbc41-2.5.14.1016.jar:ImpalaJDBC_2.5.14.1016]
        at com.atscale.engine.connection.pool.jdbc.EngineJdbcPreparedStatement$$anonfun$executeQuery$1.apply(EngineJdbcPreparedStatement.scala:32) ~[engine-core_2.10-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
        at com.atscale.engine.connection.pool.jdbc.EngineJdbcPreparedStatement$$anonfun$executeQuery$1.apply(EngineJdbcPreparedStatement.scala:32) ~[engine-core_2.10-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
        at scala.util.Try$.apply(Try.scala:161) ~[na:na]
        at com.atscale.engine.connection.pool.jdbc.FutureWrapped$$anonfun$futureWrapOnTimeout$1.apply$mcZ$sp(FutureWrapped.scala:50) ~[engine-core_2.10-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
        at com.atscale.engine.connection.pool.jdbc.FutureWrapped$$anonfun$futureWrapOnTimeout$1.apply(FutureWrapped.scala:49) ~[engine-core_2.10-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
        at com.atscale.engine.connection.pool.jdbc.FutureWrapped$$anonfun$futureWrapOnTimeout$1.apply(FutureWrapped.scala:49) ~[engine-core_2.10-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
        at scala.concurrent.impl.Future$PromiseCompletingRunnable.liftedTree1$1(Future.scala:24) ~[na:na]
        at scala.concurrent.impl.Future$PromiseCompletingRunnable.run(Future.scala:24) ~[na:na]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) ~[na:1.8.0_05]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) ~[na:1.8.0_05]
Caused by: com.cloudera.impala.support.exceptions.GeneralException: [Simba][ImpalaJDBCDriver](500002) Error setting metadata result set: Metadata Result Set Error.
        ... 16 common frames omitted
Caused by: java.lang.NullPointerException: null
        at com.cloudera.impala.hivecommon.api.HS2Client.fullColumnTypeNameBuilder(Unknown Source) ~[impala-jdbc41-2.5.14.1016.jar:ImpalaJDBC_2.5.14.1016]
        at com.cloudera.impala.hivecommon.api.HS2Client.getResultSetMetadata(Unknown Source) ~[impala-jdbc41-2.5.14.1016.jar:ImpalaJDBC_2.5.14.1016]
        at com.cloudera.impala.hivecommon.dataengine.HiveJDBCResultSet.<init>(Unknown Source) ~[impala-jdbc41-2.5.14.1016.jar:ImpalaJDBC_2.5.14.1016]
        at com.cloudera.impala.hivecommon.dataengine.HiveJDBCNativeQueryExecutor.executeQuery(Unknown Source) ~[impala-jdbc41-2.5.14.1016.jar:ImpalaJDBC_2.5.14.1016]
        at com.cloudera.impala.hivecommon.dataengine.HiveJDBCQueryExecutorWithLimitZeroPreparedStatementMetadata.execute(Unknown Source) ~[impala-jdbc41-2.5.14.1016.jar:ImpalaJDBC_2.5.14.1016]
        at com.cloudera.impala.jdbc.common.SPreparedStatement.executeWithParams(Unknown Source) ~[impala-jdbc41-2.5.14.1016.jar:ImpalaJDBC_2.5.14.1016]
        at com.cloudera.impala.jdbc.common.SPreparedStatement.executeQuery(Unknown Source) ~[impala-jdbc41-2.5.14.1016.jar:ImpalaJDBC_2.5.14.1016]
        at com.atscale.engine.connection.pool.jdbc.EngineJdbcPreparedStatement$$anonfun$executeQuery$1.apply(EngineJdbcPreparedStatement.scala:32) ~[engine-core_2.10-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
        at com.atscale.engine.connection.pool.jdbc.EngineJdbcPreparedStatement$$anonfun$executeQuery$1.apply(EngineJdbcPreparedStatement.scala:32) ~[engine-core_2.10-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
        at scala.util.Try$.apply(Try.scala:161) ~[na:na]
        at com.atscale.engine.connection.pool.jdbc.FutureWrapped$$anonfun$futureWrapOnTimeout$1.apply$mcZ$sp(FutureWrapped.scala:50) ~[engine-core_2.10-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
        at com.atscale.engine.connection.pool.jdbc.FutureWrapped$$anonfun$futureWrapOnTimeout$1.apply(FutureWrapped.scala:49) ~[engine-core_2.10-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
        at com.atscale.engine.connection.pool.jdbc.FutureWrapped$$anonfun$futureWrapOnTimeout$1.apply(FutureWrapped.scala:49) ~[engine-core_2.10-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
        at scala.concurrent.impl.Future$PromiseCompletingRunnable.liftedTree1$1(Future.scala:24) ~[na:na]
        at scala.concurrent.impl.Future$PromiseCompletingRunnable.run(Future.scala:24) ~[na:na]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) ~[na:1.8.0_05]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) ~[na:1.8.0_05]
        at java.lang.Thread.run(Thread.java:745) ~[na:1.8.0_05]