Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-1613

Impala Driver Struggles with Tables with Decimals

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • Impala 1.4
    • Impala 2.0
    • None
    • None

    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]
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            dyross David Ross
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: