[
https://issues.apache.org/jira/browse/HIVE-20830?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Daniel Dai updated HIVE-20830:
------------------------------
Status: Patch Available (was: Open)
> JdbcStorageHandler range query assertion failure in some cases
> --------------------------------------------------------------
>
> Key: HIVE-20830
> URL: https://issues.apache.org/jira/browse/HIVE-20830
> Project: Hive
> Issue Type: Bug
> Components: StorageHandler
> Reporter: Daniel Dai
> Assignee: Daniel Dai
> Priority: Major
> Attachments: HIVE-20830.1.patch
>
>
> {code}
> 2018-10-29T10:10:16,325 ERROR [b4bf5eb2-a986-4aae-908e-93b9908acd32
> HiveServer2-HttpHandler-Pool: Thread-124]: dao.GenericJdbcDatabaseAccessor
> (:()) - Caught exception while trying to execute query
> java.lang.IllegalArgumentException: null
> at
> com.google.common.base.Preconditions.checkArgument(Preconditions.java:108)
> ~[guava-19.0.jar:?]
> at
> org.apache.hive.storage.jdbc.dao.GenericJdbcDatabaseAccessor.addBoundaryToQuery(GenericJdbcDatabaseAccessor.java:238)
> ~[hive-jdbc-handler-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-99]
> at
> org.apache.hive.storage.jdbc.dao.GenericJdbcDatabaseAccessor.getRecordIterator(GenericJdbcDatabaseAccessor.java:161)
> ~[hive-jdbc-handler-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-99]
> at
> org.apache.hive.storage.jdbc.JdbcRecordReader.next(JdbcRecordReader.java:58)
> ~[hive-jdbc-handler-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-99]
> at
> org.apache.hive.storage.jdbc.JdbcRecordReader.next(JdbcRecordReader.java:35)
> ~[hive-jdbc-handler-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-99]
> at
> org.apache.hadoop.hive.ql.exec.FetchOperator.getNextRow(FetchOperator.java:569)
> ~[hive-exec-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-150]
> at
> org.apache.hadoop.hive.ql.exec.FetchOperator.pushRow(FetchOperator.java:509)
> ~[hive-exec-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-150]
> at org.apache.hadoop.hive.ql.exec.FetchTask.fetch(FetchTask.java:146)
> ~[hive-exec-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-150]
> at org.apache.hadoop.hive.ql.Driver.getResults(Driver.java:2734)
> ~[hive-exec-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-150]
> at
> org.apache.hadoop.hive.ql.reexec.ReExecDriver.getResults(ReExecDriver.java:229)
> ~[hive-exec-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-150]
> at
> org.apache.hive.service.cli.operation.SQLOperation.getNextRowSet(SQLOperation.java:469)
> ~[hive-service-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-150]
> at
> org.apache.hive.service.cli.operation.OperationManager.getOperationNextRowSet(OperationManager.java:328)
> ~[hive-service-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-150]
> at
> org.apache.hive.service.cli.session.HiveSessionImpl.fetchResults(HiveSessionImpl.java:910)
> ~[hive-service-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-150]
> at
> org.apache.hive.service.cli.CLIService.fetchResults(CLIService.java:564)
> ~[hive-service-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-150]
> at
> org.apache.hive.service.cli.thrift.ThriftCLIService.FetchResults(ThriftCLIService.java:790)
> ~[hive-service-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-150]
> at
> org.apache.hive.service.rpc.thrift.TCLIService$Processor$FetchResults.getResult(TCLIService.java:1837)
> ~[hive-exec-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-150]
> at
> org.apache.hive.service.rpc.thrift.TCLIService$Processor$FetchResults.getResult(TCLIService.java:1822)
> ~[hive-exec-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-150]
> at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
> ~[hive-exec-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-150]
> at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
> ~[hive-exec-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-150]
> at org.apache.thrift.server.TServlet.doPost(TServlet.java:83)
> ~[hive-exec-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-150]
> at
> org.apache.hive.service.cli.thrift.ThriftHttpServlet.doPost(ThriftHttpServlet.java:208)
> ~[hive-service-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-150]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
> ~[javax.servlet-api-3.1.0.jar:3.1.0]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
> ~[javax.servlet-api-3.1.0.jar:3.1.0]
> at
> org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:848)
> ~[jetty-runner-9.3.20.v20170531.jar:9.3.20.v20170531]
> at
> org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:584)
> ~[jetty-runner-9.3.20.v20170531.jar:9.3.20.v20170531]
> at
> org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224)
> ~[jetty-runner-9.3.20.v20170531.jar:9.3.20.v20170531]
> at
> org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1180)
> ~[jetty-runner-9.3.20.v20170531.jar:9.3.20.v20170531]
> at
> org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:512)
> ~[jetty-runner-9.3.20.v20170531.jar:9.3.20.v20170531]
> at
> org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
> ~[jetty-runner-9.3.20.v20170531.jar:9.3.20.v20170531]
> at
> org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1112)
> ~[jetty-runner-9.3.20.v20170531.jar:9.3.20.v20170531]
> at
> org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
> ~[jetty-runner-9.3.20.v20170531.jar:9.3.20.v20170531]
> at
> org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:493)
> ~[jetty-runner-9.3.20.v20170531.jar:9.3.20.v20170531]
> at
> org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134)
> ~[jetty-runner-9.3.20.v20170531.jar:9.3.20.v20170531]
> at org.eclipse.jetty.server.Server.handle(Server.java:534)
> ~[jetty-runner-9.3.20.v20170531.jar:9.3.20.v20170531]
> at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:320)
> ~[jetty-runner-9.3.20.v20170531.jar:9.3.20.v20170531]
> at
> org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:251)
> ~[jetty-runner-9.3.20.v20170531.jar:9.3.20.v20170531]
> at
> org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:283)
> ~[jetty-io-9.3.20.v20170531.jar:9.3.20.v20170531]
> at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:108)
> ~[jetty-io-9.3.20.v20170531.jar:9.3.20.v20170531]
> at
> org.eclipse.jetty.io.ssl.SslConnection.onFillable(SslConnection.java:251)
> ~[jetty-io-9.3.20.v20170531.jar:9.3.20.v20170531]
> at
> org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:283)
> ~[jetty-io-9.3.20.v20170531.jar:9.3.20.v20170531]
> at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:108)
> ~[jetty-io-9.3.20.v20170531.jar:9.3.20.v20170531]
> at
> org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93)
> ~[jetty-io-9.3.20.v20170531.jar:9.3.20.v20170531]
> at
> org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.executeProduceConsume(ExecuteProduceConsume.java:303)
> ~[jetty-runner-9.3.20.v20170531.jar:9.3.20.v20170531]
> at
> org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceConsume(ExecuteProduceConsume.java:148)
> ~[jetty-runner-9.3.20.v20170531.jar:9.3.20.v20170531]
> at
> org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:136)
> ~[jetty-runner-9.3.20.v20170531.jar:9.3.20.v20170531]
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
> ~[?:1.8.0_161]
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
> ~[?:1.8.0_161]
> at java.lang.Thread.run(Thread.java:748) [?:1.8.0_161]
> 2018-10-29T10:10:16,325 ERROR [b4bf5eb2-a986-4aae-908e-93b9908acd32
> HiveServer2-HttpHandler-Pool: Thread-124]: jdbc.JdbcRecordReader (:()) - An
> error occurred while reading the next record from DB.
> org.apache.hive.storage.jdbc.exception.HiveJdbcDatabaseAccessException:
> Caught exception while trying to execute query
> at
> org.apache.hive.storage.jdbc.dao.GenericJdbcDatabaseAccessor.getRecordIterator(GenericJdbcDatabaseAccessor.java:177)
> ~[hive-jdbc-handler-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-99]
> at
> org.apache.hive.storage.jdbc.JdbcRecordReader.next(JdbcRecordReader.java:58)
> ~[hive-jdbc-handler-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-99]
> at
> org.apache.hive.storage.jdbc.JdbcRecordReader.next(JdbcRecordReader.java:35)
> ~[hive-jdbc-handler-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-99]
> at
> org.apache.hadoop.hive.ql.exec.FetchOperator.getNextRow(FetchOperator.java:569)
> ~[hive-exec-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-150]
> at
> org.apache.hadoop.hive.ql.exec.FetchOperator.pushRow(FetchOperator.java:509)
> ~[hive-exec-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-150]
> at org.apache.hadoop.hive.ql.exec.FetchTask.fetch(FetchTask.java:146)
> ~[hive-exec-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-150]
> at org.apache.hadoop.hive.ql.Driver.getResults(Driver.java:2734)
> ~[hive-exec-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-150]
> at
> org.apache.hadoop.hive.ql.reexec.ReExecDriver.getResults(ReExecDriver.java:229)
> ~[hive-exec-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-150]
> at
> org.apache.hive.service.cli.operation.SQLOperation.getNextRowSet(SQLOperation.java:469)
> ~[hive-service-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-150]
> at
> org.apache.hive.service.cli.operation.OperationManager.getOperationNextRowSet(OperationManager.java:328)
> ~[hive-service-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-150]
> at
> org.apache.hive.service.cli.session.HiveSessionImpl.fetchResults(HiveSessionImpl.java:910)
> ~[hive-service-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-150]
> at
> org.apache.hive.service.cli.CLIService.fetchResults(CLIService.java:564)
> ~[hive-service-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-150]
> at
> org.apache.hive.service.cli.thrift.ThriftCLIService.FetchResults(ThriftCLIService.java:790)
> ~[hive-service-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-150]
> at
> org.apache.hive.service.rpc.thrift.TCLIService$Processor$FetchResults.getResult(TCLIService.java:1837)
> ~[hive-exec-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-150]
> at
> org.apache.hive.service.rpc.thrift.TCLIService$Processor$FetchResults.getResult(TCLIService.java:1822)
> ~[hive-exec-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-150]
> at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
> ~[hive-exec-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-150]
> at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
> ~[hive-exec-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-150]
> at org.apache.thrift.server.TServlet.doPost(TServlet.java:83)
> ~[hive-exec-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-150]
> at
> org.apache.hive.service.cli.thrift.ThriftHttpServlet.doPost(ThriftHttpServlet.java:208)
> ~[hive-service-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-150]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
> ~[javax.servlet-api-3.1.0.jar:3.1.0]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
> ~[javax.servlet-api-3.1.0.jar:3.1.0]
> at
> org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:848)
> ~[jetty-runner-9.3.20.v20170531.jar:9.3.20.v20170531]
> at
> org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:584)
> ~[jetty-runner-9.3.20.v20170531.jar:9.3.20.v20170531]
> at
> org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224)
> ~[jetty-runner-9.3.20.v20170531.jar:9.3.20.v20170531]
> at
> org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1180)
> ~[jetty-runner-9.3.20.v20170531.jar:9.3.20.v20170531]
> at
> org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:512)
> ~[jetty-runner-9.3.20.v20170531.jar:9.3.20.v20170531]
> at
> org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
> ~[jetty-runner-9.3.20.v20170531.jar:9.3.20.v20170531]
> at
> org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1112)
> ~[jetty-runner-9.3.20.v20170531.jar:9.3.20.v20170531]
> at
> org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
> ~[jetty-runner-9.3.20.v20170531.jar:9.3.20.v20170531]
> at
> org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:493)
> ~[jetty-runner-9.3.20.v20170531.jar:9.3.20.v20170531]
> at
> org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134)
> ~[jetty-runner-9.3.20.v20170531.jar:9.3.20.v20170531]
> at org.eclipse.jetty.server.Server.handle(Server.java:534)
> ~[jetty-runner-9.3.20.v20170531.jar:9.3.20.v20170531]
> at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:320)
> ~[jetty-runner-9.3.20.v20170531.jar:9.3.20.v20170531]
> at
> org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:251)
> ~[jetty-runner-9.3.20.v20170531.jar:9.3.20.v20170531]
> at
> org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:283)
> ~[jetty-io-9.3.20.v20170531.jar:9.3.20.v20170531]
> at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:108)
> ~[jetty-io-9.3.20.v20170531.jar:9.3.20.v20170531]
> at
> org.eclipse.jetty.io.ssl.SslConnection.onFillable(SslConnection.java:251)
> ~[jetty-io-9.3.20.v20170531.jar:9.3.20.v20170531]
> at
> org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:283)
> ~[jetty-io-9.3.20.v20170531.jar:9.3.20.v20170531]
> at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:108)
> ~[jetty-io-9.3.20.v20170531.jar:9.3.20.v20170531]
> at
> org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93)
> ~[jetty-io-9.3.20.v20170531.jar:9.3.20.v20170531]
> at
> org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.executeProduceConsume(ExecuteProduceConsume.java:303)
> ~[jetty-runner-9.3.20.v20170531.jar:9.3.20.v20170531]
> at
> org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceConsume(ExecuteProduceConsume.java:148)
> ~[jetty-runner-9.3.20.v20170531.jar:9.3.20.v20170531]
> at
> org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:136)
> ~[jetty-runner-9.3.20.v20170531.jar:9.3.20.v20170531]
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
> ~[?:1.8.0_161]
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
> ~[?:1.8.0_161]
> at java.lang.Thread.run(Thread.java:748) [?:1.8.0_161]
> Caused by: java.lang.IllegalArgumentException
> at
> com.google.common.base.Preconditions.checkArgument(Preconditions.java:108)
> ~[guava-19.0.jar:?]
> at
> org.apache.hive.storage.jdbc.dao.GenericJdbcDatabaseAccessor.addBoundaryToQuery(GenericJdbcDatabaseAccessor.java:238)
> ~[hive-jdbc-handler-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-99]
> at
> org.apache.hive.storage.jdbc.dao.GenericJdbcDatabaseAccessor.getRecordIterator(GenericJdbcDatabaseAccessor.java:161)
> ~[hive-jdbc-handler-3.1.0.3.0.3.0-150.jar:3.1.0.3.0.3.0-99]
> ... 45 more
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
