hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hive QA (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-6403) uncorrelated subquery is failing with auto.convert.join=true
Date Tue, 18 Feb 2014 14:10:20 GMT

    [ https://issues.apache.org/jira/browse/HIVE-6403?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13904072#comment-13904072
] 

Hive QA commented on HIVE-6403:
-------------------------------



{color:red}Overall{color}: -1 no tests executed

Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12629459/HIVE-6403.5.patch.txt

Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/1378/testReport
Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/1378/console

Messages:
{noformat}
**** This message was trimmed, see log for full details ****
Reverted 'ql/src/test/results/clientpositive/decimal_5.q.out'
Reverted 'ql/src/test/results/clientpositive/bucketmapjoin8.q.out'
Reverted 'ql/src/test/results/clientpositive/progress_1.q.out'
Reverted 'ql/src/test/results/clientpositive/nestedvirtual.q.out'
Reverted 'ql/src/test/results/clientpositive/parallel.q.out'
Reverted 'ql/src/test/results/clientpositive/convert_enum_to_string.q.out'
Reverted 'ql/src/test/results/clientpositive/annotate_stats_filter.q.out'
Reverted 'ql/src/test/results/clientpositive/bucketmapjoin12.q.out'
Reverted 'ql/src/test/results/clientpositive/groupby8_map_skew.q.out'
Reverted 'ql/src/test/results/clientpositive/varchar_1.q.out'
Reverted 'ql/src/test/results/clientpositive/insert1_overwrite_partitions.q.out'
Reverted 'ql/src/test/results/clientpositive/join27.q.out'
Reverted 'ql/src/test/results/clientpositive/load_file_with_space_in_the_name.q.out'
Reverted 'ql/src/test/results/clientpositive/load_dyn_part11.q.out'
Reverted 'ql/src/test/results/clientpositive/input4.q.out'
Reverted 'ql/src/test/results/clientpositive/stats6.q.out'
Reverted 'ql/src/test/results/clientpositive/leadlag_queries.q.out'
Reverted 'ql/src/test/results/clientpositive/rename_partition_location.q.out'
Reverted 'ql/src/test/results/clientpositive/udf_translate.q.out'
Reverted 'ql/src/test/results/clientpositive/union12.q.out'
Reverted 'ql/src/test/results/clientpositive/index_compact_2.q.out'
Reverted 'ql/src/test/results/clientpositive/udf2.q.out'
Reverted 'ql/src/test/results/clientpositive/sort_merge_join_desc_1.q.out'
Reverted 'ql/src/test/results/clientpositive/windowing_udaf.q.out'
Reverted 'ql/src/test/results/clientpositive/smb_mapjoin_17.q.out'
Reverted 'ql/src/test/results/clientpositive/ppd_repeated_alias.q.out'
Reverted 'ql/src/test/results/clientpositive/join36.q.out'
Reverted 'ql/src/test/results/clientpositive/avro_joins.q.out'
Reverted 'ql/src/test/results/clientpositive/drop_with_concurrency.q.out'
Reverted 'ql/src/test/results/clientpositive/lock2.q.out'
Reverted 'ql/src/test/results/clientpositive/input_part5.q.out'
Reverted 'ql/src/test/results/clientpositive/bucketmapjoin3.q.out'
Reverted 'ql/src/test/results/clientpositive/insert_into2.q.out'
Reverted 'ql/src/test/results/clientpositive/alter_skewed_table.q.out'
Reverted 'ql/src/test/results/clientpositive/groupby_grouping_sets2.q.out'
Reverted 'ql/src/test/results/clientpositive/timestamp_1.q.out'
Reverted 'ql/src/test/results/clientpositive/partition_vs_table_metadata.q.out'
Reverted 'ql/src/test/results/clientpositive/groupby12.q.out'
Reverted 'ql/src/test/results/clientpositive/groupby1_limit.q.out'
Reverted 'ql/src/test/results/clientpositive/cast1.q.out'
Reverted 'ql/src/test/results/clientpositive/input16_cc.q.out'
Reverted 'ql/src/test/results/clientpositive/annotate_stats_part.q.out'
Reverted 'ql/src/test/results/clientpositive/partition_wise_fileformat15.q.out'
Reverted 'ql/src/test/results/clientpositive/stats1.q.out'
Reverted 'ql/src/test/results/clientpositive/symlink_text_input_format.q.out'
Reverted 'ql/src/test/results/clientpositive/ptf_register_tblfn.q.out'
Reverted 'ql/src/test/results/clientpositive/ddltime.q.out'
Reverted 'ql/src/test/results/clientpositive/uniquejoin.q.out'
Reverted 'ql/src/test/results/clientpositive/ppd_constant_expr.q.out'
Reverted 'ql/src/test/results/clientpositive/union30.q.out'
Reverted 'ql/src/test/results/clientpositive/timestamp_null.q.out'
Reverted 'ql/src/test/results/clientpositive/combine1.q.out'
Reverted 'ql/src/test/results/clientpositive/avro_sanity_test.q.out'
Reverted 'ql/src/test/results/clientpositive/exim_06_one_part.q.out'
Reverted 'ql/src/test/results/clientpositive/groupby_multi_insert_common_distinct.q.out'
Reverted 'ql/src/test/results/clientpositive/groupby2_noskew.q.out'
Reverted 'ql/src/test/results/clientpositive/index_stale.q.out'
Reverted 'ql/src/test/results/clientpositive/vectorized_timestamp_funcs.q.out'
Reverted 'ql/src/test/results/clientpositive/smb_mapjoin_12.q.out'
Reverted 'ql/src/test/results/clientpositive/metadataonly1.q.out'
Reverted 'ql/src/test/results/clientpositive/join31.q.out'
Reverted 'ql/src/test/results/clientpositive/concatenate_inherit_table_location.q.out'
Reverted 'ql/src/test/results/clientpositive/alter_rename_partition_authorization.q.out'
Reverted 'ql/src/test/results/clientpositive/rcfile_toleratecorruptions.q.out'
Reverted 'ql/src/test/results/clientpositive/auto_join7.q.out'
Reverted 'ql/src/test/results/clientpositive/nonreserved_keywords_insert_into1.q.out'
Reverted 'ql/src/test/results/clientpositive/bucketsortoptimize_insert_7.q.out'
Reverted 'ql/src/test/results/clientpositive/tablename_with_select.q.out'
Reverted 'ql/src/test/results/clientpositive/exim_04_all_part.q.out'
Reverted 'ql/src/test/results/clientpositive/join32_lessSize.q.out'
Reverted 'ql/src/test/results/clientpositive/correlationoptimizer11.q.out'
Reverted 'ql/src/test/results/clientpositive/multiMapJoin1.q.out'
Reverted 'ql/src/test/results/clientpositive/alter3.q.out'
Reverted 'ql/src/test/results/clientpositive/smb_mapjoin_21.q.out'
Reverted 'ql/src/test/results/clientpositive/exim_23_import_part_authsuccess.q.out'
Reverted 'ql/src/test/results/clientpositive/groupby4_map_skew.q.out'
Reverted 'ql/src/test/results/clientpositive/exim_01_nonpart.q.out'
Reverted 'ql/src/test/results/clientpositive/auto_sortmerge_join_7.q.out'
Reverted 'ql/src/test/results/clientpositive/groupby7_noskew.q.out'
Reverted 'ql/src/test/results/clientpositive/test_boolean_whereclause.q.out'
Reverted 'ql/src/test/results/clientpositive/drop_index_removes_partition_dirs.q.out'
Reverted 'ql/src/test/results/clientpositive/partition_wise_fileformat10.q.out'
Reverted 'ql/src/test/results/clientpositive/compute_stats_long.q.out'
Reverted 'ql/src/test/results/clientpositive/inputddl7.q.out'
Reverted 'ql/src/test/results/clientpositive/join5.q.out'
Reverted 'ql/src/test/results/clientpositive/describe_syntax.q.out'
Reverted 'ql/src/test/results/clientpositive/add_part_multiple.q.out'
Reverted 'ql/src/test/results/clientpositive/external_table_with_space_in_location_path.q.out'
Reverted 'ql/src/test/results/clientpositive/fileformat_text.q.out'
Reverted 'ql/src/test/results/clientpositive/char_udf1.q.out'
Reverted 'ql/src/test/results/clientpositive/date_1.q.out'
Reverted 'ql/src/test/results/clientpositive/exim_08_nonpart_rename.q.out'
Reverted 'ql/src/test/results/clientpositive/list_bucket_dml_10.q.out'
Reverted 'ql/src/test/results/clientpositive/windowing.q.out'
Reverted 'ql/src/test/results/clientpositive/auto_join2.q.out'
Reverted 'ql/src/test/results/clientpositive/udf_reverse.q.out'
Reverted 'ql/src/test/results/clientpositive/bucketsortoptimize_insert_2.q.out'
Reverted 'ql/src/test/results/clientpositive/union3.q.out'
Reverted 'ql/src/test/results/clientpositive/show_create_table_partitioned.q.out'
Reverted 'ql/src/test/results/clientpositive/input1_limit.q.out'
Reverted 'ql/src/test/results/clientpositive/groupby8.q.out'
Reverted 'ql/src/test/results/clientpositive/scriptfile1.q.out'
Reverted 'ql/src/test/results/clientpositive/groupby_sort_9.q.out'
Reverted 'ql/src/test/results/clientpositive/groupby_grouping_id1.q.out'
Reverted 'ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out'
Reverted 'ql/src/test/results/clientpositive/auto_sortmerge_join_2.q.out'
Reverted 'ql/src/test/results/clientpositive/alter_varchar2.q.out'
Reverted 'ql/src/test/results/clientpositive/skewjoinopt6.q.out'
Reverted 'ql/src/test/results/clientpositive/load_dyn_part6.q.out'
Reverted 'ql/src/test/results/clientpositive/inputddl2.q.out'
Reverted 'ql/src/test/results/clientpositive/drop_partitions_filter2.q.out'
Reverted 'ql/src/test/results/clientpositive/sample7.q.out'
Reverted 'ql/src/test/results/clientpositive/rcfile_union.q.out'
Reverted 'ql/src/test/results/clientpositive/nullinput2.q.out'
Reverted 'ql/src/test/results/clientpositive/exim_10_external_managed.q.out'
Reverted 'ql/src/test/results/clientpositive/ptf_general_queries.q.out'
Reverted 'ql/src/test/results/clientpositive/create_escape.q.out'
Reverted 'ql/src/test/results/clientpositive/exim_07_all_part_over_nonoverlap.q.out'
Reverted 'ql/src/test/results/clientpositive/annotate_stats_limit.q.out'
Reverted 'ql/src/test/results/clientpositive/alter_char2.q.out'
Reverted 'ql/src/test/results/clientpositive/input_testsequencefile.q.out'
Reverted 'ql/src/test/results/clientpositive/join_view.q.out'
Reverted 'ql/src/test/results/clientpositive/udf_get_json_object.q.out'
Reverted 'ql/src/test/results/clientpositive/input_testxpath.q.out'
Reverted 'ql/src/test/results/clientpositive/input19.q.out'
Reverted 'ql/src/test/results/clientpositive/bucket_map_join_2.q.out'
Reverted 'ql/src/test/results/clientpositive/groupby3.q.out'
Reverted 'ql/src/test/results/clientpositive/ba_table3.q.out'
Reverted 'ql/src/test/results/clientpositive/join_empty.q.out'
Reverted 'ql/src/test/results/clientpositive/windowing_rank.q.out'
Reverted 'ql/src/test/results/clientpositive/groupby_sort_4.q.out'
Reverted 'ql/src/test/results/clientpositive/parquet_partitioned.q.out'
Reverted 'ql/src/test/results/clientpositive/reduce_deduplicate_exclude_gby.q.out'
Reverted 'ql/src/test/results/clientpositive/skewjoinopt18.q.out'
Reverted 'ql/src/test/results/clientpositive/archive_excludeHadoop20.q.out'
Reverted 'ql/src/test/results/clientpositive/skewjoinopt1.q.out'
Reverted 'ql/src/test/results/clientpositive/load_dyn_part1.q.out'
Reverted 'ql/src/test/results/clientpositive/sample2.q.out'
Reverted 'ql/src/test/results/clientpositive/exim_03_nonpart_over_compat.q.out'
Reverted 'ql/src/test/results/clientpositive/stats16.q.out'
Reverted 'ql/src/test/results/clientpositive/input28.q.out'
Reverted 'ql/src/test/results/clientpositive/smb_mapjoin_4.q.out'
Reverted 'ql/src/test/results/clientpositive/auto_sortmerge_join_14.q.out'
Reverted 'ql/src/test/results/clientpositive/disable_merge_for_bucketing.q.out'
Reverted 'ql/src/test/results/clientpositive/ppd_union_view.q.out'
Reverted 'ql/src/test/results/clientpositive/input_testxpath2.q.out'
Reverted 'ql/src/test/results/clientpositive/create_like_tbl_props.q.out'
Reverted 'ql/src/test/results/clientpositive/groupby7_map_multi_single_reducer.q.out'
Reverted 'ql/src/test/results/clientpositive/partition_wise_fileformat9.q.out'
Reverted 'ql/src/test/results/clientpositive/truncate_column.q.out'
Reverted 'ql/src/test/results/clientpositive/mergejoins.q.out'
Reverted 'ql/src/test/results/clientpositive/groupby_complex_types.q.out'
Reverted 'ql/src/test/results/clientpositive/input14.q.out'
Reverted 'ql/src/test/results/clientpositive/bucketcontext_5.q.out'
Reverted 'ql/src/test/results/clientpositive/input37.q.out'
Reverted 'ql/src/test/results/clientpositive/binary_table_colserde.q.out'
Reverted 'ql/src/test/results/clientpositive/skewjoinopt13.q.out'
Reverted 'ql/src/test/results/clientpositive/describe_comment_nonascii.q.out'
Reverted 'ql/src/test/results/clientpositive/mapreduce4.q.out'
Reverted 'ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out'
Reverted 'ql/src/test/results/clientpositive/nullscript.q.out'
Reverted 'ql/src/test/results/clientpositive/stats11.q.out'
Reverted 'ql/src/test/results/clientpositive/bucket5.q.out'
Reverted 'ql/src/test/results/clientpositive/alter_merge_stats.q.out'
Reverted 'ql/src/test/results/clientpositive/udf_round_2.q.out'
Reverted 'ql/src/test/results/clientpositive/filter_numeric.q.out'
Reverted 'ql/src/test/results/clientpositive/input46.q.out'
Reverted 'ql/src/test/queries/clientnegative/authorization_addpartition.q'
Reverted 'ql/src/test/queries/clientnegative/authorization_droppartition.q'
Reverted 'ql/src/java/org/apache/hadoop/hive/ql/plan/HiveOperation.java'
Reverted 'ql/src/java/org/apache/hadoop/hive/ql/parse/LoadSemanticAnalyzer.java'
Reverted 'ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java'
Reverted 'ql/src/java/org/apache/hadoop/hive/ql/parse/DDLSemanticAnalyzer.java'
Reverted 'ql/src/java/org/apache/hadoop/hive/ql/metadata/Hive.java'
Reverted 'ql/src/java/org/apache/hadoop/hive/ql/hooks/ReadEntity.java'
Reverted 'ql/src/java/org/apache/hadoop/hive/ql/hooks/WriteEntity.java'
Reverted 'ql/src/java/org/apache/hadoop/hive/ql/security/authorization/plugin/sqlstd/SQLAuthorizationUtils.java'
Reverted 'ql/src/java/org/apache/hadoop/hive/ql/security/authorization/plugin/sqlstd/Operation2Privilege.java'
Reverted 'ql/src/java/org/apache/hadoop/hive/ql/security/authorization/plugin/sqlstd/RequiredPrivileges.java'
Reverted 'ql/src/java/org/apache/hadoop/hive/ql/security/authorization/plugin/sqlstd/SQLStdHiveAuthorizationValidator.java'
Reverted 'ql/src/java/org/apache/hadoop/hive/ql/security/SessionStateConfigUserAuthenticator.java'
Reverted 'ql/src/java/org/apache/hadoop/hive/ql/Driver.java'
++ awk '{print $2}'
++ egrep -v '^X|^Performing status on external'
++ svn status --no-ignore
+ rm -rf target datanucleus.log ant/target shims/target shims/0.20/target shims/0.20S/target
shims/0.23/target shims/aggregator/target shims/common/target shims/common-secure/target packaging/target
hbase-handler/target testutils/target jdbc/target metastore/target itests/target itests/hcatalog-unit/target
itests/test-serde/target itests/qtest/target itests/hive-unit/target itests/custom-serde/target
itests/util/target hcatalog/target hcatalog/storage-handlers/hbase/target hcatalog/server-extensions/target
hcatalog/core/target hcatalog/webhcat/svr/target hcatalog/webhcat/java-client/target hcatalog/hcatalog-pig-adapter/target
hwi/target common/target common/src/gen service/target contrib/target serde/target beeline/target
odbc/target cli/target ql/dependency-reduced-pom.xml ql/target ql/src/test/results/clientnegative/authorization_uri_create_table_ext.q.out
ql/src/test/results/clientnegative/authorization_uri_insert.q.out ql/src/test/results/clientnegative/authorization_uri_load_data.q.out
ql/src/test/results/clientnegative/authorization_uri_insert_local.q.out ql/src/test/results/clientnegative/authorization_uri_create_table1.q.out
ql/src/test/results/clientnegative/authorization_uri_altertab_setloc.q.out ql/src/test/results/clientnegative/authorization_uri_createdb.q.out
ql/src/test/results/clientnegative/authorization_uri_index.q.out ql/src/test/results/clientnegative/authorization_uri_add_partition.q.out
ql/src/test/results/clientnegative/authorization_uri_alterpart_loc.q.out ql/src/test/queries/clientnegative/authorization_uri_load_data.q
ql/src/test/queries/clientnegative/authorization_uri_createdb.q ql/src/test/queries/clientnegative/authorization_uri_alterpart_loc.q
ql/src/test/queries/clientnegative/authorization_uri_insert_local.q ql/src/test/queries/clientnegative/authorization_uri_add_partition.q
ql/src/test/queries/clientnegative/authorization_uri_altertab_setloc.q ql/src/test/queries/clientnegative/authorization_uri_insert.q
ql/src/test/queries/clientnegative/authorization_uri_index.q ql/src/test/queries/clientnegative/authorization_uri_create_table_ext.q
ql/src/test/queries/clientnegative/authorization_uri_create_table1.q ql/src/java/org/apache/hadoop/hive/ql/parse/DDLSemanticAnalyzer.java.orig
ql/src/java/org/apache/hadoop/hive/ql/security/authorization/plugin/sqlstd/Operation2Privilege.java.orig
+ svn update

