[SENTRY-151] UDF whitelist missing CAST UDFs

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Duplicate
• Affects Version/s: 1.2.0
• Assignee: Unassigned
• Reporter: Jeremy Beard
• Created: 20/Mar/14 14:15
• Updated: 20/Mar/14 14:17
• Resolved: 20/Mar/14 14:17

Description

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

Issue Links

• duplicates: SENTRY-118 cast udf should be added to sentry udf whitelist for hive