registered user is unable to update stats for hive table.

[Julie Thai]

Registered user is able to query hive table, but attempt to update statistics on hive table fails with ERROR[9241].

As 'qauser_cmp':
Welcome to Trafodion Command Interface
Copyright(C) 2013-2014 Hewlett-Packard Development Company, L.P.

Host Name/IP Address: localhost:37800
User Name: qauser_cmp

Connected to Trafodion

SQL>obey repo4.sql;

SQL>cqd query_cache '0';

--- SQL operation complete.

SQL>update statistics for table hive.tpch2x.nation on every column;

*** ERROR[9241] Insufficient privileges to perform the statistics request for table HIVE.TPCH2X.NATION. [2015-04-15 19:39:31]

SQL>showstats for table hive.tpch2x.nation on existing columns;

Histogram data for Table HIVE.TPCH2X.NATION
Table ID: 0

   Hist ID # Ints Rowcount UEC Colname(s)
========== ====== =========== =========== ===========================
1468601408 25 25 25 N_COMMENT
1468601415 5 25 5 N_REGIONKEY
1468601418 25 25 25 N_NAME
1468601425 25 25 25 N_NATIONKEY

--- SQL operation complete.

SQL>select count(*) from hive.tpch2x.nation;

(EXPR)
--------------------
                  25

--- 1 row(s) selected.

SQL>invoke hive.tpch2x.nation;

-- Definition of hive table NATION
-- Definition current Wed Apr 15 19:39:49 2015

  (
    N_NATIONKEY INT
  , N_NAME VARCHAR(32000 BYTES) CHARACTER SET UTF8
      COLLATE DEFAULT
  , N_REGIONKEY INT
  , N_COMMENT VARCHAR(32000 BYTES) CHARACTER SET UTF8
      COLLATE DEFAULT
  )
   /* stored as text */

--- SQL operation complete.

SQL>exit

whereas as 'trafodion':

Welcome to Trafodion Command Interface
Copyright(C) 2013-2014 Hewlett-Packard Development Company, L.P.

Host Name/IP Address: localhost:37800
User Name: trafodion

Connected to Trafodion

SQL>obey repo4.sql;

SQL>cqd query_cache '0';

--- SQL operation complete.

SQL>update statistics for table hive.tpch2x.nation on every column;

--- SQL operation complete.

SQL>showstats for table hive.tpch2x.nation on existing columns;

Histogram data for Table HIVE.TPCH2X.NATION
Table ID: 0

   Hist ID # Ints Rowcount UEC Colname(s)
========== ====== =========== =========== ===========================
1468601408 25 25 25 N_COMMENT
1468601415 5 25 5 N_REGIONKEY
1468601418 25 25 25 N_NAME
1468601425 25 25 25 N_NATIONKEY

--- SQL operation complete.

SQL>select count(*) from hive.tpch2x.nation;

(EXPR)
--------------------
                  25

--- 1 row(s) selected.

SQL>invoke hive.tpch2x.nation;

-- Definition of hive table NATION
-- Definition current Wed Apr 15 19:31:54 2015

  (
    N_NATIONKEY INT
  , N_NAME VARCHAR(32000 BYTES) CHARACTER SET UTF8
      COLLATE DEFAULT
  , N_REGIONKEY INT
  , N_COMMENT VARCHAR(32000 BYTES) CHARACTER SET UTF8
      COLLATE DEFAULT
  )
   /* stored as text */

--- SQL operation complete.

SQL>exit

[Julie Thai (julie-y-thai)]

to reproduce:
1. in hive, create table junk (a int, b int);
2. instantiate trafci, specifying user/passwd of registered user other than trafodion, and issue
    update statistics for table hive.hive.junk on every column; ERROR[9241] is reported.

[Roberta Marton (roberta-marton)]

Added a check for a hive table during the authorization check to return successful.
This may change once Trafodion is Kerberized ...