hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Damour benoit (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-11249) Issue in WHERE Clause in Hive1.1.1
Date Wed, 03 Feb 2016 17:23:39 GMT

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

Damour benoit commented on HIVE-11249:
--------------------------------------

same

> Issue in WHERE Clause in Hive1.1.1
> ----------------------------------
>
>                 Key: HIVE-11249
>                 URL: https://issues.apache.org/jira/browse/HIVE-11249
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 1.0.0, 1.2.0, 1.1.1
>         Environment: I am using Hadoop Version 2.5.0 (hadoop-common-2.5.0-cdh5.2.5.jar)
.
>            Reporter: Ravinder
>
> First I created a table named stocks with below command :
> CREATE EXTERNAL TABLE STOCKS(dt STRING, openPrice FLOAT , highPrice FLOAT , lowPrice
FLOAT , closePrice FLOAT , volume INT , adjClosePrice FLOAT )
>     PARTITIONED BY (exchng STRING, symbol STRING)
>     ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
>     LOCATION '/user/root/ravi/ext/' ;
> Then I loaded data into it by below command :
> load data inpath '/user/root/ravi/stocks_amex_aip.csv' into table stocks PARTITION(exchng='AMEX'
, symbol='AIP' );	
> When I tried to run the below query I faced the issue given below  ::
> select * from stocks where exchng is not null limit 10;
> 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;
>         at org.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)
>         at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:222)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message