[ https://issues.apache.org/jira/browse/HIVE-12872?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15131976#comment-15131976 ]
fxliuwenjie commented on HIVE-12872: ------------------------------------ [ https://issues.apache.org/jira/browse/HIVE-12872?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15130724#comment-15130724 ] Damour benoit commented on HIVE-12872: -------------------------------------- Hello, I had just the same error with hive-1.1.1 and hadoop-2.6.0 Changing to hive-1.2.1 (hadoop-2.6.0) solved it for me. cheers ps: I first mistakenly kept my $HIVE_HOME (in .bashrc) set to my hive-1.1.1 home dir, and got the same error while running hive-1.2.1/bin/hive client. So watchout and remember to update your $HIVE_HOME when upgrading. -- This message was sent by Atlassian JIRA (v6.3.4#6332) > NoSuchMethodError exception Clause in Hive 1.1.1 > ------------------------------------------------ > > Key: HIVE-12872 > URL: https://issues.apache.org/jira/browse/HIVE-12872 > Project: Hive > Issue Type: Bug > Affects Versions: 1.1.1 > Environment: Hadoop 2.6.0 > Reporter: fxliuwenjie > > Firstly, i created a table : > hive>crete externale table beauties(id bigint, name string, heigth double) > partitioned by (nation string) row format delimited fields terminated by '\t' > location '/beauty'; > Then i loaded data into this table: > hive>load data loca inpath '/home/tmpdata/b.c' into table beauties > partition(nation='China'); > hive>load data local inpath '/home/tmpdata/b.j' into table beauties > partition(nation='Japan'); > Then i test to query the uploaded data: > hive>select * from beauties; > OK > 1 lee 165.0 China > 2 jzmb 167.0 Japan > When i tried to run the below query i faced the issue: > hive>select * from beauties where nation = 'China'; > Exception in thread "main" > java.lang.NoSuchMethodError:org.apache/hadoop.hive.ql.ppd.ExprWalkerInfo.getConvertedNode(Lorg/apache/hadoop/hive/ql/lib/Node;)Lorg/apache/hadoop/hive/ql/plan/ExprNodeDesc; > atorg.apache.hadoop.hive.ql.ppd.ExprWalkerProcFactory$GenericFuncExprProcessor.process(ExprWalkerProcFactory.java:176) > at > org.apache.hadoop.hive.ql.lib.DefaultRuleDispatcher.dispatch(DefaultRuleDispatcher.java:90) > at > org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.dispatchAndReturn(DefaultGraphWalker.java:94) > at > org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.dispatch(DefaultGraphWalker.java:78) > at > org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.walk(DefaultGraphWalker.java:132) > at > org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.startWalking(DefaultGraphWalker.java:109) > at > org.apache.hadoop.hive.ql.ppd.ExprWalkerProcFactory.extractPushdownPreds(ExprWalkerProcFactory.java:290) > at > org.apache.hadoop.hive.ql.ppd.ExprWalkerProcFactory.extractPushdownPreds(ExprWalkerProcFactory.java:241) > at > org.apache.hadoop.hive.ql.ppd.OpProcFactory$FilterPPD.process(OpProcFactory.java:418) > at > org.apache.hadoop.hive.ql.lib.DefaultRuleDispatcher.dispatch(DefaultRuleDispatcher.java:90) > at > org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.dispatchAndReturn(DefaultGraphWalker.java:94) > at > org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.dispatch(DefaultGraphWalker.java:78) > at > org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.walk(DefaultGraphWalker.java:132) > at > org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.startWalking(DefaultGraphWalker.java:109) > at > org.apache.hadoop.hive.ql.ppd.PredicatePushDown.transform(PredicatePushDown.java:135) > at > org.apache.hadoop.hive.ql.optimizer.Optimizer.optimize(Optimizer.java:182) > at > org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:10207) > at > org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal(CalcitePlanner.java:192)............. -- This message was sent by Atlassian JIRA (v6.3.4#6332)