TPT12120 error in TPT export operator

Tools

TPT12120 error in TPT export operator

Hi,

I am trying to export data using TPT export operator. It is successing if I dont use any qualify function in SQL, but failing if i use one.

can we use Qualify (like qualify row_number() over(partition by col1 order by col2, col3) = 1) function in TPT export SQL

thanks

Tags (2)
2 REPLIES
Teradata Employee

Re: TPT12120 error in TPT export operator

Please post the script, and the entire output from the job.

-- SteveF
Teradata Employee

Re: TPT12120 error in TPT export operator

I looked up the TPT12120 error. It states:

"Order By clause and Multiple Instances are mutually exclusive"

This is pretty obvious.

Your SELECT statement has an ORDER BY clause in it, but you have requested multiple instances to execute in the Export operator. You cannot have parallelism when you have an ORDER BY clause in the SELECT.

Either remove the ORDER BY, or change your script so that you are only specifying 1 instance of the Export operator.

-- SteveF