[ https://issues.apache.org/jira/browse/HIVE-6535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15223147#comment-15223147 ]
Hive QA commented on HIVE-6535: ------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12796424/HIVE-6535.1.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 113 failed/errored test(s), 9936 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_index_bitmap3 org.apache.hadoop.hive.hooks.TestHs2Hooks.testHookContexts org.apache.hive.beeline.TestBeeLineWithArgs.org.apache.hive.beeline.TestBeeLineWithArgs org.apache.hive.beeline.cli.TestHiveCli.testCmd org.apache.hive.beeline.cli.TestHiveCli.testDatabaseOptions org.apache.hive.beeline.cli.TestHiveCli.testInvalidOptions2 org.apache.hive.beeline.cli.TestHiveCli.testNoErrorDB org.apache.hive.beeline.cli.TestHiveCli.testSetHeaderValue org.apache.hive.beeline.cli.TestHiveCli.testSetPromptValue org.apache.hive.beeline.cli.TestHiveCli.testSourceCmd org.apache.hive.beeline.cli.TestHiveCli.testSourceCmd2 org.apache.hive.beeline.cli.TestHiveCli.testSourceCmd3 org.apache.hive.beeline.cli.TestHiveCli.testSqlFromCmd org.apache.hive.beeline.cli.TestHiveCli.testSqlFromCmdWithDBName org.apache.hive.beeline.cli.TestHiveCli.testVariablesForSource org.apache.hive.jdbc.TestJdbcDriver2.setAutoCommitOnClosedConnection org.apache.hive.jdbc.TestJdbcDriver2.testAutoCommit org.apache.hive.jdbc.TestJdbcDriver2.testBadURL org.apache.hive.jdbc.TestJdbcDriver2.testBuiltInUDFCol org.apache.hive.jdbc.TestJdbcDriver2.testCloseResultSet org.apache.hive.jdbc.TestJdbcDriver2.testDataTypes org.apache.hive.jdbc.TestJdbcDriver2.testDataTypes2 org.apache.hive.jdbc.TestJdbcDriver2.testDatabaseMetaData org.apache.hive.jdbc.TestJdbcDriver2.testDescribeTable org.apache.hive.jdbc.TestJdbcDriver2.testDriverProperties org.apache.hive.jdbc.TestJdbcDriver2.testDuplicateColumnNameOrder org.apache.hive.jdbc.TestJdbcDriver2.testErrorDiag org.apache.hive.jdbc.TestJdbcDriver2.testErrorMessages org.apache.hive.jdbc.TestJdbcDriver2.testExecutePreparedStatement org.apache.hive.jdbc.TestJdbcDriver2.testExecuteQueryException org.apache.hive.jdbc.TestJdbcDriver2.testExplainStmt org.apache.hive.jdbc.TestJdbcDriver2.testExprCol org.apache.hive.jdbc.TestJdbcDriver2.testFetchFirstDfsCmds org.apache.hive.jdbc.TestJdbcDriver2.testFetchFirstError org.apache.hive.jdbc.TestJdbcDriver2.testFetchFirstNonMR org.apache.hive.jdbc.TestJdbcDriver2.testFetchFirstQuery org.apache.hive.jdbc.TestJdbcDriver2.testFetchFirstSetCmds org.apache.hive.jdbc.TestJdbcDriver2.testGetQueryLog org.apache.hive.jdbc.TestJdbcDriver2.testGetQueryLogOnDisabledLog org.apache.hive.jdbc.TestJdbcDriver2.testImportedKeys org.apache.hive.jdbc.TestJdbcDriver2.testIntervalTypes org.apache.hive.jdbc.TestJdbcDriver2.testInvalidURL org.apache.hive.jdbc.TestJdbcDriver2.testMetaDataGetCatalogs org.apache.hive.jdbc.TestJdbcDriver2.testMetaDataGetClassicTableTypes org.apache.hive.jdbc.TestJdbcDriver2.testMetaDataGetColumns org.apache.hive.jdbc.TestJdbcDriver2.testMetaDataGetColumnsMetaData org.apache.hive.jdbc.TestJdbcDriver2.testMetaDataGetExternalTables org.apache.hive.jdbc.TestJdbcDriver2.testMetaDataGetHiveTableTypes org.apache.hive.jdbc.TestJdbcDriver2.testMetaDataGetSchemas org.apache.hive.jdbc.TestJdbcDriver2.testMetaDataGetTableTypes org.apache.hive.jdbc.TestJdbcDriver2.testMetaDataGetTables org.apache.hive.jdbc.TestJdbcDriver2.testMetaDataGetTablesClassic org.apache.hive.jdbc.TestJdbcDriver2.testMetaDataGetTablesHive org.apache.hive.jdbc.TestJdbcDriver2.testNonAsciiReturnValues org.apache.hive.jdbc.TestJdbcDriver2.testNullResultSet org.apache.hive.jdbc.TestJdbcDriver2.testNullType org.apache.hive.jdbc.TestJdbcDriver2.testOutOfBoundCols org.apache.hive.jdbc.TestJdbcDriver2.testParentReferences org.apache.hive.jdbc.TestJdbcDriver2.testParseUrlHttpMode org.apache.hive.jdbc.TestJdbcDriver2.testPostClose org.apache.hive.jdbc.TestJdbcDriver2.testPrepareSetDate org.apache.hive.jdbc.TestJdbcDriver2.testPrepareSetTimestamp org.apache.hive.jdbc.TestJdbcDriver2.testPrepareStatement org.apache.hive.jdbc.TestJdbcDriver2.testPrimaryKeys org.apache.hive.jdbc.TestJdbcDriver2.testProcCols org.apache.hive.jdbc.TestJdbcDriver2.testProccedures org.apache.hive.jdbc.TestJdbcDriver2.testQueryCancel org.apache.hive.jdbc.TestJdbcDriver2.testResultSetColumnNameCaseInsensitive org.apache.hive.jdbc.TestJdbcDriver2.testResultSetMetaData org.apache.hive.jdbc.TestJdbcDriver2.testResultSetMetaDataDuplicateColumnNames org.apache.hive.jdbc.TestJdbcDriver2.testSelectAll org.apache.hive.jdbc.TestJdbcDriver2.testSelectAllFetchSize org.apache.hive.jdbc.TestJdbcDriver2.testSelectAllFromView org.apache.hive.jdbc.TestJdbcDriver2.testSelectAllMaxRows org.apache.hive.jdbc.TestJdbcDriver2.testSelectAllPartioned org.apache.hive.jdbc.TestJdbcDriver2.testSetCommand org.apache.hive.jdbc.TestJdbcDriver2.testSetOnConnection org.apache.hive.jdbc.TestJdbcDriver2.testShowColumns org.apache.hive.jdbc.TestJdbcDriver2.testShowGrant org.apache.hive.jdbc.TestJdbcDriver2.testShowRoleGrant org.apache.hive.jdbc.TestJdbcDriver2.testShowTables org.apache.hive.jdbc.TestJdbcDriver2.testURLWithFetchSize org.apache.hive.jdbc.TestJdbcDriver2.testUnsupportedFetchTypes org.apache.hive.jdbc.TestJdbcWithLocalClusterSpark.testConnection org.apache.hive.jdbc.TestJdbcWithLocalClusterSpark.testNonSparkQuery org.apache.hive.jdbc.TestJdbcWithLocalClusterSpark.testPermFunc org.apache.hive.jdbc.TestJdbcWithLocalClusterSpark.testSparkQuery org.apache.hive.jdbc.TestJdbcWithLocalClusterSpark.testTempTable org.apache.hive.jdbc.TestJdbcWithMiniHS2.testAddJarDataNucleusUnCaching org.apache.hive.jdbc.TestJdbcWithMiniHS2.testConcurrentStatements org.apache.hive.jdbc.TestJdbcWithMiniHS2.testConnection org.apache.hive.jdbc.TestJdbcWithMiniHS2.testURIDatabaseName org.apache.hive.jdbc.TestJdbcWithMiniHS2.testUdfWhiteList org.apache.hive.jdbc.TestJdbcWithMiniMr.testConnection org.apache.hive.jdbc.TestJdbcWithMiniMr.testMrQuery org.apache.hive.jdbc.TestJdbcWithMiniMr.testNonMrQuery org.apache.hive.jdbc.TestJdbcWithMiniMr.testPermFunc org.apache.hive.jdbc.TestJdbcWithMiniMr.testTempTable org.apache.hive.jdbc.TestMultiSessionsHS2WithLocalClusterSpark.testNonSparkQuery org.apache.hive.jdbc.TestMultiSessionsHS2WithLocalClusterSpark.testSparkQuery org.apache.hive.jdbc.TestSSL.testSSLFetch org.apache.hive.jdbc.TestSSL.testSSLFetchHttp org.apache.hive.jdbc.TestServiceDiscoveryWithMiniHS2.testConnectionWithConfigsPublished org.apache.hive.jdbc.TestServiceDiscoveryWithMiniHS2.testConnectionWithoutConfigsPublished org.apache.hive.jdbc.authorization.TestHS2AuthzContext.testAuthzContextContentsDriverCmd org.apache.hive.jdbc.authorization.TestJdbcMetadataApiAuth.testMetaApiAllowed org.apache.hive.jdbc.authorization.TestJdbcWithSQLAuthUDFBlacklist.testBlackListedUdfUsage org.apache.hive.jdbc.authorization.TestJdbcWithSQLAuthorization.testAuthorization1 org.apache.hive.minikdc.TestHs2HooksWithMiniKdc.testHookContexts org.apache.hive.minikdc.TestJdbcWithMiniKdcCookie.testCookie org.apache.hive.minikdc.TestJdbcWithMiniKdcSQLAuthBinary.testAuthorization1 org.apache.hive.minikdc.TestJdbcWithMiniKdcSQLAuthHttp.testAuthorization1 org.apache.hive.service.TestHS2ImpersonationWithRemoteMS.testImpersonation {noformat} Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/7451/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/7451/console Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-7451/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 113 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12796424 - PreCommit-HIVE-TRUNK-Build > JDBC: async wait should happen during fetch for results > ------------------------------------------------------- > > Key: HIVE-6535 > URL: https://issues.apache.org/jira/browse/HIVE-6535 > Project: Hive > Issue Type: Improvement > Components: HiveServer2, JDBC > Affects Versions: 0.14.0, 1.2.1, 2.0.0 > Reporter: Thejas M Nair > Assignee: Vaibhav Gumashta > Attachments: HIVE-6535.1.patch > > > The hive jdbc client waits query completion during execute() call. It would > be better to block in the jdbc for completion when the results are being > fetched. > This way the application using hive jdbc driver can do other tasks while > asynchronous query execution is happening, until it needs to fetch the result > set. > -- This message was sent by Atlassian JIRA (v6.3.4#6332)