You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@sentry.apache.org by "Jeremy Beard (JIRA)" <ji...@apache.org> on 2014/03/20 15:16:43 UTC

[jira] [Created] (SENTRY-151) UDF whitelist missing CAST UDFs

Jeremy Beard created SENTRY-151:
-----------------------------------

             Summary: UDF whitelist missing CAST UDFs
                 Key: SENTRY-151
                 URL: https://issues.apache.org/jira/browse/SENTRY-151
             Project: Sentry
          Issue Type: Bug
    Affects Versions: 1.2.0
            Reporter: Jeremy Beard
            Priority: Critical


The Sentry UDF whitelist is missing the UDFs used to cast data types, such as:

SELECT CAST(1000 AS timestamp) FROM table;
SELECT CAST(1000 AS string) FROM table;
etc.

This causes Sentry to reject the query with "No valid privileges".

The UDFs are listed here: https://github.com/apache/hive/blob/329c3dd250695e8f06e69aaff9c9da59bb8c4d4c/ql/src/java/org/apache/hadoop/hive/ql/exec/FunctionRegistry.java#L1663-L1669



--
This message was sent by Atlassian JIRA
(v6.2#6252)