-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/17887/
-----------------------------------------------------------
(Updated Feb. 17, 2014, 1:18 a.m.)
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 4d58f96
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/QBSubQuery.java 92ccbea
ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java 77388dd
ql/src/java/org/apache/hadoop/hive/ql/parse/SubQueryUtils.java 8ffbe07
ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java 9a947ec
ql/src/test/org/apache/hadoop/hive/ql/parse/TestQBSubQuery.java 7e57471
ql/src/test/queries/clientpositive/multi_insert_subquery.q PRE-CREATION
ql/src/test/results/clientnegative/create_view_failure3.q.out 5ddbdb6
ql/src/test/results/clientnegative/subquery_exists_implicit_gby.q.out 4830c00
ql/src/test/results/clientnegative/subquery_in_groupby.q.out 809bb0a
ql/src/test/results/clientnegative/subquery_in_select.q.out 3d74132
ql/src/test/results/clientnegative/subquery_multiple_cols_in_select.q.out
7a16bae
ql/src/test/results/clientnegative/subquery_nested_subquery.q.out 68a3a98
ql/src/test/results/clientnegative/subquery_notexists_implicit_gby.q.out
74422af
ql/src/test/results/clientnegative/subquery_subquery_chain.q.out 448bfb2
ql/src/test/results/clientnegative/subquery_windowing_corr.q.out 3cc2fa4
ql/src/test/results/clientnegative/uniquejoin3.q.out e10a47b
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/bucket4.q.out fb2f619
ql/src/test/results/clientpositive/bucket5.q.out 8a49352
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/bucketmapjoin7.q.out 1665a41
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/disable_merge_for_bucketing.q.out 7265313
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/list_bucket_dml_10.q.out 3f2bb39
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/reduce_deduplicate.q.out 03cc441
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/subquery_in_having.q.out ef3dc18
ql/src/test/results/clientpositive/tez/bucket2.q.out 74bad32
ql/src/test/results/clientpositive/tez/bucket3.q.out 69d838e
ql/src/test/results/clientpositive/tez/bucket4.q.out 3092e21
ql/src/test/results/clientpositive/tez/ctas.q.out 24c810c
ql/src/test/results/clientpositive/tez/disable_merge_for_bucketing.q.out
74bad32
ql/src/test/results/clientpositive/tez/filter_join_breaktask.q.out bf6032d
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
ql/src/test/results/compiler/parse/case_sensitivity.q.out c14fb1a
ql/src/test/results/compiler/parse/cast1.q.out 5d37c9d
ql/src/test/results/compiler/parse/groupby1.q.out 1aa680c
ql/src/test/results/compiler/parse/groupby2.q.out 2c70804
ql/src/test/results/compiler/parse/groupby3.q.out 057c101
ql/src/test/results/compiler/parse/groupby4.q.out d555d20
ql/src/test/results/compiler/parse/groupby5.q.out 0aa6914
ql/src/test/results/compiler/parse/groupby6.q.out 52fa9b4
ql/src/test/results/compiler/parse/input1.q.out fa3613e
ql/src/test/results/compiler/parse/input2.q.out 153f517
ql/src/test/results/compiler/parse/input20.q.out da4c1af
ql/src/test/results/compiler/parse/input3.q.out b033f3a
ql/src/test/results/compiler/parse/input4.q.out c1425e7
ql/src/test/results/compiler/parse/input5.q.out 854907b
ql/src/test/results/compiler/parse/input6.q.out 35f73a6
ql/src/test/results/compiler/parse/input7.q.out a26964d
ql/src/test/results/compiler/parse/input8.q.out a9a3bd1
ql/src/test/results/compiler/parse/input9.q.out b24ef54
ql/src/test/results/compiler/parse/input_part1.q.out 880e0f8
ql/src/test/results/compiler/parse/input_testsequencefile.q.out 0b80da4
ql/src/test/results/compiler/parse/input_testxpath.q.out aeb505b
ql/src/test/results/compiler/parse/input_testxpath2.q.out d4c4610
ql/src/test/results/compiler/parse/join1.q.out 1c45f30
ql/src/test/results/compiler/parse/join2.q.out debbac3
ql/src/test/results/compiler/parse/join3.q.out 51baa24
ql/src/test/results/compiler/parse/join4.q.out 77f3486
ql/src/test/results/compiler/parse/join5.q.out 4db56a4
ql/src/test/results/compiler/parse/join6.q.out 3114d62
ql/src/test/results/compiler/parse/join7.q.out 9b12cec
ql/src/test/results/compiler/parse/join8.q.out aa4e64a
ql/src/test/results/compiler/parse/sample1.q.out 9a493ad
ql/src/test/results/compiler/parse/sample2.q.out e67c761
ql/src/test/results/compiler/parse/sample3.q.out ad5855b
ql/src/test/results/compiler/parse/sample4.q.out 790b009
ql/src/test/results/compiler/parse/sample5.q.out cb55074
ql/src/test/results/compiler/parse/sample6.q.out 3562bb8
ql/src/test/results/compiler/parse/sample7.q.out 6bcf840
ql/src/test/results/compiler/parse/subq.q.out afdcb57
ql/src/test/results/compiler/parse/udf1.q.out a9084e1
ql/src/test/results/compiler/parse/udf4.q.out 6065692
ql/src/test/results/compiler/parse/udf6.q.out 795216a
ql/src/test/results/compiler/parse/udf_case.q.out f8de5fc
ql/src/test/results/compiler/parse/udf_when.q.out a527fa4
ql/src/test/results/compiler/parse/union.q.out d9be739
Diff: https://reviews.apache.org/r/17887/diff/
Testing
-------
Thanks,
Navis Ryu
