https://community.cloudera.com/t5/Archives-of-Support-Questions/NiFi-PutHiveQL-reflect-UDF-not-working/m-p/156939#M49074 <P>For a simple reflect function as below which works in HIVE shell, cannot be executed through PutHiveQL processor. Do you know if this is an expected behavior?</P><P>SELECT reflect("java.util.UUID", "nameUUIDFromBytes", "test") from dual</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="10367-nifi-hive-reflect.jpg" style="width: 958px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/20885i9DDE83238A9C049D/image-size/medium?v=v2&amp;px=400" role="button" title="10367-nifi-hive-reflect.jpg" alt="10367-nifi-hive-reflect.jpg" /></span></P> Sun, 18 Aug 2019 12:19:20 GMT ashsskum 2019-08-18T12:19:20Z https://community.cloudera.com/t5/Archives-of-Support-Questions/NiFi-PutHiveQL-reflect-UDF-not-working/m-p/156939#M49074 <P>For a simple reflect function as below which works in HIVE shell, cannot be executed through PutHiveQL processor. Do you know if this is an expected behavior?</P><P>SELECT reflect("java.util.UUID", "nameUUIDFromBytes", "test") from dual</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="10367-nifi-hive-reflect.jpg" style="width: 958px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/20885i9DDE83238A9C049D/image-size/medium?v=v2&amp;px=400" role="button" title="10367-nifi-hive-reflect.jpg" alt="10367-nifi-hive-reflect.jpg" /></span></P> Sun, 18 Aug 2019 12:19:20 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/NiFi-PutHiveQL-reflect-UDF-not-working/m-p/156939#M49074 ashsskum 2019-08-18T12:19:20Z https://community.cloudera.com/t5/Archives-of-Support-Questions/NiFi-PutHiveQL-reflect-UDF-not-working/m-p/156940#M49075 <P>One needs to allow for a reflect function, it's blacklisted by default. See e.g. this discussion: <A target="_blank" href="https://community.hortonworks.com/questions/25828/udf-reflect-is-not-allowed-beeline.html">https://community.hortonworks.com/questions/25828/udf-reflect-is-not-allowed-beeline.html</A></P> Fri, 16 Dec 2016 21:21:17 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/NiFi-PutHiveQL-reflect-UDF-not-working/m-p/156940#M49075 andrewg 2016-12-16T21:21:17Z