[jira] [Updated] (TRAFODION-1025) LP Bug: 1425748 - User with manage_statistics privilege unable to create stats for Hive table

["Suresh Subbiah (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-1025?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Suresh Subbiah updated TRAFODION-1025:
--------------------------------------
    Assignee: David Wayne Birdsall  (was: Barry Fritchman)

> LP Bug: 1425748 - User with manage_statistics privilege unable to create stats for Hive table
> ---------------------------------------------------------------------------------------------
>
>                 Key: TRAFODION-1025
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-1025
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-cmp
>            Reporter: Barry Fritchman
>            Assignee: David Wayne Birdsall
>             Fix For: 2.0-incubating
>
>
> Under the following circumstances, Update Statistics will fail with an error trying to create the sb_histograms table in a schema (trafodion.hivestats) that does not exist:
> 1) The user is not db__root
> 2) The user has the manage_statistics component privilege
> 3) The user does NOT have the create_schema component privilege
> 4) There have been no previous successful attempts to update statistics on a Hive table
> Without schema creating privilege, the attempt by Update Stats to create the trafodion.hivestats schema will fail without terminating execution of the statement, the assumption being that the failure was due to the schema already existing. Subsequently, the attempt to create trafodion.hivestats.sb_histograms will fail because the containing schema does not exist.
> The addition of the create_schema component privilege introduces the possibility of another error besides the harmless "schema already exists" error.  Even though create_schema is granted to public by default, this can't be relied on, and the error needs to be checked before deciding to continue execution.  This requires some changes to the general-purpose function that executes internal statements on behalf of Update Statistics. A cleaner solution would be possible if the IF NOT EXISTS clause was supported for creation of schemas, as it is for creation of tables.



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