[
https://issues.apache.org/jira/browse/HIVE-3856?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13641578#comment-13641578
]
Teddy Choi commented on HIVE-3856:
----------------------------------
[~cyril.liao], could you post your database schema and sample data? It will be
helpful to reproduce this bug.
> Authorization report NPE when table partition do not exits
> ----------------------------------------------------------
>
> Key: HIVE-3856
> URL: https://issues.apache.org/jira/browse/HIVE-3856
> Project: Hive
> Issue Type: Bug
> Components: Authorization
> Affects Versions: 0.9.0
> Environment: hadoop 0.20.205 hive 0.9.0
> Reporter: cyril liao
>
> the following hql report npe:
> use app;select a.name from( select profile['net'] as name from
> app.app_profile where p_day = 20130103 group by profile['net']) a left outer
> join app.app_network_mode b on a.name = b.name where b.name is null;
> the errors are :
> 2013-01-04 11:10:05,905 ERROR ql.Driver (SessionState.java:printError(400)) -
> FAILED: Hive Internal Error: java.lang.NullPointerException(null)
> java.lang.NullPointerException
> at org.apache.hadoop.hive.ql.Driver.doAuthorization(Driver.java:625)
> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:486)
> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:336)
> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:917)
> at
> org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:258)
> at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:215)
> at
> org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:406)
> at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:689)
> at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:557)
> 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)
> If i change the partition condition from "p_day = 20130103" to "p_day =
> 20121228" , it works. The "p_day=20121228" partition ensure exits ,but the
> "p_pay=20130103" partition do not exit.
> The statement should not report NPE !
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
