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
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.