CREATE FOREIGN TABLE and READ_NOS Queries
The following examples show CREATE FOREIGN TABLE and READ_NOS queries with TABLE_FORMAT NVP as DELTALAKE, MANIFEST NVP set to TRUE and the location of the manifest file inside the _symlink_format_manifest folder.
CREATE FOREIGN TABLE is used to create a manifest table. The table is created using the data files from the manifest files in the given location.
create foreign table dl_table1 ,EXTERNAL SECURITY INVOKER TRUSTED test0 USING ( LOCATION ('/s3/s3.amazonaws.com/testdeltalake/deltalakewp/_symlink_format_manifest') MANIFEST('TRUE') TABLE_FORMAT('DELTALAKE') );
Result:
*** Table has been created. *** Total elapsed time was 4 seconds. +---------+---------+---------+---------+---------+---------+---------+--------+
show table dl_table1;
Result:
*** Text of DDL statement returned. *** Total elapsed time was 1 second. --------------------------------------------------------------------------------
CREATE MULTISET FOREIGN TABLE dl_table1 ,FALLBACK , EXTERNAL SECURITY INVOKER TRUSTED TEST0 , MAP = TD_MAP1 ( Location VARCHAR(2048) CHARACTER SET UNICODE CASESPECIFIC, street VARCHAR(22) CHARACTER SET UNICODE NOT CASESPECIFIC, state VARCHAR(2) CHARACTER SET UNICODE NOT CASESPECIFIC, bedrooms INTEGER, bathrooms INTEGER, sqft INTEGER, types VARCHAR(11) CHARACTER SET UNICODE NOT CASESPECIFIC, price INTEGER) USING ( LOCATION ('/s3/s3.amazonaws.com/testdeltalake/deltalakewp/_symlink_format_manifest') MANIFEST ('TRUE') TABLE_FORMAT ('DELTALAKE') PATHPATTERN ('$var1/$zip/$var3') STOREDAS ('PARQUET') ) NO PRIMARY INDEX PARTITION BY COLUMN ADD 65524;
SELECT * FROM dl_table1;
Result:
*** Query completed. 61 rows found. 8 columns returned. *** Total elapsed time was 6 seconds. Location --------------------------------------------------------------------------------------------- /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00009-70377ec9-23db-4c9b-9c1f-50bf90a72d9a.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00007-1ca7a971-5117-46b4-85b2-c7752bbdc2cb.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00006-917150c3-054a-4ac7-a4ea-0ba96b39a598.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00005-0d48136f-25b1-4ee7-b754-b6d47dab8901.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00004-66a61240-33fd-4fba-8bd1-5e53653984f5.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00008-f6f1e0f6-5ccd-48ff-97f0-b2d427b5ccec.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00003-e4c7c3cb-7aa0-4814-85e2-4683c1cec53e.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00002-83b8aad2-9d4a-4cef-ac9a-acb07340b7d4.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00009-70377ec9-23db-4c9b-9c1f-50bf90a72d9a.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00007-1ca7a971-5117-46b4-85b2-c7752bbdc2cb.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00006-917150c3-054a-4ac7-a4ea-0ba96b39a598.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00005-0d48136f-25b1-4ee7-b754-b6d47dab8901.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00004-66a61240-33fd-4fba-8bd1-5e53653984f5.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00008-f6f1e0f6-5ccd-48ff-97f0-b2d427b5ccec.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00003-e4c7c3cb-7aa0-4814-85e2-4683c1cec53e.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00002-83b8aad2-9d4a-4cef-ac9a-acb07340b7d4.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00009-70377ec9-23db-4c9b-9c1f-50bf90a72d9a.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00007-1ca7a971-5117-46b4-85b2-c7752bbdc2cb.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00006-917150c3-054a-4ac7-a4ea-0ba96b39a598.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00005-0d48136f-25b1-4ee7-b754-b6d47dab8901.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00004-66a61240-33fd-4fba-8bd1-5e53653984f5.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00008-f6f1e0f6-5ccd-48ff-97f0-b2d427b5ccec.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00002-83b8aad2-9d4a-4cef-ac9a-acb07340b7d4.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00009-70377ec9-23db-4c9b-9c1f-50bf90a72d9a.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00007-1ca7a971-5117-46b4-85b2-c7752bbdc2cb.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00006-917150c3-054a-4ac7-a4ea-0ba96b39a598.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00005-0d48136f-25b1-4ee7-b754-b6d47dab8901.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00004-66a61240-33fd-4fba-8bd1-5e53653984f5.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00008-f6f1e0f6-5ccd-48ff-97f0-b2d427b5ccec.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00009-70377ec9-23db-4c9b-9c1f-50bf90a72d9a.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00007-1ca7a971-5117-46b4-85b2-c7752bbdc2cb.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00006-917150c3-054a-4ac7-a4ea-0ba96b39a598.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00005-0d48136f-25b1-4ee7-b754-b6d47dab8901.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00004-66a61240-33fd-4fba-8bd1-5e53653984f5.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00008-f6f1e0f6-5ccd-48ff-97f0-b2d427b5ccec.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00001-79ff7696-ba19-48fc-bbb4-842fbe04baac.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00007-1ca7a971-5117-46b4-85b2-c7752bbdc2cb.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00006-917150c3-054a-4ac7-a4ea-0ba96b39a598.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00005-0d48136f-25b1-4ee7-b754-b6d47dab8901.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00004-66a61240-33fd-4fba-8bd1-5e53653984f5.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00008-f6f1e0f6-5ccd-48ff-97f0-b2d427b5ccec.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00001-79ff7696-ba19-48fc-bbb4-842fbe04baac.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00000-a1f8f541-c0b2-44ad-bfef-447a383400d1.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95661/part-00002-00c3c9b4-fc91-4762-8724-d1f7cdcd8a72.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00005-0d48136f-25b1-4ee7-b754-b6d47dab8901.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00004-66a61240-33fd-4fba-8bd1-5e53653984f5.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00001-79ff7696-ba19-48fc-bbb4-842fbe04baac.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00000-a1f8f541-c0b2-44ad-bfef-447a383400d1.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95661/part-00002-00c3c9b4-fc91-4762-8724-d1f7cdcd8a72.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00005-0d48136f-25b1-4ee7-b754-b6d47dab8901.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00004-66a61240-33fd-4fba-8bd1-5e53653984f5.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00001-79ff7696-ba19-48fc-bbb4-842fbe04baac.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00000-a1f8f541-c0b2-44ad-bfef-447a383400d1.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95661/part-00002-00c3c9b4-fc91-4762-8724-d1f7cdcd8a72.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95661/part-00001-09b48cd3-5c6a-467a-a63a-134c752cdede.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95661/part-00000-0ab15a43-e3b4-4832-8775-d3db4b960bcc.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00000-a1f8f541-c0b2-44ad-bfef-447a383400d1.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95661/part-00001-09b48cd3-5c6a-467a-a63a-134c752cdede.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95661/part-00000-0ab15a43-e3b4-4832-8775-d3db4b960bcc.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00000-a1f8f541-c0b2-44ad-bfef-447a383400d1.c000.snappy.par /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95661/part-00000-0ab15a43-e3b4-4832-8775-d3db4b960bcc.c000.snappy.par
SELECT street FROM dl_table1;
Result:
*** Query completed. 61 rows found. One column returned. *** Total elapsed time was 3 seconds. street ---------------------- 3536 SUN MAIDEN WAY 3828 BLACKFOOT WAY 3361 ALDER CANYON WAY 4437 MITCHUM CT 8716 LONGSPUR WAY 1207 CRESCENDO DR 1675 VERNON ST Unit 8 318 ANACAPA DR 5712 MELBURY CIR 3318 DAVIDSON DR 7921 DOE TRAIL WAY 8020 WALERGA RD 7837 ABBINGTON WAY 140 VENTO CT 7641 ROSEHALL DR 448 ELMWOOD CT 4085 COUNTRY DR 8721 SPRUCE RIDGE WAY 4636 TEAL BAY CT 4508 OLD DAIRY DR 4008 GREY LIVERY WAY 633 HANISCH DR 9197 CORTINA CIR 7863 CRESTLEIGH CT 4741 PACIFIC PARK DR 5312 MARBURY WAY 3305 RIO ROCA CT 7895 CABER WAY 652 FIFTEEN MILE DR 5708 RIDGEPOINT DR 5308 MARBURY WAY 8108 FILIFERA WAY 8316 NORTHAM DR 4712 PISMO BEACH DR 308 ATKINSON ST 6709 ROSE BRIDGE DR 4509 WINJE DR 7901 GAZELLE TRAIL WAY 4240 WINJE DR 3228 BAGGAN CT 227 MAHAN CT Unit 1 7697 ROSEHALL DR 201 FIRESTONE DR 2981 WRINGER DR 3604 KODIAK WAY 8428 MISTY PASS WAY 37 WHITE BIRCH CT 167 VALLEY OAK DR 3930 ANNABELLE AVE 8636 LONGSPUR WAY 4844 CLYDEBANK WAY 1675 VERNON ST Unit 24 281 SPYGLASS HL 1975 SIDESADDLE WAY 3212 CORNICHE LN 506 BEDFORD CT 419 DAWNRIDGE RD 1407 TIFFANY CIR 1786 PIEDMONT WAY 624 HOVEY WAY 500 WINCHESTER CT
SELECT * FROM ( LOCATION='/s3/s3.amazonaws.com/testdeltalake/deltalakewp/_symlink_format_manifest' AUTHORIZATION=test1 MANIFEST='TRUE' TABLE_FORMAT='DELTALAKE') as dt;
Result:
*** Query completed. 61 rows found. 8 columns returned. *** Total elapsed time was 44 seconds. Location ---------------------------------------------------------------------------------------------------- /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00009-70377ec9-23db-4c9b-9c1f-50bf90a7 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00007-1ca7a971-5117-46b4-85b2-c7752bbd /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00006-917150c3-054a-4ac7-a4ea-0ba96b39 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00005-0d48136f-25b1-4ee7-b754-b6d47dab /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00009-70377ec9-23db-4c9b-9c1f-50bf90a7 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00007-1ca7a971-5117-46b4-85b2-c7752bbd /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00006-917150c3-054a-4ac7-a4ea-0ba96b39 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00005-0d48136f-25b1-4ee7-b754-b6d47dab /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00009-70377ec9-23db-4c9b-9c1f-50bf90a7 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00007-1ca7a971-5117-46b4-85b2-c7752bbd /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00006-917150c3-054a-4ac7-a4ea-0ba96b39 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00005-0d48136f-25b1-4ee7-b754-b6d47dab /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00009-70377ec9-23db-4c9b-9c1f-50bf90a7 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00007-1ca7a971-5117-46b4-85b2-c7752bbd /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00006-917150c3-054a-4ac7-a4ea-0ba96b39 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00005-0d48136f-25b1-4ee7-b754-b6d47dab /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00009-70377ec9-23db-4c9b-9c1f-50bf90a7 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00007-1ca7a971-5117-46b4-85b2-c7752bbd /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00006-917150c3-054a-4ac7-a4ea-0ba96b39 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00005-0d48136f-25b1-4ee7-b754-b6d47dab /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00004-66a61240-33fd-4fba-8bd1-5e536539 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00007-1ca7a971-5117-46b4-85b2-c7752bbd /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00006-917150c3-054a-4ac7-a4ea-0ba96b39 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00005-0d48136f-25b1-4ee7-b754-b6d47dab /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00004-66a61240-33fd-4fba-8bd1-5e536539 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00008-f6f1e0f6-5ccd-48ff-97f0-b2d427b5 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00003-e4c7c3cb-7aa0-4814-85e2-4683c1ce /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00005-0d48136f-25b1-4ee7-b754-b6d47dab /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00004-66a61240-33fd-4fba-8bd1-5e536539 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00008-f6f1e0f6-5ccd-48ff-97f0-b2d427b5 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00003-e4c7c3cb-7aa0-4814-85e2-4683c1ce /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00005-0d48136f-25b1-4ee7-b754-b6d47dab /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00004-66a61240-33fd-4fba-8bd1-5e536539 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00008-f6f1e0f6-5ccd-48ff-97f0-b2d427b5 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95661/part-00002-00c3c9b4-fc91-4762-8724-d1f7cdcd /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00002-83b8aad2-9d4a-4cef-ac9a-acb07340 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00004-66a61240-33fd-4fba-8bd1-5e536539 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00008-f6f1e0f6-5ccd-48ff-97f0-b2d427b5 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95661/part-00002-00c3c9b4-fc91-4762-8724-d1f7cdcd /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00002-83b8aad2-9d4a-4cef-ac9a-acb07340 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00004-66a61240-33fd-4fba-8bd1-5e536539 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00008-f6f1e0f6-5ccd-48ff-97f0-b2d427b5 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95661/part-00002-00c3c9b4-fc91-4762-8724-d1f7cdcd /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00002-83b8aad2-9d4a-4cef-ac9a-acb07340 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00004-66a61240-33fd-4fba-8bd1-5e536539 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00008-f6f1e0f6-5ccd-48ff-97f0-b2d427b5 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95661/part-00001-09b48cd3-5c6a-467a-a63a-134c752c /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00004-66a61240-33fd-4fba-8bd1-5e536539 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00000-a1f8f541-c0b2-44ad-bfef-447a3834 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95661/part-00001-09b48cd3-5c6a-467a-a63a-134c752c /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00001-79ff7696-ba19-48fc-bbb4-842fbe04 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00000-a1f8f541-c0b2-44ad-bfef-447a3834 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00001-79ff7696-ba19-48fc-bbb4-842fbe04 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00000-a1f8f541-c0b2-44ad-bfef-447a3834 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00001-79ff7696-ba19-48fc-bbb4-842fbe04 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00000-a1f8f541-c0b2-44ad-bfef-447a3834 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00001-79ff7696-ba19-48fc-bbb4-842fbe04 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00000-a1f8f541-c0b2-44ad-bfef-447a3834 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95661/part-00000-0ab15a43-e3b4-4832-8775-d3db4b96 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95661/part-00000-0ab15a43-e3b4-4832-8775-d3db4b96 /S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95661/part-00000-0ab15a43-e3b4-4832-8775-d3db4b96