Re: Review Request 17887: Support subquery for single sourced multi query
---
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/17887/
---
(Updated July 9, 2014, 6:52 a.m.)
Review request for hive.
Changes
---
Rebased to trunk.
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 (updated)
-
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
Re: Review Request 17887: Support subquery for single sourced multi query
---
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/17887/
---
(Updated July 9, 2014, 6:53 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
Re: Review Request 17887: Support subquery for single sourced multi query
---
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
Re: Review Request 17887: Support subquery for single sourced multi query
---
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/17887/
---
(Updated Feb. 17, 2014, 1:17 a.m.)
Review request for hive.
Changes
---
Rebased to trunk.
TOK_QUERY ^(TOK_FROM TOK_INSERT) is changed to TOK_QUERY ^(TOK_INSERT TOK_FROM)
for simplicity of replacing INSERT clause (see top-level uNION_ALL cases)
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 (updated)
-
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
Re: Review Request 17887: Support subquery for single sourced multi query
---
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
Re: Review Request 17887: Support subquery for single sourced multi query
---
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/17887/
---
(Updated Feb. 17, 2014, 1:17 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
Review Request 17887: Support subquery for single sourced multi query
---
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
Re: Review Request 17887: Support subquery for single sourced multi query
---
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/17887/
---
(Updated Feb. 10, 2014, 3:56 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 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
