Hi all,   I am trying to create an external table in hive:   CREATE external TABLE emp(tran_flag string, tab_name string,tran_time_utc timestamp, tran_time_loc string,something string,EMPNO INT, ENAME string,JOB string,MGR INT,HIREDATE string,SAL INT,COMM INT,DEPTNO INT)ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' stored as textfile location '/user/oraggs_cdhdev1/d551/bdtest.emp';   getting error:   User oraggs_cdhdev1 does not have privileges for CREATETABLE The required privileges: Server=server1->URI=hdfs://hostname/user/oraggs_cdhdev1/d551/bdtest.emp->action=*;), Query: CREATE external TABLE emp(tran_flag string, tab_name string,tran_time_utc timestamp, tran_time_loc string,something string,EMPNO INT, ENAME string,JOB string,MGR INT,HIREDATE string,SAL INT,COMM INT,DEPTNO INT)ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' stored as textfile location '/user/oraggs_cdhdev1/d551/bdtest.emp'. (state=HY000,code=500051)   +----------------------------+--------+------------+---------+------------------+-----------------+------------+---------------+-------------------+----------+--+ | database | table | partition | column | principal_name | principal_type | privilege | grant_option | grant_time | grantor | +----------------------------+--------+------------+---------+------------------+-----------------+------------+---------------+-------------------+----------+--+ | ggpoc | | | | goldengate_role | ROLE | * | 0 | 1476476669810000 | -- | | default | | | | goldengate_role | ROLE | select | 0 | 1459868647133000 | -- | | /user/oraggs_cdhdev1/d551 | | | | goldengate_role | ROLE | * | 0 | 1478092671457000 | -- | +----------------------------+--------+------------+---------+------------------+-----------------+------------+---------------+-------------------+----------+--+   what else privileges needs to be given ... View more