You can check the QLM query log to validate queries are running on ML Engine.
-
From a client application (such as BTEQ or Teradata Studio), log on to the Vantage system as a user that has SELECT on td_mle_db.querylog. For example:
.logon systemname.your_company.com/rose
-
Count the number of queries stored in the QLM log. Run:
select count(*) from td_mle_db.querylog;
The result should be non-zero.
-
Log off:
.logoff
PostrequisiteIf you created a test user (such as rose), remove the user. For example:
.logon systemname.your_company.com/dbc
delete user rose;
drop user rose;
.logoff