RE: ERROR: Hive subquery showing

[yogesh dhari]

Hi Bejoy,

I tried this one also but here it throws horrible error:

i.e:

hive: select name from ABD where grp=MAX(grp);

FAILED: Hive Internal Error: java.lang.NullPointerException(null)
java.lang.NullPointerException
    at 
org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc.newInstance(ExprNodeGenericFuncDesc.java:214)
    at 
org.apache.hadoop.hive.ql.parse.TypeCheckProcFactory$DefaultExprProcessor.getXpathOrFuncExprNodeDesc(TypeCheckProcFactory.java:684)
    at 
org.apache.hadoop.hive.ql.parse.TypeCheckProcFactory$DefaultExprProcessor.process(TypeCheckProcFactory.java:805)
    at 
org.apache.hadoop.hive.ql.lib.DefaultRuleDispatcher.dispatch(DefaultRuleDispatcher.java:89)
    at 
org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.dispatch(DefaultGraphWalker.java:88)
    at 
org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.walk(DefaultGraphWalker.java:125)
    at 
org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.startWalking(DefaultGraphWalker.java:102)
    at 
org.apache.hadoop.hive.ql.parse.TypeCheckProcFactory.genExprNode(TypeCheckProcFactory.java:161)
    at 
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genExprNodeDesc(SemanticAnalyzer.java:7506)
    at 
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genExprNodeDesc(SemanticAnalyzer.java:7464)
    at 
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genFilterPlan(SemanticAnalyzer.java:1513)
    at 
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genFilterPlan(SemanticAnalyzer.java:1494)
    at 
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genBodyPlan(SemanticAnalyzer.java:5886)
    at 
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genPlan(SemanticAnalyzer.java:6524)
    at 
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:7282)
    at 
org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:243)
    at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:430)
    at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:337)
    at org.apache.hadoop.hive.ql.Driver.run(Driver.java:889)
    at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:255)
    at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:212)
    at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:403)
    at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:671)
    at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:554)
    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:601)
    at org.apache.hadoop.util.RunJar.main(RunJar.java:156)

Regards
Yogesh Kumar

Subject: Re: ERROR: Hive subquery showing
To: user@hive.apache.org
From: bejoy...@yahoo.com
Date: Thu, 27 Sep 2012 19:48:25 +0000

Hi yogesh

What about a query like this
select name from ABC WHERE grp=MAX(grp); 

Regards
Bejoy KS

Sent from handheld, please excuse typos.From:  Chen Song 
<chen.song...@gmail.com>
Date: Thu, 27 Sep 2012 15:33:11 -0400To: <user@hive.apache.org>ReplyTo:  
user@hive.apache.org
Subject: Re: ERROR: Hive subquery showing
Can you try this?
select name from ( select MAX(grp) as name from ABC ) gy ;

On Thu, Sep 27, 2012 at 3:29 PM, yogesh dhari <yogeshdh...@live.com> wrote:





Hi all,

I have a table called ABC, like

name    grp
A             1
B             2
C             4
D             8

I want the output like the name having greatest grp i.e D;

I wrote a query:


select name from ( select MAX(grp) from ABC ) gy ;

but it gives error

FAILED: Error in semantic analysis: Line 1:7 Invalid table alias or column 
reference 'name': (possible column names are: _col0)


Please help and suggest why it is so, and what would be the query;


Thanks & regards
Yogesh Kumar





                                          


-- 
Chen Song