Validating NewSQL Engine to Machine Learning Engine Link - Teradata Vantage

Configuring Teradata Vantageā„¢ After Installation

Product
Teradata Vantage
Release Number
1.1
Published
July 2019
Language
English (United States)
Last Update
2019-10-11
dita:mapPath
qyu1559916244734.ditamap
dita:ditavalPath
jsj1481748799576.ditaval
dita:id
B700-4014
lifecycle
previous
Product Category
Analytical Ecosystem
Software
Teradata Vantage
  1. From a client application (such as BTEQ or Teradata Studio), log on to Vantage as DBC. For example:
    .logon systemname.your_company.com/dbc

    where systemname is the primary database node (the name by which Vantage is known to the network, also called the TDPID).

    If you run this as another user, the user must have the ANY privilege granted on the server object (td_server_db.coprocessor) to display the output from HELP FOREIGN SERVER.
  2. Run the command:
    help foreign server td_server_db.coprocessor;
    
    The command returns a list of databases on the Machine Learning Engine. For example:
    Name
    ------------------
    beehive

    If an error results:

    Error Condition Result Resolution
    MLE functions are available, the user does not have permissions on the foreign server # help foreign server td_server_db.coprocessor;

    *** Failure 3523 The user does not have any access to TD_SERVER_DB.coprocessor.

    You can grant the user permission. Run:

    GRANT EXECUTE FUNCTION on TD_SERVER_DB.coprocessor TO <user>;

    MLE functions are not available # help foreign server td_server_db.coprocessor;

    *** Failure 3807 Object 'TD_SERVER_DB.coprocessor' does not exist.

    Contact Teradata Customer Support.