You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@sentry.apache.org by "Ravi Nagvekar (JIRA)" <ji...@apache.org> on 2016/10/23 23:02:58 UTC

[jira] [Commented] (SENTRY-719) create external table tablename, if tablename exists, instead of warning user table already exists, throws exception: MetaException(message:java.lang.NullPointerException) (state=08S01,code=1)

    [ https://issues.apache.org/jira/browse/SENTRY-719?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15600450#comment-15600450 ] 

Ravi Nagvekar commented on SENTRY-719:
--------------------------------------

Hi any update on this I am also facing this error after adding Jar AUX path.

hive> drop database ravitest1;
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:java.lang.NullPointerException)
server1:21000] > CREATE TABLE IF NOT EXISTS employee ( eid int, name String, phoneno String);
Query: create TABLE IF NOT EXISTS employee ( eid int, name String, phoneno String)
ERROR:
ImpalaRuntimeException: Error making 'createTable' RPC to Hive Metastore:
CAUSED BY: MetaException: java.lang.NullPointerException


> create external table tablename, if tablename exists, instead of warning user table already exists, throws exception: MetaException(message:java.lang.NullPointerException) (state=08S01,code=1) 
> -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: SENTRY-719
>                 URL: https://issues.apache.org/jira/browse/SENTRY-719
>             Project: Sentry
>          Issue Type: Bug
>    Affects Versions: 1.4.0
>            Reporter: Anne Yu
>            Assignee: Prasad Mujumdar
>
> {code}
> 0: jdbc:hive2://a2110.halxg.cloudera.com:1000> CREATE external TABLE employees2(name STRING, salary FLOAT, subordinates ARRAY<STRING>, deductions MAP<STRING, FLOAT>, address STRUCT<street:STRING, city:STRING, state:STRING, zip:INT>) PARTITIONED BY(country STRING, state STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001' COLLECTION ITEMS TERMINATED BY '\002' MAP KEYS TERMINATED BY '\003' LINES TERMINATED BY '\n' LOCATION '/data/employees';
> Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:java.lang.NullPointerException) (state=08S01,code=1)
> {code}



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