https://community.cloudera.com/t5/Support-Questions/UDF-reflect-is-not-allowed-beeline/m-p/155076#M117515 <P><STRONG>Symptom</STRONG></P><P>Not able to use reflect function using beeline, but the query works OK with Hvi CLI.</P><P><STRONG>Error Message:</STRONG></P><P>Error while compiling statement: FAILED: SemanticException UDF reflect is not allowed (state=42000,code=40000)</P><P><STRONG>Cause</STRONG></P><P>When running <EM>set hive.server2.builtin.udf.blacklist</EM> from beeline, it will return the following as blacklisted:</P><PRE>jdbc:hive2://localhost:10000/default&gt; set hive.server2.builtin.udf.blacklist;<BR /> +------------------------------------------------------------------+--+<BR /> | set |<BR /> +------------------------------------------------------------------+--+<BR /> | hive.server2.builtin.udf.blacklist=reflect,reflect2,java_method |<BR /> +------------------------------------------------------------------+--+</PRE><P>Reflect UDF is blacklisted by default when running queries through HiveServer2 (beeline, ODBC, JDBC connections), as it was found to be a security risk. </P><P>The <A href="https://github.com/apache/hive/blob/ff67cdda1c538dc65087878eeba3e165cf3230f4/ql/src/java/org/apache/hadoop/hive/ql/security/authorization/plugin/SettableConfigUpdater.java">code</A> was modified so if the parameter hive.server2.builtin.udf.blacklist has not been configured or it is blank, its default value will be <CODE>"reflect,reflect2,java_method".</CODE></P><P><STRONG>Resolution</STRONG></P><P>1. Open the Ambari UI</P><P>2. Add the custom property in Ambari hive.server2.builtin.udf.blacklist under Hive / Configs / Advanced / Custom hive-site and give it any value, for example "empty_blacklist".</P><P>3. Restart services as requested by Ambari.</P><P>4. Connect again with beeline and verify that blacklist only includes the dummy value now.</P><PRE>0: jdbc:hive2://localhost:10000/default&gt; set hive.server2.builtin.udf.blacklist;<BR />+-------------------------------------------+--+<BR /> | hive.server2.builtin.udf.blacklist=empty_blacklist |<BR /> +-------------------------------------------+--+ </PRE><P>5. Reflect should work now without issues.</P> Wed, 06 Sep 2017 17:58:40 GMT oleggorj 2017-09-06T17:58:40Z