Installing Custom Files on ML Engine | Teradata Vantage - Installing Custom Files - Teradata Vantage

Machine Learning User Guide
Product
Teradata Vantage
Release Number
9.01
1.3
Published
August 2020
Language
English (United States)
Last Update
2020-10-02
dita:mapPath
dci1595445931473.ditamap
dita:ditavalPath
dqp1599597541027.ditaval
dita:id
B700-4004
lifecycle
previous
Product Category
Teradata Vantage™
PrerequisiteThe file must be registered with a SQL identifier on ML Engine. In the following steps, sql_identifier is the name with which the file file_name.txt is registered with Advanced SQL Engine.
An authorized user can install a customized version of a preinstalled model file or input file (a text file) on ML Engine in the default schema, public schema, or both. In the default schema, only the current user can access the file.
  1. Copy your file to /etc/opt/teradata/tdconfig/Teradata/tdbs_udf/usr on Teradata MPP-1 node.
  2. Install the file in the default schema: 
    CALL SYSUIF.INSTALL_FILE ('sql_identifier',
  'file_name.txt', 'sb!file_name.txt');
CALL PM.INSTALL_AFILE ('sql_identifier');

    For example:

    CALL SYSUIF.INSTALL_FILE ('default_sentiment_lexicon',
  'default_sentiment_lexicon.txt', 'sb!default_sentiment_lexicon.txt');
CALL PM.INSTALL_AFILE ('default_sentiment_lexicon');
  3. Install the file in the public schema: 
    CALL SYSUIF.INSTALL_FILE ('sql_identifier',
  'file_name.txt', 'sb!file_name.txt');
CALL PM.INSTALL_AFILE_TO_PUBLIC ('sql_identifier');

    For example:

    CALL SYSUIF.INSTALL_FILE ('default_sentiment_lexicon',
  'default_sentiment_lexicon.txt', 'sb!default_sentiment_lexicon.txt');
CALL PM.INSTALL_AFILE_TO_PUBLIC ('default_sentiment_lexicon');