[ https://issues.apache.org/jira/browse/HIVE-915?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12986537#action_12986537 ]
Hongwei commented on HIVE-915: ------------------------------ Hello everybody, I've met a similar problem. https://issues.apache.org/jira/browse/HIVE-1922?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12985101#action_12985101 Could someone please help me to check if it's a version problem too? Thanks, > In WHERE clause, Hive failed to resolve alias for subquery with join(s) > ----------------------------------------------------------------------- > > Key: HIVE-915 > URL: https://issues.apache.org/jira/browse/HIVE-915 > Project: Hive > Issue Type: Bug > Components: Query Processor > Affects Versions: 0.4.0 > Environment: Hadoop v0.20.1 > Latest code from Hive branch-0.4 > Linux OS (both 32bit & 64bit) > Reporter: Nhan Nguyen > Priority: Critical > > When executing the below query > FROM (SELECT ip, country, count(1) AS total FROM eventlog WHERE > prt_date=20091022 GROUP BY ip, country) t1 JOIN bot_ip t2 ON t1.ip=t2.ip > SELECT t1.ip, t1.country > WHERE t1.total>0; > I got "FAILED: Unknown exception : null" > WHERE clause will not know about the alias t1. > And below is the stack trace > 2009-11-06 11:03:12,776 ERROR ql.Driver (SessionState.java:printError(279)) - > FAILED: Unknown exception : null > java.lang.NullPointerException > at > org.apache.hadoop.hive.ql.parse.QBMetaData.getTableForAlias(QBMetaData.java:76) > at > org.apache.hadoop.hive.ql.parse.ASTPartitionPruner.getTableColumnDesc(ASTPartitionPruner.java:298) > at > org.apache.hadoop.hive.ql.parse.ASTPartitionPruner.genExprNodeDesc(ASTPartitionPruner.java:220) > at > org.apache.hadoop.hive.ql.parse.ASTPartitionPruner.genExprNodeDesc(ASTPartitionPruner.java:234) > at > org.apache.hadoop.hive.ql.parse.ASTPartitionPruner.genExprNodeDesc(ASTPartitionPruner.java:234) > at > org.apache.hadoop.hive.ql.parse.ASTPartitionPruner.genExprNodeDesc(ASTPartitionPruner.java:234) > at > org.apache.hadoop.hive.ql.parse.ASTPartitionPruner.addExpression(ASTPartitionPruner.java:397) > at > org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genPartitionPruners(SemanticAnalyzer.java:624) > at > org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:4440) > at > org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:76) > at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:249) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:281) > at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:123) > at > org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:181) > at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:287) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at org.apache.hadoop.util.RunJar.main(RunJar.java:156) > It runs fine when omitting WHERE clause or WHERE clause doesn't reference to > any column of t1. It also runs fine if I make no join. > This is critical as sub-query is the current work-around for the unsupported > HAVING clause. > Hope this gets fixed soon. > Thanks -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.