https://community.cloudera.com/t5/Support-Questions/UDF-reflect-is-not-allowed-beeline/m-p/155074#M117513 <P>Hi Raja, the Reflect UDF is actually blacklisted by default when running queries through HiveServer2 (beeline, ODBC, JDBC connections), as it can be a security risk. See this JIRA, for example: <A href="https://issues.apache.org/jira/browse/HIVE-8893">HIVE-8893</A>. This works in hive CLI, because the hive CLI does not use HiveServer2. The JIRA is available in HDP 2.2.4 and higher.</P><P>You can check this by running this in beeline:</P><PRE>set hive.server2.builtin.udf.blacklist;</PRE><P>reflect will probably be listed there. You can remove it from the blacklist property and also make sure this property is empty:</P><PRE>hive.server2.builtin.udf.whitelist</PRE><P>Apply the changes and restart HiveServer2 and you should see the reflect UDF working.</P><P>See <A href="https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-hive.server2.builtin.udf.whitelist">Apache Hive documentation</A> on these properties for further info. </P> Wed, 06 Apr 2016 20:15:37 GMT agillan 2016-04-06T20:15:37Z