Validating Analytic Functions - 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

The following explains how to validate if ML Engine and Advanced SQL Engine functions are installed, accessible, and functioning. It is an easy way to get you started using the analytic functions when you first receive your Vantage system or to validate connectivity between Advanced SQL Engine and ML Engine after a maintenance system reboot.

You can run the following commands from any client (such as BTEQ or Teradata Studio).

If you use BTEQ, you can copy and paste SQL statements at the command line as follows:

  • To run a single-statement SQL request, press Enter at the end of the line.
  • To run a multistatement SQL request, press Enter after the last line. If you do not press Enter, every statement runs automatically except the statement on the last line.
  1. From a client application (such as BTEQ or Teradata Studio), log on to the Vantage system as DBC. For example:
    .logon systemname.your_company.com/dbc

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

  2. Run the following command:
    help foreign schema "public"@coprocessor;
    In this command, public must be enclosed in quotation marks because it is a reserved word.

    The command returns a list of functions that are installed. If an error is reported, the command will not return a complete list of objects in the schema.