I want to know how can we join two tables in two different database in teradata server using PROC SQL.
Inside PROC SQL I am connecting to teradata using connect to teradata (user ='user pwd = 'xxxxx' server ='SERVER' connection = 'global'); I am trying something like this
proc sql; connect to teradata (user ='user pwd = 'xxxxx' server ='SERVER' connection = 'global'); execute (create volatile table abc as (select distinct COLUMN1 from DATABASE1.TABLE1 UNION select distinct COLUMN2 from DATABASE2.TABLE2 ) ) with data on commit preserve rows) by teradata; execute (commit work) by teradata; quit; Now how do I define two different database in same server in connect to teradata statement
I am getting the error: ERROR: Teradata execute: Request aborted by TDWM. Exception criteria exceeded: CPU Time, CPU Disk Ratio.
Your query got aborted because it reached the assigned maximum limit of resources. There must be an exception criteria defined on CPU Time and Disk Ratio with the exception action "Abort". Plus check the stats on both the tables, recheck the indexes for less consumption of CPU..Otherwise contact your DBA group.