The WRITE_NOS call in this statement includes an expression that generates a destination path name that it references in the PARTITION BY clause:
SELECT objectName FROM WRITE_NOS ( ON (SELECT c1, c2, c3, c4, CONCAT ('year=', SUBSTR (c4,1,4)) YearPath FROM chartab1) PARTITION BY c1, c3, YearPath ORDER BY c1, c3, YearPath USING LOCATION ('/s3/ceph-s3.teradata.com/co255015/writes/') AUTHORIZATION (CEPH_AUTH) NAMING ('DISCRETE') INCLUDE_ORDERING ('FALSE') STOREDAS ('PARQUET') ) AS d;
Query completed. 6 rows found. One column returned. Total elapsed time was 1 second. ObjectName --------------------------------------------------------------------------- /S3/ceph-s3.teradata.com/co255015/writes/8/70/year=1999/object_33_0_1.parquet /S3/ceph-s3.teradata.com/co255015/writes/2/10/year=2010/object_33_1_1.parquet /S3/ceph-s3.teradata.com/co255015/writes/4/60/year=2015/object_33_3_1.parquet /S3/ceph-s3.teradata.com/co255015/writes/5/60/year=2015/object_33_5_1.parquet /S3/ceph-s3.teradata.com/co255015/writes/7/70/year=1999/object_33_6_1.parquet /S3/ceph-s3.teradata.com/co255015/writes/1/10/year=2010/object_33_7_1.parquet