Fetching external item into 'hcatalog/src/test/e2e/harness'
External at revision 1569331.

At revision 1569331.
+ patchCommandPath=/data/hive-ptest/working/scratch/smart-apply-patch.sh
+ patchFilePath=/data/hive-ptest/working/scratch/build.patch
+ [[ -f /data/hive-ptest/working/scratch/build.patch ]]
+ chmod +x /data/hive-ptest/working/scratch/smart-apply-patch.sh
+ /data/hive-ptest/working/scratch/smart-apply-patch.sh /data/hive-ptest/working/scratch/build.patch
The patch does not appear to apply with p0, p1, or p2
+ exit 1
'
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12629459

> uncorrelated subquery is failing with auto.convert.join=true
> ------------------------------------------------------------
>
>                 Key: HIVE-6403
>                 URL: https://issues.apache.org/jira/browse/HIVE-6403
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>            Reporter: Navis
>            Assignee: Navis
>         Attachments: HIVE-6403.1.patch, HIVE-6403.2.patch, HIVE-6403.3.patch.txt, HIVE-6403.4.patch.txt,
HIVE-6403.5.patch.txt, navis.patch, navis2.patch
>
>
> Fixing HIVE-5690, I've found query in subquery_multiinsert.q is not working with hive.auto.convert.join=true

