Installing or Uninstalling TD_Analyze UDFs - Teradata Warehouse Miner

Teradata® Warehouse Miner™ User Guide - Volume 1Introduction and Profiling

Product
Teradata Warehouse Miner
Release Number
5.4.6
Published
November 2018
Language
English (United States)
Last Update
2018-12-07
dita:mapPath
rfc1538171534881.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2300
Product Category
Software
Users of the Teradata Profiler or ADS Generator product can skip this section.
Certain functions or options require that the TD_Analyze external stored procedure and table operators tda_kmeans and tda_dt_calc be installed. To install these UDFs, you must execute the Install or Uninstall UDFs program item in the Teradata Warehouse Miner program group, selecting the option to “Install TD_Analyze Udfs.” This program creates the UDFs by locating the Teradata Client Utility BTEQ. If it exists on the system, you can proceed with the load. Otherwise, an error occurs. The following GRANT statements must be executed prior to the UDF installation::
GRANT EXECUTE PROCEDURE on SQLJ.REMOVE_JAR to <dbname>;
GRANT EXECUTE PROCEDURE on SQLJ.INSTALL_JAR to <dbname>;
GRANT EXECUTE PROCEDURE on SQLJ.ALTER_JAVA_PATH to <dbname>;

The options enabled by the installation of these UDFs include the Fast K-Means clustering option and the Gain Ratio Extreme decision tree option.

See Installing or Uninstalling PMML Scoring UDFs for details about executing the Install or Uninstall UDFs program.