[jira] [Commented] (HIVE-10160) Give a warning when grouping or ordering by a constant column
[ https://issues.apache.org/jira/browse/HIVE-10160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14486221#comment-14486221 ] Chao commented on HIVE-10160: - +1 > Give a warning when grouping or ordering by a constant column > - > > Key: HIVE-10160 > URL: https://issues.apache.org/jira/browse/HIVE-10160 > Project: Hive > Issue Type: Improvement > Components: Query Processor >Reporter: Lefty Leverenz >Assignee: Yongzhi Chen >Priority: Minor > Attachments: HIVE-10160.1.patch, HIVE-10160.3.patch, > HIVE-10160.4.patch, HIVE-10160.5.patch > > > To avoid confusion, a warning should be issued when users specify column > positions instead of names in a GROUP BY or ORDER BY clause (unless > hive.groupby.orderby.position.alias is set to true in Hive 0.11.0 or later). -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-10160) Give a warning when grouping or ordering by a constant column
[ https://issues.apache.org/jira/browse/HIVE-10160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14486076#comment-14486076 ] Yongzhi Chen commented on HIVE-10160: - The failures have nothing to do with my change. 1 The 13 TestMiniMr failures appear in other patches too for example: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/3329/console this is for HIVE-9679 2. The TestHCatClient.testPartitionSpecRegistrationWithCustomSchema is not related. I will add unit test when the test framework become fine by separate Jira. [~csun], could you review it? Thanks > Give a warning when grouping or ordering by a constant column > - > > Key: HIVE-10160 > URL: https://issues.apache.org/jira/browse/HIVE-10160 > Project: Hive > Issue Type: Improvement > Components: Query Processor >Reporter: Lefty Leverenz >Assignee: Yongzhi Chen >Priority: Minor > Attachments: HIVE-10160.1.patch, HIVE-10160.3.patch, > HIVE-10160.4.patch, HIVE-10160.5.patch > > > To avoid confusion, a warning should be issued when users specify column > positions instead of names in a GROUP BY or ORDER BY clause (unless > hive.groupby.orderby.position.alias is set to true in Hive 0.11.0 or later). -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-10160) Give a warning when grouping or ordering by a constant column
[
https://issues.apache.org/jira/browse/HIVE-10160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14485799#comment-14485799
]
Hive QA commented on HIVE-10160:
{color:red}Overall{color}: -1 at least one tests failed
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12723776/HIVE-10160.5.patch
{color:red}ERROR:{color} -1 due to 14 failed/errored test(s), 8665 tests
executed
*Failed tests:*
{noformat}
TestMinimrCliDriver-bucketmapjoin6.q-constprog_partitioner.q-infer_bucket_sort_dyn_part.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-external_table_with_space_in_location_path.q-infer_bucket_sort_merge.q-auto_sortmerge_join_16.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-groupby2.q-import_exported_table.q-bucketizedhiveinputformat.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-index_bitmap3.q-stats_counter_partitioned.q-temp_table_external.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-infer_bucket_sort_map_operators.q-join1.q-bucketmapjoin7.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-infer_bucket_sort_num_buckets.q-disable_merge_for_bucketing.q-uber_reduce.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-infer_bucket_sort_reducers_power_two.q-scriptfile1.q-scriptfile1_win.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-leftsemijoin_mr.q-load_hdfs_file_with_space_in_the_name.q-root_dir_external_table.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-list_bucket_dml_10.q-bucket_num_reducers.q-bucket6.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-load_fs2.q-file_with_header_footer.q-ql_rewrite_gbtoidx_cbo_1.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-parallel_orderby.q-reduce_deduplicate.q-ql_rewrite_gbtoidx_cbo_2.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-ql_rewrite_gbtoidx.q-smb_mapjoin_8.q - did not produce a
TEST-*.xml file
TestMinimrCliDriver-schemeAuthority2.q-bucket4.q-input16_cc.q-and-1-more - did
not produce a TEST-*.xml file
org.apache.hive.hcatalog.api.TestHCatClient.testPartitionSpecRegistrationWithCustomSchema
{noformat}
Test results:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/3331/testReport
Console output:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/3331/console
Test logs:
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-3331/
Messages:
{noformat}
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: 14 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12723776 - PreCommit-HIVE-TRUNK-Build
> Give a warning when grouping or ordering by a constant column
> -
>
> Key: HIVE-10160
> URL: https://issues.apache.org/jira/browse/HIVE-10160
> Project: Hive
> Issue Type: Improvement
> Components: Query Processor
>Reporter: Lefty Leverenz
>Assignee: Yongzhi Chen
>Priority: Minor
> Attachments: HIVE-10160.1.patch, HIVE-10160.3.patch,
> HIVE-10160.4.patch, HIVE-10160.5.patch
>
>
> To avoid confusion, a warning should be issued when users specify column
> positions instead of names in a GROUP BY or ORDER BY clause (unless
> hive.groupby.orderby.position.alias is set to true in Hive 0.11.0 or later).
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (HIVE-10160) Give a warning when grouping or ordering by a constant column
[ https://issues.apache.org/jira/browse/HIVE-10160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14484356#comment-14484356 ] Yongzhi Chen commented on HIVE-10160: - The new patch doing following: 1. Only report warning to session console if hive.session.silent is false for in some case clients do not want to see warnings. 2. Always record the warning in hive log. 3. Use more relevant warning messages. 4. Removing new tests for the Minimr tests build errors. > Give a warning when grouping or ordering by a constant column > - > > Key: HIVE-10160 > URL: https://issues.apache.org/jira/browse/HIVE-10160 > Project: Hive > Issue Type: Improvement > Components: Query Processor >Reporter: Lefty Leverenz >Assignee: Yongzhi Chen >Priority: Minor > Attachments: HIVE-10160.1.patch, HIVE-10160.3.patch, > HIVE-10160.4.patch, HIVE-10160.5.patch > > > To avoid confusion, a warning should be issued when users specify column > positions instead of names in a GROUP BY or ORDER BY clause (unless > hive.groupby.orderby.position.alias is set to true in Hive 0.11.0 or later). -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-10160) Give a warning when grouping or ordering by a constant column
[
https://issues.apache.org/jira/browse/HIVE-10160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14483428#comment-14483428
]
Hive QA commented on HIVE-10160:
{color:red}Overall{color}: -1 at least one tests failed
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12723487/HIVE-10160.4.patch
{color:red}ERROR:{color} -1 due to 22 failed/errored test(s), 8648 tests
executed
*Failed tests:*
{noformat}
TestContribNegativeCliDriver - did not produce a TEST-*.xml file
TestMinimrCliDriver-bucketmapjoin6.q-constprog_partitioner.q-infer_bucket_sort_dyn_part.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-external_table_with_space_in_location_path.q-infer_bucket_sort_merge.q-auto_sortmerge_join_16.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-groupby2.q-import_exported_table.q-bucketizedhiveinputformat.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-index_bitmap3.q-stats_counter_partitioned.q-temp_table_external.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-infer_bucket_sort_map_operators.q-join1.q-bucketmapjoin7.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-infer_bucket_sort_num_buckets.q-disable_merge_for_bucketing.q-uber_reduce.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-infer_bucket_sort_reducers_power_two.q-scriptfile1.q-scriptfile1_win.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-leftsemijoin_mr.q-bucket5.q-root_dir_external_table.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-list_bucket_dml_10.q-bucket_num_reducers.q-bucket6.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-load_fs2.q-file_with_header_footer.q-ql_rewrite_gbtoidx_cbo_1.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-ql_rewrite_gbtoidx.q-parallel_orderby.q-reduce_deduplicate.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-schemeAuthority2.q-infer_bucket_sort_bucketed_table.q-bucket4.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-smb_mapjoin_8.q - did not produce a TEST-*.xml file
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_bucket_groupby
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_groupby_sort_1_23
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_groupby_sort_skew_1_23
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_table_access_keys_stats
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_vectorized_timestamp_funcs
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_groupby_sort_1_23
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_groupby_sort_skew_1_23
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_table_access_keys_stats
{noformat}
Test results:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/3309/testReport
Console output:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/3309/console
Test logs:
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-3309/
Messages:
{noformat}
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: 22 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12723487 - PreCommit-HIVE-TRUNK-Build
> Give a warning when grouping or ordering by a constant column
> -
>
> Key: HIVE-10160
> URL: https://issues.apache.org/jira/browse/HIVE-10160
> Project: Hive
> Issue Type: Improvement
> Components: Query Processor
>Reporter: Lefty Leverenz
>Assignee: Yongzhi Chen
>Priority: Minor
> Attachments: HIVE-10160.1.patch, HIVE-10160.3.patch,
> HIVE-10160.4.patch
>
>
> To avoid confusion, a warning should be issued when users specify column
> positions instead of names in a GROUP BY or ORDER BY clause (unless
> hive.groupby.orderby.position.alias is set to true in Hive 0.11.0 or later).
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (HIVE-10160) Give a warning when grouping or ordering by a constant column
[ https://issues.apache.org/jira/browse/HIVE-10160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14482566#comment-14482566 ] Chao commented on HIVE-10160: - +1 on pending test. > Give a warning when grouping or ordering by a constant column > - > > Key: HIVE-10160 > URL: https://issues.apache.org/jira/browse/HIVE-10160 > Project: Hive > Issue Type: Improvement > Components: Query Processor >Reporter: Lefty Leverenz >Assignee: Yongzhi Chen >Priority: Minor > Attachments: HIVE-10160.1.patch, HIVE-10160.3.patch, > HIVE-10160.4.patch > > > To avoid confusion, a warning should be issued when users specify column > positions instead of names in a GROUP BY or ORDER BY clause (unless > hive.groupby.orderby.position.alias is set to true in Hive 0.11.0 or later). -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-10160) Give a warning when grouping or ordering by a constant column
[ https://issues.apache.org/jira/browse/HIVE-10160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14482190#comment-14482190 ] Yongzhi Chen commented on HIVE-10160: - Put the warning to shell, and add one test, waiting for test result. > Give a warning when grouping or ordering by a constant column > - > > Key: HIVE-10160 > URL: https://issues.apache.org/jira/browse/HIVE-10160 > Project: Hive > Issue Type: Improvement > Components: Query Processor >Reporter: Lefty Leverenz >Assignee: Yongzhi Chen >Priority: Minor > Attachments: HIVE-10160.1.patch, HIVE-10160.3.patch, > HIVE-10160.4.patch > > > To avoid confusion, a warning should be issued when users specify column > positions instead of names in a GROUP BY or ORDER BY clause (unless > hive.groupby.orderby.position.alias is set to true in Hive 0.11.0 or later). -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-10160) Give a warning when grouping or ordering by a constant column
[ https://issues.apache.org/jira/browse/HIVE-10160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14481361#comment-14481361 ] Chao commented on HIVE-10160: - Patch looks good to me. But I'm wondering instead of putting the warning in the log, whether it makes more sense to put it in the shell, so user can know immediately what they need to do to make it work. > Give a warning when grouping or ordering by a constant column > - > > Key: HIVE-10160 > URL: https://issues.apache.org/jira/browse/HIVE-10160 > Project: Hive > Issue Type: Improvement > Components: Query Processor >Reporter: Lefty Leverenz >Assignee: Yongzhi Chen >Priority: Minor > Attachments: HIVE-10160.1.patch, HIVE-10160.3.patch > > > To avoid confusion, a warning should be issued when users specify column > positions instead of names in a GROUP BY or ORDER BY clause (unless > hive.groupby.orderby.position.alias is set to true in Hive 0.11.0 or later). -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-10160) Give a warning when grouping or ordering by a constant column
[ https://issues.apache.org/jira/browse/HIVE-10160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14395992#comment-14395992 ] Yongzhi Chen commented on HIVE-10160: - The 3 failures are not related. [~csun] or [~szehon], could you review the change? Thanks > Give a warning when grouping or ordering by a constant column > - > > Key: HIVE-10160 > URL: https://issues.apache.org/jira/browse/HIVE-10160 > Project: Hive > Issue Type: Improvement > Components: Query Processor >Reporter: Lefty Leverenz >Assignee: Yongzhi Chen >Priority: Minor > Attachments: HIVE-10160.1.patch, HIVE-10160.3.patch > > > To avoid confusion, a warning should be issued when users specify column > positions instead of names in a GROUP BY or ORDER BY clause (unless > hive.groupby.orderby.position.alias is set to true in Hive 0.11.0 or later). -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-10160) Give a warning when grouping or ordering by a constant column
[
https://issues.apache.org/jira/browse/HIVE-10160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14395924#comment-14395924
]
Hive QA commented on HIVE-10160:
{color:red}Overall{color}: -1 at least one tests failed
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12709409/HIVE-10160.3.patch
{color:red}ERROR:{color} -1 due to 3 failed/errored test(s), 8700 tests executed
*Failed tests:*
{noformat}
TestMinimrCliDriver-smb_mapjoin_8.q - did not produce a TEST-*.xml file
org.apache.hive.hcatalog.streaming.TestStreaming.testTransactionBatchCommit_Json
org.apache.hive.jdbc.TestSSL.testSSLFetchHttp
{noformat}
Test results:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/3286/testReport
Console output:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/3286/console
Test logs:
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-3286/
Messages:
{noformat}
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: 3 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12709409 - PreCommit-HIVE-TRUNK-Build
> Give a warning when grouping or ordering by a constant column
> -
>
> Key: HIVE-10160
> URL: https://issues.apache.org/jira/browse/HIVE-10160
> Project: Hive
> Issue Type: Improvement
> Components: Query Processor
>Reporter: Lefty Leverenz
>Assignee: Yongzhi Chen
>Priority: Minor
> Attachments: HIVE-10160.1.patch, HIVE-10160.3.patch
>
>
> To avoid confusion, a warning should be issued when users specify column
> positions instead of names in a GROUP BY or ORDER BY clause (unless
> hive.groupby.orderby.position.alias is set to true in Hive 0.11.0 or later).
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (HIVE-10160) Give a warning when grouping or ordering by a constant column
[ https://issues.apache.org/jira/browse/HIVE-10160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14395640#comment-14395640 ] Yongzhi Chen commented on HIVE-10160: - The 13 tests failures are caused by the same error: TestMinimrCliDriver does not compile, error message is: [INFO] --- maven-compiler-plugin:3.1:testCompile (default-testCompile) @ hive-it-qfile --- [INFO] Compiling 14 source files to /home/hiveptest/54.147.211.36-hiveptest-1/apache-svn-trunk-source/itests/qtest/target/test-classes [INFO] - [ERROR] COMPILATION ERROR : [INFO] - [ERROR] /home/hiveptest/54.147.211.36-hiveptest-1/apache-svn-trunk-source/itests/qtest/target/generated-test-sources/java/org/apache/hadoop/hive/cli/TestCliDriver.java:[100,22] code too large [INFO] 1 error My patches did add two qfile tests for CliDriver tests, but not to minimr. The newly added tests all passed, I do not know why they affect minimr tests build(the number of test qfiles exceeds some limitation?). Attach a new patch without tests and try again. > Give a warning when grouping or ordering by a constant column > - > > Key: HIVE-10160 > URL: https://issues.apache.org/jira/browse/HIVE-10160 > Project: Hive > Issue Type: Improvement > Components: Query Processor >Reporter: Lefty Leverenz >Assignee: Yongzhi Chen >Priority: Minor > Attachments: HIVE-10160.1.patch, HIVE-10160.3.patch > > > To avoid confusion, a warning should be issued when users specify column > positions instead of names in a GROUP BY or ORDER BY clause (unless > hive.groupby.orderby.position.alias is set to true in Hive 0.11.0 or later). -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-10160) Give a warning when grouping or ordering by a constant column
[
https://issues.apache.org/jira/browse/HIVE-10160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14395445#comment-14395445
]
Hive QA commented on HIVE-10160:
{color:red}Overall{color}: -1 at least one tests failed
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12709233/HIVE-10160.2.patch
{color:red}ERROR:{color} -1 due to 13 failed/errored test(s), 8653 tests
executed
*Failed tests:*
{noformat}
TestMinimrCliDriver-bucketmapjoin6.q-constprog_partitioner.q-infer_bucket_sort_dyn_part.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-external_table_with_space_in_location_path.q-infer_bucket_sort_merge.q-auto_sortmerge_join_16.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-groupby2.q-import_exported_table.q-bucketizedhiveinputformat.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-index_bitmap3.q-stats_counter_partitioned.q-temp_table_external.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-infer_bucket_sort_map_operators.q-join1.q-bucketmapjoin7.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-infer_bucket_sort_num_buckets.q-disable_merge_for_bucketing.q-uber_reduce.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-infer_bucket_sort_reducers_power_two.q-scriptfile1.q-scriptfile1_win.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-leftsemijoin_mr.q-bucket5.q-root_dir_external_table.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-list_bucket_dml_10.q-bucket_num_reducers.q-bucket6.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-load_fs2.q-file_with_header_footer.q-ql_rewrite_gbtoidx_cbo_1.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-ql_rewrite_gbtoidx.q-parallel_orderby.q-reduce_deduplicate.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-schemeAuthority2.q-infer_bucket_sort_bucketed_table.q-bucket4.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-smb_mapjoin_8.q - did not produce a TEST-*.xml file
{noformat}
Test results:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/3276/testReport
Console output:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/3276/console
Test logs:
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-3276/
Messages:
{noformat}
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: 13 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12709233 - PreCommit-HIVE-TRUNK-Build
> Give a warning when grouping or ordering by a constant column
> -
>
> Key: HIVE-10160
> URL: https://issues.apache.org/jira/browse/HIVE-10160
> Project: Hive
> Issue Type: Improvement
> Components: Query Processor
>Reporter: Lefty Leverenz
>Assignee: Yongzhi Chen
>Priority: Minor
> Attachments: HIVE-10160.1.patch, HIVE-10160.2.patch
>
>
> To avoid confusion, a warning should be issued when users specify column
> positions instead of names in a GROUP BY or ORDER BY clause (unless
> hive.groupby.orderby.position.alias is set to true in Hive 0.11.0 or later).
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (HIVE-10160) Give a warning when grouping or ordering by a constant column
[ https://issues.apache.org/jira/browse/HIVE-10160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14395079#comment-14395079 ] Lefty Leverenz commented on HIVE-10160: --- Thanks for working on this, [~ychena]. I'm not qualified to review the code, so I hope someone else will find time for it. > Give a warning when grouping or ordering by a constant column > - > > Key: HIVE-10160 > URL: https://issues.apache.org/jira/browse/HIVE-10160 > Project: Hive > Issue Type: Improvement > Components: Query Processor >Reporter: Lefty Leverenz >Assignee: Yongzhi Chen >Priority: Minor > Attachments: HIVE-10160.1.patch, HIVE-10160.2.patch > > > To avoid confusion, a warning should be issued when users specify column > positions instead of names in a GROUP BY or ORDER BY clause (unless > hive.groupby.orderby.position.alias is set to true in Hive 0.11.0 or later). -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-10160) Give a warning when grouping or ordering by a constant column
[ https://issues.apache.org/jira/browse/HIVE-10160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14394459#comment-14394459 ] Yongzhi Chen commented on HIVE-10160: - The failures seem not related, it may network issues. Try to run second time. > Give a warning when grouping or ordering by a constant column > - > > Key: HIVE-10160 > URL: https://issues.apache.org/jira/browse/HIVE-10160 > Project: Hive > Issue Type: Improvement > Components: Query Processor >Reporter: Lefty Leverenz >Assignee: Yongzhi Chen >Priority: Minor > Attachments: HIVE-10160.1.patch, HIVE-10160.2.patch > > > To avoid confusion, a warning should be issued when users specify column > positions instead of names in a GROUP BY or ORDER BY clause (unless > hive.groupby.orderby.position.alias is set to true in Hive 0.11.0 or later). -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-10160) Give a warning when grouping or ordering by a constant column
[
https://issues.apache.org/jira/browse/HIVE-10160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14394407#comment-14394407
]
Hive QA commented on HIVE-10160:
{color:red}Overall{color}: -1 at least one tests failed
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12709068/HIVE-10160.1.patch
{color:red}ERROR:{color} -1 due to 49 failed/errored test(s), 8646 tests
executed
*Failed tests:*
{noformat}
TestMinimrCliDriver-bucketmapjoin6.q-constprog_partitioner.q-infer_bucket_sort_dyn_part.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-external_table_with_space_in_location_path.q-infer_bucket_sort_merge.q-auto_sortmerge_join_16.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-groupby2.q-import_exported_table.q-bucketizedhiveinputformat.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-index_bitmap3.q-stats_counter_partitioned.q-temp_table_external.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-infer_bucket_sort_map_operators.q-join1.q-bucketmapjoin7.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-infer_bucket_sort_num_buckets.q-disable_merge_for_bucketing.q-uber_reduce.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-infer_bucket_sort_reducers_power_two.q-scriptfile1.q-scriptfile1_win.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-leftsemijoin_mr.q-bucket5.q-root_dir_external_table.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-list_bucket_dml_10.q-bucket_num_reducers.q-bucket6.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-load_fs2.q-file_with_header_footer.q-ql_rewrite_gbtoidx_cbo_1.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-ql_rewrite_gbtoidx.q-parallel_orderby.q-reduce_deduplicate.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-schemeAuthority2.q-infer_bucket_sort_bucketed_table.q-bucket4.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-smb_mapjoin_8.q - did not produce a TEST-*.xml file
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_auto_sortmerge_join_16
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_bucket4
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_bucket5
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_bucket6
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_bucketizedhiveinputformat
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_bucketmapjoin6
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_bucketmapjoin7
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_constprog_partitioner
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_disable_merge_for_bucketing
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_empty_dir_in_table
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_external_table_with_space_in_location_path
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_index_bitmap3
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_index_bitmap_auto
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_infer_bucket_sort_bucketed_table
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_infer_bucket_sort_map_operators
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_infer_bucket_sort_merge
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_infer_bucket_sort_num_buckets
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_infer_bucket_sort_reducers_power_two
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_leftsemijoin_mr
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_list_bucket_dml_10
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_parallel_orderby
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_ql_rewrite_gbtoidx
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_ql_rewrite_gbtoidx_cbo_1
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_quotedid_smb
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_reduce_deduplicate
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_remote_script
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_root_dir_external_table
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_schemeAuthority
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_schemeAuthority2
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_scriptfile1
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.
[jira] [Commented] (HIVE-10160) Give a warning when grouping or ordering by a constant column
[ https://issues.apache.org/jira/browse/HIVE-10160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14393463#comment-14393463 ] Yongzhi Chen commented on HIVE-10160: - Add warning message in hive log to help user find root cause. > Give a warning when grouping or ordering by a constant column > - > > Key: HIVE-10160 > URL: https://issues.apache.org/jira/browse/HIVE-10160 > Project: Hive > Issue Type: Improvement > Components: Query Processor >Reporter: Lefty Leverenz >Assignee: Yongzhi Chen >Priority: Minor > > To avoid confusion, a warning should be issued when users specify column > positions instead of names in a GROUP BY or ORDER BY clause (unless > hive.groupby.orderby.position.alias is set to true in Hive 0.11.0 or later). -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-10160) Give a warning when grouping or ordering by a constant column
[ https://issues.apache.org/jira/browse/HIVE-10160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14388087#comment-14388087 ] Lefty Leverenz commented on HIVE-10160: --- See the thread "ORDER BY clause in Hive" on u...@hive.apache.org: * [http://mail-archives.apache.org/mod_mbox/hive-user/201503.mbox/%3c05d701d069b4$c71f6e60$555e4b20$@co.uk%3e] > Give a warning when grouping or ordering by a constant column > - > > Key: HIVE-10160 > URL: https://issues.apache.org/jira/browse/HIVE-10160 > Project: Hive > Issue Type: Improvement > Components: Query Processor >Reporter: Lefty Leverenz >Priority: Minor > > To avoid confusion, a warning should be issued when users specify column > positions instead of names in a GROUP BY or ORDER BY clause (unless > hive.groupby.orderby.position.alias is set to true in Hive 0.11.0 or later). -- This message was sent by Atlassian JIRA (v6.3.4#6332)
