cyril liao created HIVE-3856: -------------------------------- Summary: 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