> {noformat}
> set hive.auto.convert.join=true;
> hive> explain
>     > from src b 
>     > INSERT OVERWRITE TABLE src_4 
>     >   select * 
>     >   where b.key in 
>     >    (select a.key 
>     >     from src a 
>     >     where b.value = a.value and a.key > '9'
>     >    ) 
>     > INSERT OVERWRITE TABLE src_5 
>     >   select *  
>     >   where b.key not in  ( select key from src s1 where s1.key > '2') 
>     >   order by key 
>     > ;
> java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
> 	at java.util.ArrayList.rangeCheck(ArrayList.java:635)
> 	at java.util.ArrayList.get(ArrayList.java:411)
> 	at org.apache.hadoop.hive.ql.optimizer.MapJoinProcessor.genMapJoinLocalWork(MapJoinProcessor.java:149)
> 	at org.apache.hadoop.hive.ql.optimizer.MapJoinProcessor.genLocalWorkForMapJoin(MapJoinProcessor.java:256)
> 	at org.apache.hadoop.hive.ql.optimizer.MapJoinProcessor.genMapJoinOpAndLocalWork(MapJoinProcessor.java:248)
> 	at org.apache.hadoop.hive.ql.optimizer.physical.CommonJoinTaskDispatcher.convertTaskToMapJoinTask(CommonJoinTaskDispatcher.java:191)
> 	at org.apache.hadoop.hive.ql.optimizer.physical.CommonJoinTaskDispatcher.processCurrentTask(CommonJoinTaskDispatcher.java:481)
> 	at org.apache.hadoop.hive.ql.optimizer.physical.AbstractJoinTaskDispatcher.dispatch(AbstractJoinTaskDispatcher.java:182)
> 	at org.apache.hadoop.hive.ql.lib.TaskGraphWalker.dispatch(TaskGraphWalker.java:111)
> 	at org.apache.hadoop.hive.ql.lib.TaskGraphWalker.walk(TaskGraphWalker.java:194)
> 	at org.apache.hadoop.hive.ql.lib.TaskGraphWalker.startWalking(TaskGraphWalker.java:139)
> 	at org.apache.hadoop.hive.ql.optimizer.physical.CommonJoinResolver.resolve(CommonJoinResolver.java:79)
> 	at org.apache.hadoop.hive.ql.optimizer.physical.PhysicalOptimizer.optimize(PhysicalOptimizer.java:100)
> 	at org.apache.hadoop.hive.ql.parse.MapReduceCompiler.optimizeTaskPlan(MapReduceCompiler.java:290)
> 	at org.apache.hadoop.hive.ql.parse.TaskCompiler.compile(TaskCompiler.java:216)
> 	at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:9167)
> 	at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:327)
> 	at org.apache.hadoop.hive.ql.parse.ExplainSemanticAnalyzer.analyzeInternal(ExplainSemanticAnalyzer.java:64)
> 	at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:327)
> 	at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:446)
> 	at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:346)
> 	at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1056)
> 	at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1099)
> 	at org.apache.hadoop.hive.ql.Driver.run(Driver.java:992)
> 	at org.apache.hadoop.hive.ql.Driver.run(Driver.java:982)
> 	at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:268)
> 	at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:220)
> 	at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:424)
> 	at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:793)
> 	at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:687)
> 	at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:626)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> 	at java.lang.reflect.Method.invoke(Method.java:606)
> 	at org.apache.hadoop.util.RunJar.main(RunJar.java:160)
> org.apache.hadoop.hive.ql.parse.SemanticException: Failed to generate new mapJoin operator
by exception : Index: 0, Size: 0
> 	at org.apache.hadoop.hive.ql.optimizer.MapJoinProcessor.genLocalWorkForMapJoin(MapJoinProcessor.java:266)
> 	at org.apache.hadoop.hive.ql.optimizer.MapJoinProcessor.genMapJoinOpAndLocalWork(MapJoinProcessor.java:248)
> 	at org.apache.hadoop.hive.ql.optimizer.physical.CommonJoinTaskDispatcher.convertTaskToMapJoinTask(CommonJoinTaskDispatcher.java:191)
> 	at org.apache.hadoop.hive.ql.optimizer.physical.CommonJoinTaskDispatcher.processCurrentTask(CommonJoinTaskDispatcher.java:481)
> 	at org.apache.hadoop.hive.ql.optimizer.physical.AbstractJoinTaskDispatcher.dispatch(AbstractJoinTaskDispatcher.java:182)
> 	at org.apache.hadoop.hive.ql.lib.TaskGraphWalker.dispatch(TaskGraphWalker.java:111)
> 	at org.apache.hadoop.hive.ql.lib.TaskGraphWalker.walk(TaskGraphWalker.java:194)
> 	at org.apache.hadoop.hive.ql.lib.TaskGraphWalker.startWalking(TaskGraphWalker.java:139)
> 	at org.apache.hadoop.hive.ql.optimizer.physical.CommonJoinResolver.resolve(CommonJoinResolver.java:79)
> 	at org.apache.hadoop.hive.ql.optimizer.physical.PhysicalOptimizer.optimize(PhysicalOptimizer.java:100)
> 	at org.apache.hadoop.hive.ql.parse.MapReduceCompiler.optimizeTaskPlan(MapReduceCompiler.java:290)
> 	at org.apache.hadoop.hive.ql.parse.TaskCompiler.compile(TaskCompiler.java:216)
> 	at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:9167)
> 	at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:327)
> 	at org.apache.hadoop.hive.ql.parse.ExplainSemanticAnalyzer.analyzeInternal(ExplainSemanticAnalyzer.java:64)
> 	at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:327)
> 	at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:446)
> 	at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:346)
> 	at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1056)
> 	at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1099)
> 	at org.apache.hadoop.hive.ql.Driver.run(Driver.java:992)
> 	at org.apache.hadoop.hive.ql.Driver.run(Driver.java:982)
> 	at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:268)
> 	at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:220)
> 	at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:424)
> 	at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:793)
> 	at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:687)
> 	at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:626)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> 	at java.lang.reflect.Method.invoke(Method.java:606)
> 	at org.apache.hadoop.util.RunJar.main(RunJar.java:160)
> FAILED: SemanticException Generate Map Join Task Error: Failed to generate new mapJoin
operator by exception : Index: 0, Size: 0
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)

Mime
View raw message