You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Hive QA (JIRA)" <ji...@apache.org> on 2017/02/22 19:05:44 UTC

[jira] [Commented] (HIVE-13864) Beeline ignores the command that follows a semicolon and comment

    [ https://issues.apache.org/jira/browse/HIVE-13864?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15878993#comment-15878993 ] 

Hive QA commented on HIVE-13864:
--------------------------------



Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12854006/HIVE-13864.3.patch

{color:green}SUCCESS:{color} +1 due to 2 test(s) being added or modified.

{color:red}ERROR:{color} -1 due to 4 failed/errored test(s), 10254 tests executed
*Failed tests:*
{noformat}
TestDerbyConnector - did not produce a TEST-*.xml file (likely timed out) (batchId=235)
org.apache.hadoop.hive.cli.TestEncryptedHDFSCliDriver.testCliDriver[encryption_join_with_different_encryption_keys] (batchId=159)
org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query14] (batchId=223)
org.apache.hive.beeline.TestBeeLineWithArgs.testQueryProgressParallel (batchId=211)
{noformat}

Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/3696/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/3696/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-3696/

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: NonZeroExitCodeException
Command 'cd /data/hiveptest/logs/PreCommit-HIVE-Build-3696/ && tar -zvcf test-results.tar.gz test-results/' failed with exit status 2 and output 'test-results/
test-results/TEST-261_UTBatch_ql_10_tests-TEST-org.apache.hadoop.hive.ql.exec.vector.expressions.gen.TestColumnScalarOperationVectorExpressionEvaluation.xml
test-results/TEST-276_UTBatch_serde_20_tests-TEST-org.apache.hadoop.hive.serde2.avro.TestThatEvolvedSchemasActAsWeWant.xml
test-results/TEST-271_UTBatch_ql_10_tests-TEST-org.apache.hadoop.hive.ql.lockmgr.zookeeper.TestZookeeperLockManager.xml
test-results/TEST-195_UTBatch_itests__hive-unit_9_tests-TEST-org.apache.hadoop.hive.metastore.TestMetaStoreConnectionUrlHook.xml
test-results/TEST-182_UTBatch_hcatalog__streaming_16_tests-TEST-org.apache.hive.hcatalog.streaming.mutate.worker.TestRecordInspectorImpl.xml
test-results/TEST-252_UTBatch_ql_10_tests-TEST-org.apache.hadoop.hive.ql.parse.TestSplitSample.xml
test-results/TEST-262_UTBatch_ql_10_tests-TEST-org.apache.hadoop.hive.ql.exec.vector.TestVectorSerDeRow.xml
test-results/TEST-241_UTBatch_ql_10_tests-TEST-org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFBridge.xml
test-results/TEST-169_UTBatch_storage-api_13_tests-TEST-org.apache.hadoop.hive.ql.exec.vector.TestBytesColumnVector.xml
test-results/TEST-182_UTBatch_hcatalog__streaming_16_tests-TEST-org.apache.hive.hcatalog.streaming.mutate.worker.TestMutatorCoordinator.xml
test-results/TEST-213_UTBatch_itests__hive-unit_9_tests-TEST-org.apache.hive.service.TestHS2ImpersonationWithRemoteMS.xml
test-results/TEST-210_UTBatch_itests__hive-unit_9_tests-TEST-org.apache.hadoop.hive.ql.security.TestStorageBasedMetastoreAuthorizationReads.xml
test-results/TEST-185_UTBatch_service_8_tests-TEST-org.apache.hive.service.auth.TestLdapAtnProviderWithMiniDS.xml
test-results/TEST-275_UTBatch_serde_20_tests-TEST-org.apache.hadoop.hive.serde2.objectinspector.TestStandardObjectInspectors.xml
test-results/TEST-199_UTBatch_itests__hive-unit_9_tests-TEST-org.apache.hadoop.hive.metastore.hbase.TestHBaseSchemaTool2.xml
test-results/TEST-65-TestCliDriver-cbo_rp_join1.q-materialized_view_create.q-orc_ppd_varchar.q-and-27-more-TEST-org.apache.hadoop.hive.cli.TestCliDriver.xml
test-results/TEST-277_UTBatch_serde_6_tests-TEST-org.apache.hadoop.hive.serde2.columnar.TestLazyBinaryColumnarSerDe.xml
test-results/TEST-122-TestSparkCliDriver-auto_sortmerge_join_13.q-join4.q-join35.q-and-12-more-TEST-org.apache.hadoop.hive.cli.TestSparkCliDriver.xml
test-results/TEST-106-TestSparkCliDriver-bucketsortoptimize_insert_4.q-multi_insert_mixed.q-vectorization_10.q-and-12-more-TEST-org.apache.hadoop.hive.cli.TestSparkCliDriver.xml
test-results/TEST-252_UTBatch_ql_10_tests-TEST-org.apache.hadoop.hive.ql.parse.positive.TestTransactionStatement.xml
test-results/TEST-49-TestCliDriver-intersect_all.q-join39.q-bucketsortoptimize_insert_7.q-and-27-more-TEST-org.apache.hadoop.hive.cli.TestCliDriver.xml
test-results/TEST-275_UTBatch_serde_20_tests-TEST-org.apache.hadoop.hive.serde2.lazy.TestLazyArrayMapStruct.xml
test-results/TEST-167_UTBatch_cli_4_tests-TEST-org.apache.hadoop.hive.cli.TestCliDriverMethods.xml
test-results/TEST-104-TestSparkCliDriver-skewjoinopt19.q-order.q-join_merge_multi_expressions.q-and-12-more-TEST-org.apache.hadoop.hive.cli.TestSparkCliDriver.xml
test-results/TEST-208_UTBatch_itests__hive-unit_9_tests-TEST-org.apache.hadoop.hive.ql.metadata.TestSemanticAnalyzerHookLoading.xml
test-results/TEST-276_UTBatch_serde_20_tests-TEST-org.apache.hadoop.hive.serde2.lazybinary.TestLazyBinarySerDe.xml
test-results/TEST-242_UTBatch_ql_10_tests-TEST-org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFSha2.xml
test-results/TEST-271_UTBatch_ql_10_tests-TEST-org.apache.hadoop.hive.ql.lockmgr.TestDbTxnManager.xml
test-results/TEST-278_UTBatch_llap-server_14_tests-TEST-org.apache.hadoop.hive.llap.daemon.impl.TestEvictingPriorityBlockingQueue.xml
test-results/TEST-278_UTBatch_llap-server_14_tests-TEST-org.apache.hadoop.hive.llap.daemon.services.impl.TestLlapWebServices.xml
test-results/TEST-188_UTBatch_metastore_12_tests-TEST-org.apache.hadoop.hive.metastore.hbase.TestHBaseFilterPlanUtil.xml
test-results/TEST-238_UTBatch_ql_10_tests-TEST-org.apache.hadoop.hive.ql.udf.TestBlockedUdf.xml
test-results/TEST-188_UTBatch_metastore_12_tests-TEST-org.apache.hadoop.hive.metastore.hbase.TestHBaseAggregateStatsNDVUniformDist.xml
test-results/TEST-208_UTBatch_itests__hive-unit_9_tests-TEST-org.apache.hadoop.hive.ql.security.TestStorageBasedMetastoreAuthorizationProvider.xml
test-results/TEST-277_UTBatch_serde_6_tests-TEST-org.apache.hadoop.hive.serde2.columnar.TestBytesRefArrayWritable.xml
test-results/TEST-211_UTBatch_itests__hive-unit_9_tests-TEST-org.apache.hive.beeline.hs2connection.TestBeelineWithUserHs2ConnectionFile.xml
test-results/TEST-276_UTBatch_serde_20_tests-TEST-org.apache.hadoop.hive.serde2.avro.TestAvroObjectInspectorGenerator.xml
test-results/TEST-240_UTBatch_ql_10_tests-TEST-org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFBRound.xml
test-results/TEST-246_UTBatch_ql_10_tests-TEST-org.apache.hadoop.hive.ql.io.sarg.TestSearchArgumentImpl.xml
test-results/TEST-211_UTBatch_itests__hive-unit_9_tests-TEST-org.apache.hive.beeline.TestSchemaTool.xml
test-results/TEST-275_UTBatch_serde_20_tests-TEST-org.apache.hadoop.hive.serde2.objectinspector.TestObjectInspectorUtils.xml
test-results/TEST-185_UTBatch_service_8_tests-TEST-org.apache.hive.service.auth.ldap.TestUserFilter.xml
test-results/TEST-242_UTBatch_ql_10_tests-TEST-org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFDateSub.xml
test-results/TEST-185_UTBatch_service_8_tests-TEST-org.apache.hive.service.cli.session.TestSessionGlobalInitFile.xml
test-results/TEST-185_UTBatch_service_8_tests-TEST-org.apache.hive.service.auth.ldap.TestQuery.xml
test-results/TEST-171_UTBatch_hcatalog__webhcat__svr_6_tests-TEST-org.apache.hive.hcatalog.templeton.tool.TestTempletonUtils.xml
test-results/TEST-194_TestEmbeddedHiveMetaStore-TEST-org.apache.hadoop.hive.metastore.TestEmbeddedHiveMetaStore.xml
test-results/TEST-217_UTBatch_itests__hive-unit_9_tests-TEST-org.apache.hive.jdbc.TestXSRFFilter.xml
test-results/TEST-278_UTBatch_llap-server_14_tests-TEST-org.apache.hadoop.hive.llap.security.TestLlapSignerImpl.xml
test-results/TEST-241_UTBatch_ql_10_tests-TEST-org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFLevenshtein.xml
'
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12854006 - PreCommit-HIVE-Build

> Beeline ignores the command that follows a semicolon and comment
> ----------------------------------------------------------------
>
>                 Key: HIVE-13864
>                 URL: https://issues.apache.org/jira/browse/HIVE-13864
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Muthu Manickam
>            Assignee: Yongzhi Chen
>         Attachments: HIVE-13864.01.patch, HIVE-13864.02.patch, HIVE-13864.3.patch
>
>
> Beeline ignores the next line/command that follows a command with semicolon and comments.
> Example 1:
> select *
> from table1; -- comments
> select * from table2;
> In this case, only the first command is executed.. second command "select * from table2" is not executed.
> ------
> Example 2:
> select *
> from table1; -- comments
> select * from table2;
> select * from table3;
> In this case, first command and third command is executed. second command "select * from table2" is not executed.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)