[jira] [Created] (SENTRY-899) alter view NPE: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.SentryFilterDDLTask. Unable to alter table. java.lang.NullPointerException

["Anne Yu (JIRA)" <ji...@apache.org>]

Anne Yu created SENTRY-899:
------------------------------

             Summary: alter view NPE: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.SentryFilterDDLTask. Unable to alter table. java.lang.NullPointerException
                 Key: SENTRY-899
                 URL: https://issues.apache.org/jira/browse/SENTRY-899
             Project: Sentry
          Issue Type: Bug
          Components: Sentry
    Affects Versions: 1.5.1
            Reporter: Anne Yu


{code}

alter view test_userid_view as select link from pageviews;

org.apache.hive.service.cli.HiveSQLException: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.SentryFilterDDLTask. Unable to alter table. java.lang.NullPointerException
        at org.apache.hive.service.cli.operation.Operation.toSQLException(Operation.java:315)
        at org.apache.hive.service.cli.operation.SQLOperation.runQuery(SQLOperation.java:146)
        at org.apache.hive.service.cli.operation.SQLOperation.access$100(SQLOperation.java:69)
        at org.apache.hive.service.cli.operation.SQLOperation$1$1.run(SQLOperation.java:196)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.Subject.doAs(Subject.java:415)
        at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1671)
        at org.apache.hive.service.cli.operation.SQLOperation$1.run(SQLOperation.java:208)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
        at java.util.concurrent.FutureTask.run(FutureTask.java:262)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Unable to alter table. java.lang.NullPointerException
        at org.apache.hadoop.hive.ql.metadata.Hive.alterTable(Hive.java:533)
        at org.apache.hadoop.hive.ql.metadata.Hive.alterTable(Hive.java:519)
        at org.apache.hadoop.hive.ql.exec.DDLTask.createView(DDLTask.java:4195)
        at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:338)
        at org.apache.hadoop.hive.ql.exec.SentryFilterDDLTask.execute(SentryFilterDDLTask.java:91)
        at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:160)
        at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:88)
        at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1637)
        at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1397)
        at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1181)
        at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1047)
        at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1042)
        at org.apache.hive.service.cli.operation.SQLOperation.runQuery(SQLOperation.java:144)
        ... 11 more
Caused by: MetaException(message:java.lang.NullPointerException)
        at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$alter_table_with_cascade_result$alter_table_with_cascade_resultStandardScheme.read(ThriftHiveMetastore.java:40856)
        at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$alter_table_with_cascade_result$alter_table_with_cascade_resultStandardScheme.read(ThriftHiveMetastore.java:40833)
        at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$alter_table_with_cascade_result.read(ThriftHiveMetastore.java:40775)
        at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:78)
        at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_alter_table_with_cascade(ThriftHiveMetastore.java:1370)
        at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.alter_table_with_cascade(ThriftHiveMetastore.java:1354)
{code}

but the operation succeeded at the end.
{code}
0: jdbc:hive2://anneyu-sentry-1.vpc.cloudera.> alter view test_userid_view as select userid from pageviews;
Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.SentryFilterDDLTask. Unable to alter table. java.lang.NullPointerException (state=08S01,code=1)
0: jdbc:hive2://anneyu-sentry-1.vpc.cloudera.> describe test_userid_view;
+-----------+--------------+----------+--+
| col_name  |  data_type   | comment  |
+-----------+--------------+----------+--+
| userid    | varchar(64)  |          |
+-----------+--------------+----------+--+
1 row selected (0.137 seconds)
{code}

cc [~guoquan], [~sravya], [~lskuff]



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