----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/17887/ -----------------------------------------------------------
Review request for hive. Bugs: HIVE-5690 https://issues.apache.org/jira/browse/HIVE-5690 Repository: hive-git Description ------- Single sourced multi (insert) query is very useful for various ETL processes but it does not allow subqueries included. For example, {noformat} explain from src insert overwrite table x1 select * from (select distinct key,value) b order by key insert overwrite table x2 select * from (select distinct key,value) c order by value; {noformat} Diffs ----- ql/src/java/org/apache/hadoop/hive/ql/parse/FromClauseParser.g 97ce484 ql/src/java/org/apache/hadoop/hive/ql/parse/HiveParser.g 7e69912 ql/src/java/org/apache/hadoop/hive/ql/parse/QB.java a8b436e ql/src/java/org/apache/hadoop/hive/ql/parse/QBParseInfo.java a7cec5d ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java 80409ac ql/src/test/queries/clientpositive/multi_insert_subquery.q PRE-CREATION ql/src/test/results/clientpositive/alter_partition_coltype.q.out 49c1051 ql/src/test/results/clientpositive/annotate_stats_filter.q.out e6eae8a ql/src/test/results/clientpositive/annotate_stats_groupby.q.out e55c35b ql/src/test/results/clientpositive/annotate_stats_join.q.out 523d386 ql/src/test/results/clientpositive/annotate_stats_limit.q.out e6db870 ql/src/test/results/clientpositive/annotate_stats_part.q.out 2a56d6e ql/src/test/results/clientpositive/annotate_stats_select.q.out 023b1c3 ql/src/test/results/clientpositive/annotate_stats_table.q.out 89fa6b1 ql/src/test/results/clientpositive/annotate_stats_union.q.out df1e386 ql/src/test/results/clientpositive/auto_join_reordering_values.q.out 48ca65f ql/src/test/results/clientpositive/auto_sortmerge_join_1.q.out e84e7b2 ql/src/test/results/clientpositive/auto_sortmerge_join_11.q.out 8ac2c06 ql/src/test/results/clientpositive/auto_sortmerge_join_12.q.out d462218 ql/src/test/results/clientpositive/auto_sortmerge_join_2.q.out 0488485 ql/src/test/results/clientpositive/auto_sortmerge_join_3.q.out 1537f65 ql/src/test/results/clientpositive/auto_sortmerge_join_4.q.out 6dd49c4 ql/src/test/results/clientpositive/auto_sortmerge_join_5.q.out 0f4f59f ql/src/test/results/clientpositive/auto_sortmerge_join_7.q.out b176c55 ql/src/test/results/clientpositive/auto_sortmerge_join_8.q.out 5d2342c ql/src/test/results/clientpositive/binary_output_format.q.out bcfb8eb ql/src/test/results/clientpositive/bucket1.q.out 5ade5f8 ql/src/test/results/clientpositive/bucket2.q.out 672903d ql/src/test/results/clientpositive/bucket3.q.out 9232f6b ql/src/test/results/clientpositive/bucket_map_join_1.q.out 75bcda8 ql/src/test/results/clientpositive/bucket_map_join_2.q.out a737f82 ql/src/test/results/clientpositive/bucketcontext_1.q.out 930be79 ql/src/test/results/clientpositive/bucketcontext_2.q.out 88f747a ql/src/test/results/clientpositive/bucketcontext_3.q.out 3da1cc9 ql/src/test/results/clientpositive/bucketcontext_4.q.out 33dee62 ql/src/test/results/clientpositive/bucketcontext_5.q.out eb751f3 ql/src/test/results/clientpositive/bucketcontext_6.q.out 320b8b9 ql/src/test/results/clientpositive/bucketcontext_7.q.out ef4f295 ql/src/test/results/clientpositive/bucketcontext_8.q.out f9e6835 ql/src/test/results/clientpositive/bucketmapjoin1.q.out 81ca8a7 ql/src/test/results/clientpositive/bucketmapjoin10.q.out 60c66ea ql/src/test/results/clientpositive/bucketmapjoin11.q.out 2cc2bd4 ql/src/test/results/clientpositive/bucketmapjoin12.q.out 2da135e ql/src/test/results/clientpositive/bucketmapjoin13.q.out e6af5a9 ql/src/test/results/clientpositive/bucketmapjoin2.q.out 7d6dd86 ql/src/test/results/clientpositive/bucketmapjoin3.q.out f62ce1d ql/src/test/results/clientpositive/bucketmapjoin4.q.out ef980f5 ql/src/test/results/clientpositive/bucketmapjoin5.q.out d725c7d ql/src/test/results/clientpositive/bucketmapjoin8.q.out 79d4b8e ql/src/test/results/clientpositive/bucketmapjoin9.q.out fd4f9f9 ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out cfff344 ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out db9ee36 ql/src/test/results/clientpositive/bucketmapjoin_negative3.q.out b457bc4 ql/src/test/results/clientpositive/combine2_hadoop20.q.out 5ba4f1f ql/src/test/results/clientpositive/ctas.q.out 9668855 ql/src/test/results/clientpositive/ctas_hadoop20.q.out 0ec0af5 ql/src/test/results/clientpositive/dynamic_partition_skip_default.q.out 545d527 ql/src/test/results/clientpositive/explain_logical.q.out 2092540 ql/src/test/results/clientpositive/filter_join_breaktask.q.out ff91d35 ql/src/test/results/clientpositive/groupby_map_ppr.q.out 89c7299 ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out 12f1fcf ql/src/test/results/clientpositive/groupby_ppr.q.out c8eed7c ql/src/test/results/clientpositive/groupby_ppr_multi_distinct.q.out 31d6dec ql/src/test/results/clientpositive/groupby_sort_1.q.out b1f7f41 ql/src/test/results/clientpositive/groupby_sort_6.q.out 3362408 ql/src/test/results/clientpositive/groupby_sort_skew_1.q.out d1937b9 ql/src/test/results/clientpositive/input23.q.out 20bdfaf ql/src/test/results/clientpositive/input42.q.out 4499205 ql/src/test/results/clientpositive/input_part1.q.out 4c1d89b ql/src/test/results/clientpositive/input_part2.q.out ea22329 ql/src/test/results/clientpositive/input_part7.q.out 2713fe3 ql/src/test/results/clientpositive/input_part9.q.out eb404bd ql/src/test/results/clientpositive/join17.q.out 631ffea ql/src/test/results/clientpositive/join26.q.out b2e254b ql/src/test/results/clientpositive/join32.q.out 7a9c173 ql/src/test/results/clientpositive/join32_lessSize.q.out 0f1cf0c ql/src/test/results/clientpositive/join33.q.out 7a9c173 ql/src/test/results/clientpositive/join34.q.out af04fbd ql/src/test/results/clientpositive/join35.q.out 400e858 ql/src/test/results/clientpositive/join9.q.out c2bf18b ql/src/test/results/clientpositive/join_filters_overlap.q.out bdac4b1 ql/src/test/results/clientpositive/join_map_ppr.q.out 09b9462 ql/src/test/results/clientpositive/load_dyn_part8.q.out 968cef1 ql/src/test/results/clientpositive/louter_join_ppr.q.out 28070f9 ql/src/test/results/clientpositive/macro.q.out c483029 ql/src/test/results/clientpositive/merge3.q.out 3df75b7 ql/src/test/results/clientpositive/metadataonly1.q.out fc6e9e5 ql/src/test/results/clientpositive/multi_insert_subquery.q.out PRE-CREATION ql/src/test/results/clientpositive/outer_join_ppr.q.out 6a65184 ql/src/test/results/clientpositive/pcr.q.out 7f216d9 ql/src/test/results/clientpositive/ppd_join_filter.q.out 09ac35d ql/src/test/results/clientpositive/ppd_union_view.q.out 41172fd ql/src/test/results/clientpositive/ppd_vc.q.out 3fd8be8 ql/src/test/results/clientpositive/ppr_allchildsarenull.q.out 3218d99 ql/src/test/results/clientpositive/push_or.q.out 8864ebf ql/src/test/results/clientpositive/rand_partitionpruner1.q.out ec5540b ql/src/test/results/clientpositive/rand_partitionpruner2.q.out 1b3c962 ql/src/test/results/clientpositive/rand_partitionpruner3.q.out 321067e ql/src/test/results/clientpositive/regexp_extract.q.out 60b6fda ql/src/test/results/clientpositive/router_join_ppr.q.out 8deb390 ql/src/test/results/clientpositive/sample1.q.out eb7a552 ql/src/test/results/clientpositive/sample10.q.out beca660 ql/src/test/results/clientpositive/sample2.q.out 6282873 ql/src/test/results/clientpositive/sample4.q.out 859e0c4 ql/src/test/results/clientpositive/sample5.q.out 60855f4 ql/src/test/results/clientpositive/sample6.q.out 32a1141 ql/src/test/results/clientpositive/sample7.q.out cf018f5 ql/src/test/results/clientpositive/sample8.q.out db65ce3 ql/src/test/results/clientpositive/sample9.q.out 9e1fb12 ql/src/test/results/clientpositive/serde_user_properties.q.out e85cadb ql/src/test/results/clientpositive/smb_mapjoin9.q.out 1b6bec3 ql/src/test/results/clientpositive/smb_mapjoin_11.q.out 5c7a6db ql/src/test/results/clientpositive/smb_mapjoin_12.q.out 0ddbe16 ql/src/test/results/clientpositive/smb_mapjoin_13.q.out efc781d ql/src/test/results/clientpositive/smb_mapjoin_15.q.out 3392187 ql/src/test/results/clientpositive/sort_merge_join_desc_5.q.out 9d4d504 ql/src/test/results/clientpositive/sort_merge_join_desc_6.q.out 6ee7b0a ql/src/test/results/clientpositive/sort_merge_join_desc_7.q.out a0c869a ql/src/test/results/clientpositive/stats0.q.out 15b270f ql/src/test/results/clientpositive/stats11.q.out 5e65bc5 ql/src/test/results/clientpositive/tez/bucket2.q.out e661078 ql/src/test/results/clientpositive/tez/bucket3.q.out fc603b5 ql/src/test/results/clientpositive/tez/bucket4.q.out d9e3ebf ql/src/test/results/clientpositive/tez/ctas.q.out 61bf158 ql/src/test/results/clientpositive/tez/disable_merge_for_bucketing.q.out e661078 ql/src/test/results/clientpositive/tez/filter_join_breaktask.q.out b58cdc4 ql/src/test/results/clientpositive/tez/sample1.q.out 92d031f ql/src/test/results/clientpositive/transform_ppr1.q.out 9c537f0 ql/src/test/results/clientpositive/transform_ppr2.q.out 4bddc69 ql/src/test/results/clientpositive/udf_explode.q.out f7b6f2a ql/src/test/results/clientpositive/udf_java_method.q.out 97efa6e ql/src/test/results/clientpositive/udf_reflect.q.out 44e10ec ql/src/test/results/clientpositive/udf_reflect2.q.out c326c0d ql/src/test/results/clientpositive/udtf_explode.q.out 5d29f18 ql/src/test/results/clientpositive/union22.q.out eb5ad5c ql/src/test/results/clientpositive/union24.q.out a88951a ql/src/test/results/clientpositive/union_ppr.q.out f639960 Diff: https://reviews.apache.org/r/17887/diff/ Testing ------- Thanks, Navis Ryu