You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Roberta Marton (JIRA)" <ji...@apache.org> on 2015/10/16 02:06:06 UTC
[jira] [Closed] (TRAFODION-1181) LP Bug: 1444669 - registered user
is unable to update stats for hive table.
[ https://issues.apache.org/jira/browse/TRAFODION-1181?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Roberta Marton closed TRAFODION-1181.
-------------------------------------
> 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)