[ https://issues.apache.org/jira/browse/HIVE-15769?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15852814#comment-15852814 ]
Hive QA commented on HIVE-15769: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12850982/HIVE-15769.01.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 130 failed/errored test(s), 10227 tests executed *Failed tests:* {noformat} TestDerbyConnector - did not produce a TEST-*.xml file (likely timed out) (batchId=235) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[alter_view_as_select] (batchId=9) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[alter_view_rename] (batchId=34) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[authorization_8] (batchId=10) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[authorization_cli_createtab] (batchId=26) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[authorization_cli_createtab_noauthzapi] (batchId=8) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[authorization_owner_actions] (batchId=5) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[authorization_view_1] (batchId=18) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[authorization_view_2] (batchId=55) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[authorization_view_3] (batchId=32) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[authorization_view_4] (batchId=7) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[cbo_const] (batchId=17) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[cbo_subq_exists] (batchId=71) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[cbo_union_view] (batchId=19) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[concat_op] (batchId=68) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[create_big_view] (batchId=71) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[create_like_tbl_props] (batchId=67) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[create_like_view] (batchId=3) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[create_or_replace_view] (batchId=36) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[create_view] (batchId=37) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[create_view_defaultformats] (batchId=70) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[create_view_partitioned] (batchId=34) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[create_view_translate] (batchId=80) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[ctas_char] (batchId=17) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[ctas_date] (batchId=1) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[ctas_varchar] (batchId=16) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[cteViews] (batchId=70) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[cte_2] (batchId=51) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[cte_4] (batchId=77) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[database_drop] (batchId=55) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[dbtxnmgr_ddl1] (batchId=73) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[dbtxnmgr_query5] (batchId=24) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[describe_formatted_view_partitioned] (batchId=70) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[describe_formatted_view_partitioned_json] (batchId=50) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[escape_comments] (batchId=70) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[explain_ddl] (batchId=44) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[explain_dependency] (batchId=39) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[explain_logical] (batchId=60) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[join_view] (batchId=74) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[lateral_view_onview] (batchId=53) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[masking_2] (batchId=79) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[masking_6] (batchId=24) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[masking_7] (batchId=40) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[quotedid_basic] (batchId=56) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[show_create_table_view] (batchId=80) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[show_views] (batchId=47) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[struct_in_view] (batchId=45) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[subquery_exists] (batchId=38) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[subquery_exists_having] (batchId=3) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[unicode_comments] (batchId=36) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[unset_table_view_property] (batchId=47) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[view] (batchId=40) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[view_alias] (batchId=76) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[view_authorization_sqlstd] (batchId=46) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[view_cast] (batchId=38) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[view_inputs] (batchId=3) org.apache.hadoop.hive.cli.TestEncryptedHDFSCliDriver.testCliDriver[encryption_drop_view] (batchId=159) org.apache.hadoop.hive.cli.TestEncryptedHDFSCliDriver.testCliDriver[encryption_join_with_different_encryption_keys] (batchId=159) org.apache.hadoop.hive.cli.TestHBaseCliDriver.testCliDriver[hbase_ppd_join] (batchId=90) org.apache.hadoop.hive.cli.TestHBaseCliDriver.testCliDriver[hbase_viewjoins] (batchId=89) org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[cte_2] (batchId=136) org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[cte_4] (batchId=137) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[cbo_rp_unionDistinct_2] (batchId=144) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[cbo_rp_views] (batchId=142) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[cbo_rp_windowing_2] (batchId=143) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[cbo_subq_exists] (batchId=153) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[cbo_views] (batchId=144) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[explainuser_1] (batchId=145) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[lineage3] (batchId=147) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[multi_column_in] (batchId=141) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[multi_column_in_single] (batchId=140) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[ppd_union_view] (batchId=144) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[ptf] (batchId=141) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[selectDistinctStar] (batchId=152) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[subquery_exists] (batchId=146) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[subquery_notin] (batchId=151) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[subquery_views] (batchId=141) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[tez_union] (batchId=145) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[unionDistinct_2] (batchId=141) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[union_top_level] (batchId=150) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_varchar_simple] (batchId=153) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vectorized_ptf] (batchId=150) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[windowing] (batchId=149) org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[explainanalyze_3] (batchId=93) org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[explainuser_3] (batchId=93) org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[unionDistinct_2] (batchId=93) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[alter_view_as_select_with_partition] (batchId=85) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[alter_view_failure2] (batchId=86) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[alter_view_failure4] (batchId=86) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[alter_view_failure5] (batchId=86) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[alter_view_failure6] (batchId=86) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[alter_view_failure7] (batchId=86) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[alter_view_failure9] (batchId=85) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[alter_view_failure] (batchId=85) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[analyze_view] (batchId=86) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[authorization_not_owner_drop_view] (batchId=85) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[authorization_select_view] (batchId=86) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[authorization_view_1] (batchId=85) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[authorization_view_2] (batchId=86) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[authorization_view_3] (batchId=85) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[authorization_view_4] (batchId=85) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[authorization_view_5] (batchId=86) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[authorization_view_6] (batchId=86) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[authorization_view_7] (batchId=86) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[authorization_view_disable_cbo_2] (batchId=85) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[create_or_replace_view1] (batchId=86) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[create_or_replace_view2] (batchId=85) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[create_or_replace_view4] (batchId=86) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[create_or_replace_view5] (batchId=86) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[create_or_replace_view6] (batchId=85) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[create_or_replace_view7] (batchId=85) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[create_or_replace_view8] (batchId=86) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[create_view_failure2] (batchId=85) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[drop_table_failure2] (batchId=85) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[insert_view_failure] (batchId=86) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[invalidate_view1] (batchId=85) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[load_view_failure] (batchId=85) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[recursive_view] (batchId=86) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[unset_view_property] (batchId=85) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[view_delete] (batchId=86) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[view_update] (batchId=86) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query14] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query23] (batchId=223) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[join_view] (batchId=130) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[ptf] (batchId=102) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[subquery_exists] (batchId=112) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[union_top_level] (batchId=121) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[vectorized_ptf] (batchId=122) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[windowing] (batchId=117) org.apache.hadoop.hive.llap.daemon.impl.TestTaskExecutorService.testWaitQueuePreemption (batchId=277) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/3378/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/3378/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-3378/ 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: 130 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12850982 - PreCommit-HIVE-Build > Support view creation in CBO > ---------------------------- > > Key: HIVE-15769 > URL: https://issues.apache.org/jira/browse/HIVE-15769 > Project: Hive > Issue Type: Bug > Reporter: Pengcheng Xiong > Assignee: Pengcheng Xiong > Attachments: HIVE-15769.01.patch > > > Right now, set operator needs to run in CBO. If a view contains a set op, it > will throw exception. We need to support view creation in CBO. -- This message was sent by Atlassian JIRA (v6.3.15#6346)