You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:20:19 UTC
[jira] [Created] (TRAFODION-1181) LP Bug: 1444669 - registered user
is unable to update stats for hive table.
Alice Chen created TRAFODION-1181:
-------------------------------------
Summary: LP Bug: 1444669 - registered user is unable to update stats for hive table.
Key: TRAFODION-1181
URL: https://issues.apache.org/jira/browse/TRAFODION-1181
Project: Apache Trafodion
Issue Type: Bug
Components: sql-security
Reporter: Julie Thai
Assignee: Roberta Marton
Priority: Critical
Fix For: 2.0-incubating
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
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)