Example: Selecting All Columns from QryLogEventHisV - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
prb1610499325399.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantageā„¢

Select all columns from QryLogEventHisV.

select * from dbc.QryLogEventHisV;

The query returns the following result:

ProcID     CollectTimeStamp                           EntryTS  EntryKind   EntryID  EntryType      EntryName    EventValue  LastValue Activity  ActivityId  ActivityName  ConfigId   SeqNo Spare1 Spare2 Spare3 FlexThrottleID  FlexThrottleSeqNo
------  -------------------------  --------------------------  ----------  -------  -----------  ------------  ----------  --------- --------  ----------  -------------- --------  ------ ------ ------ ------ --------------  -----------------
30718  2016-04-25 14:43:13.670000  2016-04-25 14:43:10.670000  EVENT             2  FLEX-CPU-PCT  FLEX-CPUT             1          1  INACTIVE           ?  ?              5,000       1    ?      ?       ?           ?            ?
30718  2016-04-25 14:38:32.660000  2016-04-25 14:38:28.560000  EXPRESSION        1  ?             FlexUDEExpress        ?          ?  ACTIVE             ?  ?              5,000       1    ?      ?       ?           ?            ?
30718  2016-04-25 14:43:38.630000  2016-04-25 14:43:35.610000  EXPRESSION        2  ?             FLEX-EXPR             ?          ?  INACTIVE           ?  ?              5,000       1    ?      ?       ?           ?            ?
30718  2016-04-25 14:41:38.250000  2016-04-25 14:41:35.230000  EXPRESSION        2  ?             FLEX-EXPR             ?          ?  ACTIVE             ?  ?              5,000       1    ?      ?       ?    307186992487951003  5
30718  2016-04-25 14:38:32.660000  2016-04-25 14:38:28.560000  EVENT             1  ?             FlexUDEEvent          ?          ?  EXPRESSION         1  FlexUDEExpress 5,000       2    ?      ?       ?           ?            ?