SemanticException: no valid privileges when querying with a cast on Hive <p>I'm getting a weird error when running any query with a <code>cast</code> as a non-admin. For example:</p> <pre><code>select cast(site_id as decimal) from test_table limit 5; </code></pre> <p>In that example, <code>site_id</code> is a <code>bigint</code>, but the column type and the type it's being cast as make no difference at all. The query runs fine in the absence of a <code>cast</code>, and the admin can run the query without issues as well. </p> <p>This is cdh 4.5.0, Hive 0.10.0.</p>