hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Navis Ryu" <navis....@nexr.com>
Subject Re: Review Request 17887: Support subquery for single sourced multi query
Date Wed, 09 Jul 2014 06:54:47 GMT

-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/17887/
-----------------------------------------------------------

(Updated July 9, 2014, 6:54 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/exec/ExplainSQRewriteTask.java ea3ac70 
  ql/src/java/org/apache/hadoop/hive/ql/parse/FromClauseParser.g f448b16 
  ql/src/java/org/apache/hadoop/hive/ql/parse/HiveParser.g f934ac4 
  ql/src/java/org/apache/hadoop/hive/ql/parse/QB.java 908db1e 
  ql/src/java/org/apache/hadoop/hive/ql/parse/QBParseInfo.java 911ac8a 
  ql/src/java/org/apache/hadoop/hive/ql/parse/QBSubQuery.java d398c88 
  ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java b91b9a2 
  ql/src/java/org/apache/hadoop/hive/ql/parse/SubQueryDiagnostic.java 57f9432 
  ql/src/java/org/apache/hadoop/hive/ql/parse/SubQueryUtils.java 089ad78 
  ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java e44f5ae 
  ql/src/test/org/apache/hadoop/hive/ql/parse/TestQBSubQuery.java 8b36f21 
  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 4950ec9 
  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 d45f8f1 
  ql/src/test/results/clientnegative/uniquejoin3.q.out e10a47b 
  ql/src/test/results/clientpositive/alter_partition_coltype.q.out e86cc06 
  ql/src/test/results/clientpositive/analyze_table_null_partition.q.out a811f81 
  ql/src/test/results/clientpositive/annotate_stats_filter.q.out c7d58f6 
  ql/src/test/results/clientpositive/annotate_stats_groupby.q.out 6f72964 
  ql/src/test/results/clientpositive/annotate_stats_join.q.out cc816c8 
  ql/src/test/results/clientpositive/annotate_stats_limit.q.out 5c150f4 
  ql/src/test/results/clientpositive/annotate_stats_part.q.out a0b4602 
  ql/src/test/results/clientpositive/annotate_stats_select.q.out 97e9473 
  ql/src/test/results/clientpositive/annotate_stats_table.q.out bb2d18c 
  ql/src/test/results/clientpositive/annotate_stats_union.q.out 6d179b6 
  ql/src/test/results/clientpositive/auto_join_reordering_values.q.out 3f4f902 
  ql/src/test/results/clientpositive/auto_sortmerge_join_1.q.out 72640df 
  ql/src/test/results/clientpositive/auto_sortmerge_join_11.q.out c660cd0 
  ql/src/test/results/clientpositive/auto_sortmerge_join_12.q.out 4abda32 
  ql/src/test/results/clientpositive/auto_sortmerge_join_2.q.out 52a3194 
  ql/src/test/results/clientpositive/auto_sortmerge_join_3.q.out d807791 
  ql/src/test/results/clientpositive/auto_sortmerge_join_4.q.out 35e0a30 
  ql/src/test/results/clientpositive/auto_sortmerge_join_5.q.out af3d9d6 
  ql/src/test/results/clientpositive/auto_sortmerge_join_7.q.out 05ef5d8 
  ql/src/test/results/clientpositive/auto_sortmerge_join_8.q.out e423d14 
  ql/src/test/results/clientpositive/binary_output_format.q.out 294aabb 
  ql/src/test/results/clientpositive/bucket1.q.out f3eb15c 
  ql/src/test/results/clientpositive/bucket2.q.out 9a22160 
  ql/src/test/results/clientpositive/bucket3.q.out 8fa9c7b 
  ql/src/test/results/clientpositive/bucket4.q.out 032272b 
  ql/src/test/results/clientpositive/bucket5.q.out d19fbe5 
  ql/src/test/results/clientpositive/bucket_map_join_1.q.out 8674a6c 
  ql/src/test/results/clientpositive/bucket_map_join_2.q.out 8a5984d 
  ql/src/test/results/clientpositive/bucketcontext_1.q.out 1513515 
  ql/src/test/results/clientpositive/bucketcontext_2.q.out d18a9be 
  ql/src/test/results/clientpositive/bucketcontext_3.q.out e12c155 
  ql/src/test/results/clientpositive/bucketcontext_4.q.out 77b4882 
  ql/src/test/results/clientpositive/bucketcontext_5.q.out fa1cfc5 
  ql/src/test/results/clientpositive/bucketcontext_6.q.out aac66f8 
  ql/src/test/results/clientpositive/bucketcontext_7.q.out 78c4f94 
  ql/src/test/results/clientpositive/bucketcontext_8.q.out ad7fec9 
  ql/src/test/results/clientpositive/bucketmapjoin1.q.out 10f1af4 
  ql/src/test/results/clientpositive/bucketmapjoin10.q.out 88ecf40 
  ql/src/test/results/clientpositive/bucketmapjoin11.q.out 4ee1fa0 
  ql/src/test/results/clientpositive/bucketmapjoin12.q.out 9253f4a 
  ql/src/test/results/clientpositive/bucketmapjoin13.q.out b380fab 
  ql/src/test/results/clientpositive/bucketmapjoin2.q.out 297412f 
  ql/src/test/results/clientpositive/bucketmapjoin3.q.out 7f307a0 
  ql/src/test/results/clientpositive/bucketmapjoin4.q.out f0f9aee 
  ql/src/test/results/clientpositive/bucketmapjoin5.q.out 79e1c3d 
  ql/src/test/results/clientpositive/bucketmapjoin7.q.out 76baf50 
  ql/src/test/results/clientpositive/bucketmapjoin8.q.out 94fdbde 
  ql/src/test/results/clientpositive/bucketmapjoin9.q.out c9f4c17 
  ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out 751e32f 
  ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out 3eb70d1 
  ql/src/test/results/clientpositive/bucketmapjoin_negative3.q.out 34abe4f 
  ql/src/test/results/clientpositive/combine2.q.out 39e9363 
  ql/src/test/results/clientpositive/combine2_hadoop20.q.out e9947d9 
  ql/src/test/results/clientpositive/ctas.q.out 0040f3c 
  ql/src/test/results/clientpositive/ctas_hadoop20.q.out 63428b5 
  ql/src/test/results/clientpositive/disable_merge_for_bucketing.q.out 4f9bb94 
  ql/src/test/results/clientpositive/dynamic_partition_skip_default.q.out 61a7599 
  ql/src/test/results/clientpositive/explain_logical.q.out bb26e8c 
  ql/src/test/results/clientpositive/filter_join_breaktask.q.out d46e30a 
  ql/src/test/results/clientpositive/groupby_map_ppr.q.out c7ca521 
  ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out 00e2b6d 
  ql/src/test/results/clientpositive/groupby_ppr.q.out 57e886d 
  ql/src/test/results/clientpositive/groupby_ppr_multi_distinct.q.out f8073ff 
  ql/src/test/results/clientpositive/groupby_sort_1_23.q.out 38a0678 
  ql/src/test/results/clientpositive/groupby_sort_6.q.out ca5ad8f 
  ql/src/test/results/clientpositive/groupby_sort_skew_1_23.q.out ac54e7d 
  ql/src/test/results/clientpositive/input23.q.out 1891aae 
  ql/src/test/results/clientpositive/input42.q.out 8f52610 
  ql/src/test/results/clientpositive/input_part1.q.out 22191f1 
  ql/src/test/results/clientpositive/input_part2.q.out 9987769 
  ql/src/test/results/clientpositive/input_part7.q.out 19985d6 
  ql/src/test/results/clientpositive/input_part9.q.out 7ef66b0 
  ql/src/test/results/clientpositive/join17.q.out 76741bb 
  ql/src/test/results/clientpositive/join26.q.out bf8cf57 
  ql/src/test/results/clientpositive/join32.q.out ff0d7cc 
  ql/src/test/results/clientpositive/join32_lessSize.q.out 04ed6b2 
  ql/src/test/results/clientpositive/join33.q.out ff0d7cc 
  ql/src/test/results/clientpositive/join34.q.out b52777a 
  ql/src/test/results/clientpositive/join35.q.out 3053af7 
  ql/src/test/results/clientpositive/join9.q.out 16ce5a2 
  ql/src/test/results/clientpositive/join_filters_overlap.q.out 94ca28e 
  ql/src/test/results/clientpositive/join_map_ppr.q.out 51fb6c6 
  ql/src/test/results/clientpositive/list_bucket_dml_1.q.out b48c36a 
  ql/src/test/results/clientpositive/list_bucket_dml_10.q.out 5bfe938 
  ql/src/test/results/clientpositive/list_bucket_dml_11.q.out acf80aa 
  ql/src/test/results/clientpositive/list_bucket_dml_12.q.out fa5bc92 
  ql/src/test/results/clientpositive/list_bucket_dml_13.q.out a5813a6 
  ql/src/test/results/clientpositive/list_bucket_dml_14.q.out 730fa9e 
  ql/src/test/results/clientpositive/list_bucket_dml_2.q.out 5462629 
  ql/src/test/results/clientpositive/list_bucket_dml_3.q.out b786fc8 
  ql/src/test/results/clientpositive/list_bucket_dml_4.q.out 083568a 
  ql/src/test/results/clientpositive/list_bucket_dml_5.q.out 2db238e 
  ql/src/test/results/clientpositive/list_bucket_dml_6.q.out c1ababc 
  ql/src/test/results/clientpositive/list_bucket_dml_7.q.out 4c905e9 
  ql/src/test/results/clientpositive/list_bucket_dml_8.q.out ff94687 
  ql/src/test/results/clientpositive/list_bucket_dml_9.q.out 41872d7 
  ql/src/test/results/clientpositive/list_bucket_query_multiskew_1.q.out 81c519e 
  ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out 9caaece 
  ql/src/test/results/clientpositive/list_bucket_query_multiskew_3.q.out d4f833b 
  ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out 69b14fe 
  ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out 21fac22 
  ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out 01a8081 
  ql/src/test/results/clientpositive/load_dyn_part8.q.out 2299667 
  ql/src/test/results/clientpositive/louter_join_ppr.q.out 3dec6a6 
  ql/src/test/results/clientpositive/macro.q.out dc046ba 
  ql/src/test/results/clientpositive/merge3.q.out 96f675d 
  ql/src/test/results/clientpositive/metadataonly1.q.out f08ef9e 
  ql/src/test/results/clientpositive/multi_insert_subquery.q.out PRE-CREATION 
  ql/src/test/results/clientpositive/outer_join_ppr.q.out c9e3fbc 
  ql/src/test/results/clientpositive/pcr.q.out b74dfbf 
  ql/src/test/results/clientpositive/ppd_join_filter.q.out aa3af74 
  ql/src/test/results/clientpositive/ppd_union_view.q.out 82406be 
  ql/src/test/results/clientpositive/ppd_vc.q.out 928986f 
  ql/src/test/results/clientpositive/ppr_allchildsarenull.q.out 632fd4b 
  ql/src/test/results/clientpositive/push_or.q.out 132a160 
  ql/src/test/results/clientpositive/rand_partitionpruner1.q.out 1c49a25 
  ql/src/test/results/clientpositive/rand_partitionpruner2.q.out 557dd9d 
  ql/src/test/results/clientpositive/rand_partitionpruner3.q.out 93df215 
  ql/src/test/results/clientpositive/reduce_deduplicate.q.out cab7215 
  ql/src/test/results/clientpositive/regexp_extract.q.out 6218e77 
  ql/src/test/results/clientpositive/router_join_ppr.q.out aa2789f 
  ql/src/test/results/clientpositive/sample1.q.out e6adac9 
  ql/src/test/results/clientpositive/sample10.q.out f72d35e 
  ql/src/test/results/clientpositive/sample2.q.out 3f8a4cc 
  ql/src/test/results/clientpositive/sample4.q.out e6ee033 
  ql/src/test/results/clientpositive/sample5.q.out 57accb3 
  ql/src/test/results/clientpositive/sample6.q.out 45d355f 
  ql/src/test/results/clientpositive/sample7.q.out bc5a023 
  ql/src/test/results/clientpositive/sample8.q.out ddd81c2 
  ql/src/test/results/clientpositive/sample9.q.out 1dba5e1 
  ql/src/test/results/clientpositive/serde_user_properties.q.out 8022177 
  ql/src/test/results/clientpositive/smb_mapjoin9.q.out f0ab703 
  ql/src/test/results/clientpositive/smb_mapjoin_11.q.out d59b801 
  ql/src/test/results/clientpositive/smb_mapjoin_12.q.out ab3f93f 
  ql/src/test/results/clientpositive/smb_mapjoin_13.q.out e033da1 
  ql/src/test/results/clientpositive/smb_mapjoin_15.q.out 2a4bc28 
  ql/src/test/results/clientpositive/sort_merge_join_desc_5.q.out 5ff45d9 
  ql/src/test/results/clientpositive/sort_merge_join_desc_6.q.out 6fdf738 
  ql/src/test/results/clientpositive/sort_merge_join_desc_7.q.out 08b9d1e 
  ql/src/test/results/clientpositive/stats0.q.out 712a474 
  ql/src/test/results/clientpositive/stats11.q.out c5531c5 
  ql/src/test/results/clientpositive/subquery_in_having.q.out b88d717 
  ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out c835562 
  ql/src/test/results/clientpositive/tez/bucket2.q.out 3e7746f 
  ql/src/test/results/clientpositive/tez/bucket3.q.out cabf30a 
  ql/src/test/results/clientpositive/tez/bucket4.q.out 9d1e843 
  ql/src/test/results/clientpositive/tez/ctas.q.out a58e166 
  ql/src/test/results/clientpositive/tez/disable_merge_for_bucketing.q.out 0001443 
  ql/src/test/results/clientpositive/tez/filter_join_breaktask.q.out 494e1fb 
  ql/src/test/results/clientpositive/tez/sample1.q.out 6f8dfe9 
  ql/src/test/results/clientpositive/tez/transform_ppr1.q.out 719ae5b 
  ql/src/test/results/clientpositive/tez/transform_ppr2.q.out c82137c 
  ql/src/test/results/clientpositive/transform_ppr1.q.out 88baa2c 
  ql/src/test/results/clientpositive/transform_ppr2.q.out ec52c91 
  ql/src/test/results/clientpositive/truncate_column_list_bucket.q.out be8fafc 
  ql/src/test/results/clientpositive/udf_explode.q.out 4eeedeb 
  ql/src/test/results/clientpositive/udf_java_method.q.out a38ab76 
  ql/src/test/results/clientpositive/udf_reflect.q.out 63d67cb 
  ql/src/test/results/clientpositive/udf_reflect2.q.out 6b19277 
  ql/src/test/results/clientpositive/udtf_explode.q.out ae95907 
  ql/src/test/results/clientpositive/union22.q.out 4422e71 
  ql/src/test/results/clientpositive/union24.q.out dda55ca 
  ql/src/test/results/clientpositive/union_ppr.q.out 3016b61 
  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


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message