2.10 - Show or Describe - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

prodname
Teradata QueryGrid
vrm_release
2.10
created_date
September 2019
category
Administration
Configuration
Installation
User Guide
featnum
B035-5991-099K
The following examples use different HELP commands on the Teradata system to show or describe queries for schema discovery requests that are supported by the Oracle target connector.

Help Foreign Server

help foreign server oraclefs_active;

*** Query completed. 37 rows found. 5 columns returned.
*** Total elapsed time was 4 seconds.

USERNAME          PRAMA_USR
USER_ID           597
CREATED           2018-04-05 07:54:50.000000
COMMON            NO
ORACLE_MAINTAINED N

Help Foreign Database or Schema

help foreign schema SIMBATERADATA@oraclefs_active;
      
     *** Query completed. 31 rows found. 65 columns returned.
     *** Total elapsed time was 2 seconds.
      
                         OWNER SIMBATERADATA
                    TABLE_NAME ORACLETYPET
               TABLESPACE_NAME USERS
                  CLUSTER_NAME ?
                      IOT_NAME ?
                        STATUS VALID
                      PCT_FREE 10
                      PCT_USED ?
                     INI_TRANS 1
                     MAX_TRANS 255
                INITIAL_EXTENT 65536
                   NEXT_EXTENT 1048576
                   MIN_EXTENTS 1
                   MAX_EXTENTS 2147483645
                  PCT_INCREASE ?
                     FREELISTS ?
               FREELIST_GROUPS ?
                       LOGGING YES
                     BACKED_UP N
                      NUM_ROWS 1
                        BLOCKS 5
                  EMPTY_BLOCKS 0
                     AVG_SPACE 0
                     CHAIN_CNT 0
                   AVG_ROW_LEN 89
     AVG_SPACE_FREELIST_BLOCKS 0
           NUM_FREELIST_BLOCKS 0
                        DEGREE 1
                     INSTANCES 1
                         CACHE N
                    TABLE_LOCK ENABLED
                   SAMPLE_SIZE 1
                 LAST_ANALYZED 2018-02-01 03:00:22.000000
                   PARTITIONED NO
                      IOT_TYPE ?
                     TEMPORARY N
                     SECONDARY N
                        NESTED NO
                   BUFFER_POOL DEFAULT
                   FLASH_CACHE DEFAULT
              CELL_FLASH_CACHE DEFAULT
                  ROW_MOVEMENT DISABLED
                  GLOBAL_STATS YES
                    USER_STATS NO
                      DURATION ?
                  SKIP_CORRUPT DISABLED
                    MONITORING YES
                 CLUSTER_OWNER ?
                  DEPENDENCIES DISABLED
                   COMPRESSION DISABLED
                  COMPRESS_FOR ?
                       DROPPED NO
                     READ_ONLY NO
               SEGMENT_CREATED YES
                  RESULT_CACHE DEFAULT
                    CLUSTERING NO
             ACTIVITY_TRACKING ?
                 DML_TIMESTAMP ?
                  HAS_IDENTITY NO
                CONTAINER_DATA NO
                      INMEMORY DISABLED
             INMEMORY_PRIORITY ?
           INMEMORY_DISTRIBUTE ?
          INMEMORY_COMPRESSION ?
            INMEMORY_DUPLICATE ?

Help Foreign Table

help foreign table SIMBATERADATA.t1@oraclefs_active;
 
*** Query completed. One row found. 36 columns returned.
*** Total elapsed time was 1 second.
 
               OWNER SIMBATERADATA
          TABLE_NAME t1
         COLUMN_NAME A
           DATA_TYPE DATE
       DATA_TYPE_MOD ?
     DATA_TYPE_OWNER ?
         DATA_LENGTH 7
      DATA_PRECISION ?
          DATA_SCALE ?
            NULLABLE Y
           COLUMN_ID 1
      DEFAULT_LENGTH ?
        DATA_DEFAULT ?
        NUM_DISTINCT ?
           LOW_VALUE ?
          HIGH_VALUE ?
             DENSITY ?
           NUM_NULLS ?
         NUM_BUCKETS ?
       LAST_ANALYZED ?
         SAMPLE_SIZE ?
  CHARACTER_SET_NAME ?
CHAR_COL_DECL_LENGTH ?
        GLOBAL_STATS NO
          USER_STATS NO
         AVG_COL_LEN ?
         CHAR_LENGTH 0
           CHAR_USED ?
       V80_FMT_IMAGE NO
       DATA_UPGRADED YES
           HISTOGRAM NONE
     DEFAULT_ON_NULL NO
     IDENTITY_COLUMN NO
  EVALUATION_EDITION ?
     UNUSABLE_BEFORE ?
  UNUSABLE_BEGINNING ?