set autocommit=on;

create external table clickstream.uservisits_csv10(
adRevenue float,
countryCode char(3),
custKey int4,
destURL varchar(100),
duration int4,
languageCode char(6),
searchWord varchar(32),
sourceIP varchar(116),
userAgent varchar(256),
visitDate int4,
yearmonthKey int4)
partitioned by(customer int4, visitYearMonth int4)
row format delimited
fields terminated by ','
stored as textfile
location 's3://redshift-spectrum-datastore-csv10/'
table properties ('numRows'='3758774345');

alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199201) location 's3://redshift-spectrum-datastore-csv10/52a17f02aa5675c8399b182d9351da5a79b0522ca1080270c15b1767031babf4/customer=1/visitYearMonth=199201/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199202) location 's3://redshift-spectrum-datastore-csv10/7271512b739525cc50d33984b11045164ca3517cd0ba468b9266be303a96eead/customer=1/visitYearMonth=199202/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199203) location 's3://redshift-spectrum-datastore-csv10/e8832887b1afdc1636720b8af9f25d3b548e0c8dc15bc5e40a398b338a0c2134/customer=1/visitYearMonth=199203/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199204) location 's3://redshift-spectrum-datastore-csv10/8ee66fb52ac875d81b88154297ce49ed7346c06c10532c2ed9ed42e5ce819e5c/customer=1/visitYearMonth=199204/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199205) location 's3://redshift-spectrum-datastore-csv10/2a0cafaab4ea6dbda7f9e9a3fd7aad3d78659aa404a1ac5a4b2180fb98099c9c/customer=1/visitYearMonth=199205/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199206) location 's3://redshift-spectrum-datastore-csv10/cebff1a64ed414ec0832f0504543f52d6caa9e260b3e2f3f1c1c0798038f29dc/customer=1/visitYearMonth=199206/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199207) location 's3://redshift-spectrum-datastore-csv10/b0edb7883d76e888be8df64bb487d477ac7b87ad1a77cebe5d7854decf7aaeb4/customer=1/visitYearMonth=199207/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199208) location 's3://redshift-spectrum-datastore-csv10/7a7963376a3ffc3d4d5fdea4ddb18d96f305e81a96a4b55ec7563af8e9331fb3/customer=1/visitYearMonth=199208/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199209) location 's3://redshift-spectrum-datastore-csv10/36805174fb2c3e72d88eff6c3350831ab46ecf4887dfacbfa30a54141f06c07b/customer=1/visitYearMonth=199209/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199210) location 's3://redshift-spectrum-datastore-csv10/eb0316ea28394dfa4c579a8d35128d835daa39312d7c3ff34119a3286e6712e8/customer=1/visitYearMonth=199210/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199211) location 's3://redshift-spectrum-datastore-csv10/17ecbde61c4ebed5b27ded91151fc3ca14468b492a7f0d5a6df9a0b942235391/customer=1/visitYearMonth=199211/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199212) location 's3://redshift-spectrum-datastore-csv10/e193194315743293ec7440bec9a7db73f75c6416b4d43661964cc0499dfdca40/customer=1/visitYearMonth=199212/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199301) location 's3://redshift-spectrum-datastore-csv10/c4e83f51c962193c6b59fadcd5c52dfe6ef3bf9f5d33b2fd31276aebd1fc8fe4/customer=1/visitYearMonth=199301/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199302) location 's3://redshift-spectrum-datastore-csv10/4d8fe9aafcdf3e96694ee893ff3d1c669ead8d8e93f7face0335d2144b7bfb33/customer=1/visitYearMonth=199302/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199303) location 's3://redshift-spectrum-datastore-csv10/9342294299ee9926a62e64d2777a5b3c59aefa9e845de04b85a22ce5222f5d63/customer=1/visitYearMonth=199303/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199304) location 's3://redshift-spectrum-datastore-csv10/7d8743184026620b4393c6389f57f48e4843721f35e8cdfa5872aef86020e884/customer=1/visitYearMonth=199304/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199305) location 's3://redshift-spectrum-datastore-csv10/460bc3640484d0af0b616dfcb54dce19ad3e55ba46108c69b4ca13725c9a03cc/customer=1/visitYearMonth=199305/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199306) location 's3://redshift-spectrum-datastore-csv10/837e75fdeba431b630942666c92792d67f7366844ee1037cba60ee25669ebfc9/customer=1/visitYearMonth=199306/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199307) location 's3://redshift-spectrum-datastore-csv10/ef9c408ceaa25d105892ca734dd89c7ad178a53cfc1e6a035ab3a75072b1efaf/customer=1/visitYearMonth=199307/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199308) location 's3://redshift-spectrum-datastore-csv10/efe51e683fa0a04c04d26bdf3f6941ed44ee1b9489c8740df381e66f75f11842/customer=1/visitYearMonth=199308/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199309) location 's3://redshift-spectrum-datastore-csv10/482d2108abddb8526fe9394883108e641bedd3ee924a3e119d231f5b7858e27f/customer=1/visitYearMonth=199309/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199310) location 's3://redshift-spectrum-datastore-csv10/89f1d4fe3903e767d96be772bb980514a757e5d6c337bcd96a6108ee4a535a34/customer=1/visitYearMonth=199310/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199311) location 's3://redshift-spectrum-datastore-csv10/06a671244ed8f7b5e352eb6a7a98aa9b03eeecc8ac9cbafb6f71112388206c47/customer=1/visitYearMonth=199311/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199312) location 's3://redshift-spectrum-datastore-csv10/92108327943b25eb2d76e11f039db47bca344f1d3b007e964f3316ab94c6b3a5/customer=1/visitYearMonth=199312/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199401) location 's3://redshift-spectrum-datastore-csv10/9008ad5d59f15fc68b1ee8d86ec7a95f642267e50739a6b3a99497bac93d4679/customer=1/visitYearMonth=199401/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199402) location 's3://redshift-spectrum-datastore-csv10/e69e82c3ababb53b3f96bd985d23e841ca64a9ef7e3b743dd0a2da2b38e66fa7/customer=1/visitYearMonth=199402/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199403) location 's3://redshift-spectrum-datastore-csv10/d3c8da452307957163d2325be51ade84f8d6888b5b433f7e48864e6f1755d61f/customer=1/visitYearMonth=199403/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199404) location 's3://redshift-spectrum-datastore-csv10/b32b6cb3b306ff895792fa595857d30d02934156df78b3f77e05624966a9163f/customer=1/visitYearMonth=199404/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199405) location 's3://redshift-spectrum-datastore-csv10/073c023fbf4ab0c72b7a5d4141df5a0334fe2caf0db55af43dd6ab801c6c0b2e/customer=1/visitYearMonth=199405/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199406) location 's3://redshift-spectrum-datastore-csv10/c5b1bad2380c572065a15626b9ff88b7e401dcc3fb8f2a9015d0e6aa2c50806d/customer=1/visitYearMonth=199406/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199407) location 's3://redshift-spectrum-datastore-csv10/f73888382a692c9b45fccba9385107ce85f6fdf7c4047283f941b5a49c75ef7d/customer=1/visitYearMonth=199407/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199408) location 's3://redshift-spectrum-datastore-csv10/0cfab0e2aacafe4dc263f55e8a7a5b127a14628a44d0c32fc3d4bb96cc732920/customer=1/visitYearMonth=199408/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199409) location 's3://redshift-spectrum-datastore-csv10/2194ae710cc7d4f72ac05e1053e2e096d7187bffb9d24b1e5ba046afd0283743/customer=1/visitYearMonth=199409/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199410) location 's3://redshift-spectrum-datastore-csv10/f88b6868a2f0cdc5f5a522cb52bf4f1e8f5678f0a34b2d15b1efee2bf97b0d6a/customer=1/visitYearMonth=199410/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199411) location 's3://redshift-spectrum-datastore-csv10/08636cdbd6065450ad1b24f6e3a10bee78cc2477337484b9bf55f7c18154b780/customer=1/visitYearMonth=199411/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199412) location 's3://redshift-spectrum-datastore-csv10/658706622865db2676fadb66c03608f988ca222eafb8111cb9b25247d9610ed8/customer=1/visitYearMonth=199412/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199501) location 's3://redshift-spectrum-datastore-csv10/3e68d4dd73baca2cbcd4d1527536443027844dc13cabe397f95e5c5dfd3f56a4/customer=1/visitYearMonth=199501/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199502) location 's3://redshift-spectrum-datastore-csv10/8c2c8b9f548bedb0429ffb5a0920900966fb4ce207d075a4a847cb8f450d3610/customer=1/visitYearMonth=199502/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199503) location 's3://redshift-spectrum-datastore-csv10/2ed508e0f02d7e88f2627f4ba823edeb02157a1599eaa9a0a5b29b61f3406e6f/customer=1/visitYearMonth=199503/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199504) location 's3://redshift-spectrum-datastore-csv10/fd0564ea9c335c51d9701cf4d7f0b6b4a39c5013f30eaf7e85e828a1b471cc87/customer=1/visitYearMonth=199504/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199505) location 's3://redshift-spectrum-datastore-csv10/9b6d719ebc6bb02e45cb4c5252425e4fdff4782d50e231394f33a6e31e26eddd/customer=1/visitYearMonth=199505/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199506) location 's3://redshift-spectrum-datastore-csv10/e783ed3ab0081fbccba3cf1873387deb597fd96fb5a7948a50a64bcdddb2bea5/customer=1/visitYearMonth=199506/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199507) location 's3://redshift-spectrum-datastore-csv10/2d4cf0ac3f5377846297e62af6007d772e4cbcc23c0a36c59bb046316f037256/customer=1/visitYearMonth=199507/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199508) location 's3://redshift-spectrum-datastore-csv10/0c272eb5a7d3c06202d44601f8f96c67bce1c28f1f7c20f94104738e025e7cce/customer=1/visitYearMonth=199508/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199509) location 's3://redshift-spectrum-datastore-csv10/0a36f87a508cb38eb1e2ff124e2a6f79043b49eebeddff192ed343cc2b913eff/customer=1/visitYearMonth=199509/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199510) location 's3://redshift-spectrum-datastore-csv10/4fef50d293c87117b299c2a81a562f737181fc0a4644c5d249bb1ccbd8e844c1/customer=1/visitYearMonth=199510/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199511) location 's3://redshift-spectrum-datastore-csv10/9e2cdb43e61cd1dd278c34ef6c238ec6db311ba283b914058b1ead5bfbcee00b/customer=1/visitYearMonth=199511/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199512) location 's3://redshift-spectrum-datastore-csv10/2b6a23c6ce622f163aa030850467263a01018f4452e9f757dfb742ec4c6a6f0b/customer=1/visitYearMonth=199512/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199601) location 's3://redshift-spectrum-datastore-csv10/a0dde793dcb4d3cbbd13bfba4239765126d42ea2d1a72c40208954b565ba9748/customer=1/visitYearMonth=199601/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199602) location 's3://redshift-spectrum-datastore-csv10/c99483d1e0b862edcc53121243bcc275edacd4368f73028b6f90b415b592b8f2/customer=1/visitYearMonth=199602/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199603) location 's3://redshift-spectrum-datastore-csv10/a32c875f4072ade2c2d86154d88c88f14abe135ec1a340effe8c28c93109e198/customer=1/visitYearMonth=199603/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199604) location 's3://redshift-spectrum-datastore-csv10/f0b27ff9ce1a45be229587873910f344b919bd99f2f948274ace874e2330532c/customer=1/visitYearMonth=199604/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199605) location 's3://redshift-spectrum-datastore-csv10/ffbad828915d1622e688b1543a720682219c414af4094dcd22f56f0dec65079f/customer=1/visitYearMonth=199605/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199606) location 's3://redshift-spectrum-datastore-csv10/8f00f5546120c4a1a1e2555ff72483c570eb8777dc080c3e19d782780f329916/customer=1/visitYearMonth=199606/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199607) location 's3://redshift-spectrum-datastore-csv10/898eaf28e7af6ed5280723483c99610c8b3f2e539b91afb4a2eb5fcd5bc99938/customer=1/visitYearMonth=199607/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199608) location 's3://redshift-spectrum-datastore-csv10/43400356fd365caa2251253ecf66290a3a2f06011ef9c51a619cb574730020e5/customer=1/visitYearMonth=199608/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199609) location 's3://redshift-spectrum-datastore-csv10/a0bb1633eba819e20b9b48788c0b8c6323bc14df68b8c2d32a89d8e52810564d/customer=1/visitYearMonth=199609/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199610) location 's3://redshift-spectrum-datastore-csv10/e4e56785466e819fa9a228cb778e2d26f595fe6ff9753e14b0f478a339bc93ae/customer=1/visitYearMonth=199610/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199611) location 's3://redshift-spectrum-datastore-csv10/e7aa5a60baf71131ed41d4b8025c0d8b08d5ea3d3937b3b1a92b1846b9634be4/customer=1/visitYearMonth=199611/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199612) location 's3://redshift-spectrum-datastore-csv10/aa7a495bc39da736cd6e4fe714c18f9fb9d3f0bd793dc05369a00dfa057a7385/customer=1/visitYearMonth=199612/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199701) location 's3://redshift-spectrum-datastore-csv10/ad5d7c14a9041aa252869c299388f51888c0f1a17712886c9a00a6df1c6eeaf6/customer=1/visitYearMonth=199701/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199702) location 's3://redshift-spectrum-datastore-csv10/561bd70579b077525c2eb0758af9a686d94b4080e66f6a998415b7160d303b42/customer=1/visitYearMonth=199702/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199703) location 's3://redshift-spectrum-datastore-csv10/eaf792b1442899f39a77b896900651d9157792ab58804177825af44e9938c72f/customer=1/visitYearMonth=199703/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199704) location 's3://redshift-spectrum-datastore-csv10/b215e47858ce769f935c9b4e87d7386692580f975892960aa3e67a823bd00543/customer=1/visitYearMonth=199704/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199705) location 's3://redshift-spectrum-datastore-csv10/b477d4067302cccedeee76186447690770b1bd561b061383d014eeeaa1feb239/customer=1/visitYearMonth=199705/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199706) location 's3://redshift-spectrum-datastore-csv10/b9403a2547b1dba0aab1e7668b84210f724db7f3982299db7b4470a19d5b18ff/customer=1/visitYearMonth=199706/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199707) location 's3://redshift-spectrum-datastore-csv10/a9093afd0197c1ec10e41ac3e9a1cc3f9a40c4a926294f9e88c2af71b2fa944a/customer=1/visitYearMonth=199707/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199708) location 's3://redshift-spectrum-datastore-csv10/6e50ef2b0e5ba217d99318ffbf1ebbed1e6ba519dac5e53336a679722f7b25ce/customer=1/visitYearMonth=199708/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199709) location 's3://redshift-spectrum-datastore-csv10/e63f322dfa09bbe65cd8e369c06d29c54e8993df94181c7194db1b9fff0fa497/customer=1/visitYearMonth=199709/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199710) location 's3://redshift-spectrum-datastore-csv10/b78fe598cc5e45d9a49a9a382c8d2642e6de8d4f9fad9e79a30a851683140393/customer=1/visitYearMonth=199710/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199711) location 's3://redshift-spectrum-datastore-csv10/7c9408fb0e9e6fb21820096b79c7453a5dcfa68d8974111349c2fac7130e18bc/customer=1/visitYearMonth=199711/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199712) location 's3://redshift-spectrum-datastore-csv10/d22c46f4c52a42ea523034da99e73ea80360ee1dae90bdba500427858e3a7dde/customer=1/visitYearMonth=199712/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199801) location 's3://redshift-spectrum-datastore-csv10/f6de06ac1aebe31a87d52fc8558060db4595315f2416a66fa517d7ac6b919a4b/customer=1/visitYearMonth=199801/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199802) location 's3://redshift-spectrum-datastore-csv10/f0f787c836497c54ec0f8cf9e692ef0d43ddb8f8dee4f3e34653f0259fbc1cbe/customer=1/visitYearMonth=199802/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199803) location 's3://redshift-spectrum-datastore-csv10/b070d5a343b5e2394c66ecc4c8ecec78004a8e3c37e453865e8d0be8f21041a8/customer=1/visitYearMonth=199803/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199804) location 's3://redshift-spectrum-datastore-csv10/deba42cf4525b09c5b4f841513942e9ea9e2a116c96f76bb7f4324d27921085a/customer=1/visitYearMonth=199804/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199805) location 's3://redshift-spectrum-datastore-csv10/8877a6d8d191f103d771230fbfc53c5f556eea7da25550970d67d7bfee421cf1/customer=1/visitYearMonth=199805/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199806) location 's3://redshift-spectrum-datastore-csv10/4ae1a2fb2424769191c13384c5e7c9c7547e74284aa50133aa750fde1ce0d057/customer=1/visitYearMonth=199806/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199807) location 's3://redshift-spectrum-datastore-csv10/252061309de77bab30eec91c559671cb89602c55fddac01f939395da6cb22b74/customer=1/visitYearMonth=199807/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199808) location 's3://redshift-spectrum-datastore-csv10/c0543e9ad0f08b1570497ddea0206f9e01bdfc371aaf53ccd865b646877d4421/customer=1/visitYearMonth=199808/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199809) location 's3://redshift-spectrum-datastore-csv10/5dfeb2f8a4f6c2e002763dbad237aa01665efd6fcb2123dc326156d599de12f6/customer=1/visitYearMonth=199809/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199810) location 's3://redshift-spectrum-datastore-csv10/14e96a9d68fd2f0216e02e5e2ca220337f21b563f82519ad22110527829f2f21/customer=1/visitYearMonth=199810/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199811) location 's3://redshift-spectrum-datastore-csv10/24f0efccf9c15245f9728159f801443b807dcedd098e21db938d24c413743393/customer=1/visitYearMonth=199811/';
alter table clickstream.uservisits_csv10 add partition(customer=1, visitYearMonth=199812) location 's3://redshift-spectrum-datastore-csv10/c97a582fa51f360281e1817a15b31ad3c504d6888c941fef05caa8e145616233/customer=1/visitYearMonth=199812/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199201) location 's3://redshift-spectrum-datastore-csv10/b4f5319b8a7027a7194635643ef297e7abac18c0e84d17a01fade3c652848ac9/customer=2/visitYearMonth=199201/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199202) location 's3://redshift-spectrum-datastore-csv10/681b24a373373d8703788158a965389010b0fc9d253ff3288d85a59a7b9d9bdb/customer=2/visitYearMonth=199202/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199203) location 's3://redshift-spectrum-datastore-csv10/208ed265a28efb6342723307e9bf662f7621f49c20d8f79e500dac025e474dc3/customer=2/visitYearMonth=199203/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199204) location 's3://redshift-spectrum-datastore-csv10/f82c771d628b25eb361b3f73790b6e822b43e9a472b6f8504c5e8d34edf390a7/customer=2/visitYearMonth=199204/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199205) location 's3://redshift-spectrum-datastore-csv10/8dd40b7a73a2c409be19feab2f3ce586c6e6f4570bbfdfeaf4ce111d7e20a927/customer=2/visitYearMonth=199205/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199206) location 's3://redshift-spectrum-datastore-csv10/8f5f1c183255b828a067e55a7cd07dab68cb68d1b81488817578d000a39519a0/customer=2/visitYearMonth=199206/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199207) location 's3://redshift-spectrum-datastore-csv10/388c5938dd706aed154c2a7f88f235317e30b1427ba876a175600fbadef46e35/customer=2/visitYearMonth=199207/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199208) location 's3://redshift-spectrum-datastore-csv10/595600141b503d727e4ea6b9fc05e66f47ef16c26d9dc95509137754459631fe/customer=2/visitYearMonth=199208/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199209) location 's3://redshift-spectrum-datastore-csv10/bd7816a831724c32623433a2fa5eb58d37a7dafd8d9b518ee0c787fac9f9cd03/customer=2/visitYearMonth=199209/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199210) location 's3://redshift-spectrum-datastore-csv10/dc8b7acd01fbed890cca2f9e5b7bd313d29affef0f075ad96c049af83e4681c6/customer=2/visitYearMonth=199210/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199211) location 's3://redshift-spectrum-datastore-csv10/87660e1d442c6b91943ebb15de05c186aaf58f9d9d1336ae24b643ac3e798a23/customer=2/visitYearMonth=199211/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199212) location 's3://redshift-spectrum-datastore-csv10/0ef1cbd15bb986179709c1fe7117606abfbdcd6477b2744bbb1386e6b7cb3503/customer=2/visitYearMonth=199212/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199301) location 's3://redshift-spectrum-datastore-csv10/e75837818e7f92c004cb9d63724ef78f92409daa5b27b64fc764961760ae8161/customer=2/visitYearMonth=199301/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199302) location 's3://redshift-spectrum-datastore-csv10/ba0d21e91823da522b654a347c758993761d55aea9897dfb148cb76eb6ee4991/customer=2/visitYearMonth=199302/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199303) location 's3://redshift-spectrum-datastore-csv10/6df31488e2a6ec71c75caacdd48dfc26fb04d1e1fffbb74b939d5f1ccfa8277f/customer=2/visitYearMonth=199303/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199304) location 's3://redshift-spectrum-datastore-csv10/d10f49d1cf558495e16c9e5f65e9207bf1b33abc177ffd747a93185c412a0b87/customer=2/visitYearMonth=199304/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199305) location 's3://redshift-spectrum-datastore-csv10/47dfcd24c1524a5932fe3398473c96eb67f6fbfd58e5e49133edd76796b9fd61/customer=2/visitYearMonth=199305/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199306) location 's3://redshift-spectrum-datastore-csv10/4f41a88896d92666ead7d16312df1ae418b3454932f2320f6fb367e935bfca90/customer=2/visitYearMonth=199306/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199307) location 's3://redshift-spectrum-datastore-csv10/6a798cc196cff6ae65a6f53579392286e471480b7fe14db38ee4a77dbe3f4537/customer=2/visitYearMonth=199307/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199308) location 's3://redshift-spectrum-datastore-csv10/f90773803f0392924b8978c3d80f5dc5915485f6540fd70d6e2cd2d8ec8b491a/customer=2/visitYearMonth=199308/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199309) location 's3://redshift-spectrum-datastore-csv10/01756f027b75b2b2e0f257d67b7b2edf1274d5959be18772c07ad7e85f238ca2/customer=2/visitYearMonth=199309/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199310) location 's3://redshift-spectrum-datastore-csv10/ea73ad2db14ba1c6cdb7f537f35bcbc4f5a783d27bb605ecd1a4456ea066fbaa/customer=2/visitYearMonth=199310/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199311) location 's3://redshift-spectrum-datastore-csv10/73e9ce2542a81d6c5e563cbe665bf892d38291f9ba8fa54d3793d1daf32d35b3/customer=2/visitYearMonth=199311/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199312) location 's3://redshift-spectrum-datastore-csv10/7e731a9d5f07341b3cd97e1ac5a547d3e1646f9c7643872de650e9a460cf0eb0/customer=2/visitYearMonth=199312/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199401) location 's3://redshift-spectrum-datastore-csv10/0c99e463f8917bfced1b1dd50b1dc3950cbede5ec8f20d714f053c21d7135604/customer=2/visitYearMonth=199401/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199402) location 's3://redshift-spectrum-datastore-csv10/193c6307332ab1b9fcc1fdd85e5ca41bab4153687da30bb3e71b2b8407d40274/customer=2/visitYearMonth=199402/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199403) location 's3://redshift-spectrum-datastore-csv10/92a8300991251d0247ab2784a81450357b3d62559c4fc65f49d34d4f2854965a/customer=2/visitYearMonth=199403/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199404) location 's3://redshift-spectrum-datastore-csv10/c8649480968453fc9f246a5aa8a118eaf9b88c59f2abe3b0e6901409f71491dc/customer=2/visitYearMonth=199404/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199405) location 's3://redshift-spectrum-datastore-csv10/ca9572e9c9467d1229ad6eeb65b8a2fd102a75a7d016476f9be6a99fa2cee193/customer=2/visitYearMonth=199405/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199406) location 's3://redshift-spectrum-datastore-csv10/a2b84cca0a892addb7fef36b04559216504c942110db6c6d68aa5ba8d4d8378b/customer=2/visitYearMonth=199406/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199407) location 's3://redshift-spectrum-datastore-csv10/0e4fa211a0433dfa4d3defa9583bf678cf81613728a1d1d869f46bb7da45e6fc/customer=2/visitYearMonth=199407/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199408) location 's3://redshift-spectrum-datastore-csv10/67003e802fdf995675a8dec1db12002e82bd044f8315a3437cf5d35ead572c58/customer=2/visitYearMonth=199408/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199409) location 's3://redshift-spectrum-datastore-csv10/733488455f7594fa8b0e30a9aae34f39a031a7412310bb92f90fe34a01673d1a/customer=2/visitYearMonth=199409/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199410) location 's3://redshift-spectrum-datastore-csv10/26feb3240949cff6fd774abac53e8b4df5b95fb1cb9cce654e935277c2b4f703/customer=2/visitYearMonth=199410/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199411) location 's3://redshift-spectrum-datastore-csv10/418115465eff64c9c92e09ecf665559baf6692836c76cbd75a5a586c78bd2031/customer=2/visitYearMonth=199411/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199412) location 's3://redshift-spectrum-datastore-csv10/65ab05830f1cac701ed76733132c52a09accb6f1e2ad4cfc3eaa112943b87316/customer=2/visitYearMonth=199412/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199501) location 's3://redshift-spectrum-datastore-csv10/0ead0b47d4d02e0af9e10885c3dad1a6d6d06e840b2c4d23cb125a99084c79c2/customer=2/visitYearMonth=199501/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199502) location 's3://redshift-spectrum-datastore-csv10/e0d0db85e1b20313c6586ae13f584988e1922cbae63a712e811b6dd6aee5290f/customer=2/visitYearMonth=199502/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199503) location 's3://redshift-spectrum-datastore-csv10/537c4e51d949c6d8652450009ed310a759cca0ba2a84338228267aeb509147ea/customer=2/visitYearMonth=199503/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199504) location 's3://redshift-spectrum-datastore-csv10/6d272ff17fc53b79b69d8a363712066c7cc152068836a806374d510156b772b8/customer=2/visitYearMonth=199504/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199505) location 's3://redshift-spectrum-datastore-csv10/ae4a67e6206cc15b4e278ec967755757dd3ec945328f7600a8faef1e7e35c477/customer=2/visitYearMonth=199505/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199506) location 's3://redshift-spectrum-datastore-csv10/9023e6d29ef302382721a1491d8061690736e86e763f17e82a7facb0c46f1757/customer=2/visitYearMonth=199506/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199507) location 's3://redshift-spectrum-datastore-csv10/2fc196199f489843d882de71580ac411fe59a9c4e316e88a62a61dbe06d4bc10/customer=2/visitYearMonth=199507/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199508) location 's3://redshift-spectrum-datastore-csv10/c5d5f279629ee93ff412ed729509d8cd2da1f7fc96ee15f665f17bef632b3b71/customer=2/visitYearMonth=199508/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199509) location 's3://redshift-spectrum-datastore-csv10/542cd0c3fc39092d2537ca41e1d0ed9b7e553ef893399a5429d2fd8e05c5115a/customer=2/visitYearMonth=199509/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199510) location 's3://redshift-spectrum-datastore-csv10/9de1fac94ca398929cf74a0bd3c6bb89172cad4cdc3bcbb96c4df4529f5e280d/customer=2/visitYearMonth=199510/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199511) location 's3://redshift-spectrum-datastore-csv10/373bfd41dccce92d09e81cc571a5fe70e7ddd961104af1b17b446b7b2f0bb19a/customer=2/visitYearMonth=199511/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199512) location 's3://redshift-spectrum-datastore-csv10/8be1a96b1865c6c4de6c6bea5279bf06ac3337a0817342ec0ddf2974bb124e7a/customer=2/visitYearMonth=199512/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199601) location 's3://redshift-spectrum-datastore-csv10/a7bb6d5e0f9e72f4b11c55ec4d34b9c4f9e1c5568cc2c0aae94aabf58f34c31f/customer=2/visitYearMonth=199601/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199602) location 's3://redshift-spectrum-datastore-csv10/7316097e5a6ecf05f39d3ea403b4fd2a88b642f44ff25617b66fa3efd041acd1/customer=2/visitYearMonth=199602/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199603) location 's3://redshift-spectrum-datastore-csv10/face4f6c89196a4969aea38efa808e92b301864cba78ae7f77a5c5d6a7d18b4d/customer=2/visitYearMonth=199603/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199604) location 's3://redshift-spectrum-datastore-csv10/8e444bebfdef28fad9d1a15cc2f98c98c7d0ad94e7937d99eee39d6b9942bc03/customer=2/visitYearMonth=199604/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199605) location 's3://redshift-spectrum-datastore-csv10/d59e27e4193d2cecd8f7f74486a242166808118ac958408cc866e533f2dd13f8/customer=2/visitYearMonth=199605/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199606) location 's3://redshift-spectrum-datastore-csv10/400d880316f0e2b9f9c9d03c59ba0e0e5b3e2ab7c2c911c683e4c8c2e82ae494/customer=2/visitYearMonth=199606/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199607) location 's3://redshift-spectrum-datastore-csv10/e6e3b8a2b1fad07f152bfefc47eac71a8260b0fb7a2088f10e598f1acd7e8f6a/customer=2/visitYearMonth=199607/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199608) location 's3://redshift-spectrum-datastore-csv10/5771adaf92660d9ceee9068d62a81447adcb1801212e294989401a4ed80d5245/customer=2/visitYearMonth=199608/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199609) location 's3://redshift-spectrum-datastore-csv10/305617c44ac8f636478b90406bcdcbceff928aa82350c978f634ce9ae1a05955/customer=2/visitYearMonth=199609/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199610) location 's3://redshift-spectrum-datastore-csv10/abb86f8195f2ed7b797d053ff05b3e950bae6ac9d9ca0a62fd152cda44c39d79/customer=2/visitYearMonth=199610/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199611) location 's3://redshift-spectrum-datastore-csv10/b97cfb1497ad7fc58d2cbd9fb0044ce18cdf436faaea5bd09dd76e2d286864af/customer=2/visitYearMonth=199611/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199612) location 's3://redshift-spectrum-datastore-csv10/3c5bf7b44f40d168d509239b24a210bd6231bbdb66186667f61e7669faa216f1/customer=2/visitYearMonth=199612/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199701) location 's3://redshift-spectrum-datastore-csv10/045685b7de093a3f2340159d579b4b9b309fe2751f66e0cafecebcac3e5b040e/customer=2/visitYearMonth=199701/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199702) location 's3://redshift-spectrum-datastore-csv10/1b872c630bae67fbc3e3fa7120285d23314cc28355ce894075a28f6bbcd9b8c9/customer=2/visitYearMonth=199702/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199703) location 's3://redshift-spectrum-datastore-csv10/e46eb11aaa0fb2ff9c8e02b9fde215bee3e58e2452c16604ee3422f5b2e26aac/customer=2/visitYearMonth=199703/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199704) location 's3://redshift-spectrum-datastore-csv10/8cff8a212bb535ea437f61e10c4e22f8f197ce2841005b435bbb3a96d58a65cf/customer=2/visitYearMonth=199704/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199705) location 's3://redshift-spectrum-datastore-csv10/35d0432e3413452c974f3186fb46437cbd9ff4c53c81181f3082771321db9de4/customer=2/visitYearMonth=199705/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199706) location 's3://redshift-spectrum-datastore-csv10/df840f4ce8d2e38a383ffeef4b53c0979dc37bfdf9f8328ef54a3cd9b21898da/customer=2/visitYearMonth=199706/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199707) location 's3://redshift-spectrum-datastore-csv10/3e1c1ead2eeae4f6f7b0e1f3dfcbb9938eb7284b7885d9934995b5b8bdc21f15/customer=2/visitYearMonth=199707/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199708) location 's3://redshift-spectrum-datastore-csv10/017c44ddf7ba4ed952651a139df0e6c82cc6e9e5f7eb3901dd6281941f3905e1/customer=2/visitYearMonth=199708/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199709) location 's3://redshift-spectrum-datastore-csv10/9ff92674a912398267807bcb78d982f2f8cc3893f312c299b23a1b2d1b3ff8e6/customer=2/visitYearMonth=199709/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199710) location 's3://redshift-spectrum-datastore-csv10/161aa488bb4a6a87af69916375b4ca65bbeda51b46a535f9643ee0cde2f903fc/customer=2/visitYearMonth=199710/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199711) location 's3://redshift-spectrum-datastore-csv10/c0e020779d5c3a9814b93c1fd397bc62b25769973fd7886a70998690a60436bc/customer=2/visitYearMonth=199711/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199712) location 's3://redshift-spectrum-datastore-csv10/a3a1f3747c450c96ddd39eb8773de0af7f79c749366285ae5727b19e62eec949/customer=2/visitYearMonth=199712/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199801) location 's3://redshift-spectrum-datastore-csv10/c9d689745f1fe9c4c1452532c08ee7a440373caa0d86fbd4d6a5176a8ec80602/customer=2/visitYearMonth=199801/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199802) location 's3://redshift-spectrum-datastore-csv10/f0f2f8102dbfa4e72d156306817064f3bb508fa9551907fff89be38c5726511c/customer=2/visitYearMonth=199802/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199803) location 's3://redshift-spectrum-datastore-csv10/79abca690d8ebfa8cd072b629f6c01652871c237863ccf4b63336283c3828feb/customer=2/visitYearMonth=199803/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199804) location 's3://redshift-spectrum-datastore-csv10/d0be85584f59e0c70ada0be65b20c5df09ef58d4132f359474bda36e515280f7/customer=2/visitYearMonth=199804/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199805) location 's3://redshift-spectrum-datastore-csv10/0cb37231ed3da847aeba46a81af4dc5fd4dfcbd3e88b619e27bf57498fbd7857/customer=2/visitYearMonth=199805/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199806) location 's3://redshift-spectrum-datastore-csv10/8d06c32a60a077ff8cfa5cc7abcf7819f148a1cb8ef16718dfbb290190b05e2c/customer=2/visitYearMonth=199806/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199807) location 's3://redshift-spectrum-datastore-csv10/515becf2ca66c86f4ed13984a3900fd6d8514330c587bc5967a629485edab99c/customer=2/visitYearMonth=199807/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199808) location 's3://redshift-spectrum-datastore-csv10/e21a06b90cdcb5e6d0ef341d729d76557c4f9dd465a7cf47485d349b83dcc35f/customer=2/visitYearMonth=199808/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199809) location 's3://redshift-spectrum-datastore-csv10/a4ee8bc3d08606ab6041fc08ec4ebdfbd6001ad372d8a1b8273d381ba287ca6d/customer=2/visitYearMonth=199809/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199810) location 's3://redshift-spectrum-datastore-csv10/711c5f5b62de19a8e6afc40ae3a0d088860002d7e933aa901df5f064ae6236e6/customer=2/visitYearMonth=199810/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199811) location 's3://redshift-spectrum-datastore-csv10/691a2f2e6f552124c37431b46708e420b262c77e8701c2b7f64bbddac20e2cbb/customer=2/visitYearMonth=199811/';
alter table clickstream.uservisits_csv10 add partition(customer=2, visitYearMonth=199812) location 's3://redshift-spectrum-datastore-csv10/2da01c88541a114f2ba61c36468396e87b77f520d202073b092adc2c3424eb4c/customer=2/visitYearMonth=199812/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199201) location 's3://redshift-spectrum-datastore-csv10/34ccfadb9cbe2e13ab43e320254cff88d611f95ed16e58517c5e04878428cc03/customer=3/visitYearMonth=199201/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199202) location 's3://redshift-spectrum-datastore-csv10/6e372f60c84fbef1c75e6a750beeb92dce3050f0b9e0a078ef62a2f1dc9d50bc/customer=3/visitYearMonth=199202/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199203) location 's3://redshift-spectrum-datastore-csv10/c9c7092dd9a485ffddab8273363bb0eb22d79d3068e599349286665aa9db6821/customer=3/visitYearMonth=199203/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199204) location 's3://redshift-spectrum-datastore-csv10/c8f5aed17745c057c45ab274f51acf7e1b7a7ff908dff4bb26db71426514d984/customer=3/visitYearMonth=199204/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199205) location 's3://redshift-spectrum-datastore-csv10/dadbe8c7c6482bf7fc68d05286078d16be85090f74fde731f92a7c06236c9a6d/customer=3/visitYearMonth=199205/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199206) location 's3://redshift-spectrum-datastore-csv10/1cfa2928ec2a9fbbc6eb49bbc64df14f7921f59a05cba93c67d3fceef8df4ef2/customer=3/visitYearMonth=199206/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199207) location 's3://redshift-spectrum-datastore-csv10/64a19b81c00a1646e660fa3b28aa153b8d09cd8b8dac8b51bf3a2ffa307ea535/customer=3/visitYearMonth=199207/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199208) location 's3://redshift-spectrum-datastore-csv10/47bb2d93d78fd01f1da3bee9c5518b8aa5118da90d374331cad2707ee5eeb0e9/customer=3/visitYearMonth=199208/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199209) location 's3://redshift-spectrum-datastore-csv10/60434efde212c21cd6bb1d0018b963051a47378384e14006965f4c0cd1e6841a/customer=3/visitYearMonth=199209/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199210) location 's3://redshift-spectrum-datastore-csv10/698318f88fe9eaabed96e889438d06fda25cd0151acf5f8ddec6ff62696c9579/customer=3/visitYearMonth=199210/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199211) location 's3://redshift-spectrum-datastore-csv10/6a53fdb34194f3cc09ecbb8b6496aa25b47859dc1ebf5253e745d893ea5a65ae/customer=3/visitYearMonth=199211/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199212) location 's3://redshift-spectrum-datastore-csv10/dac9846a012ea2063b83ab62352db24eb5b5b849321e3abd93247024c30f3525/customer=3/visitYearMonth=199212/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199301) location 's3://redshift-spectrum-datastore-csv10/b8a40a4dd3bb65e81c6b128ff8e07491ee5869227d696aad2da316faeeb5be91/customer=3/visitYearMonth=199301/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199302) location 's3://redshift-spectrum-datastore-csv10/a49751ca3c2d26228dd558268e27bc4053a8c47dd513413bbd75382c4587d994/customer=3/visitYearMonth=199302/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199303) location 's3://redshift-spectrum-datastore-csv10/38f7327497e945445b12caa226eb2f2d207dcfcc3b1d9e1a5f62c54adfec08af/customer=3/visitYearMonth=199303/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199304) location 's3://redshift-spectrum-datastore-csv10/a94674aac3ec456718496782329b30e072d9b716ab8b4257b444ae965c58c22f/customer=3/visitYearMonth=199304/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199305) location 's3://redshift-spectrum-datastore-csv10/583c123649f796514bc25906df3ac8b3930fcbea57b11c83d6a784bfef26e92f/customer=3/visitYearMonth=199305/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199306) location 's3://redshift-spectrum-datastore-csv10/970e81796fce8f7cd2af6389e0f152ecdacd2e36ed5a1f265a093f022a1f3eed/customer=3/visitYearMonth=199306/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199307) location 's3://redshift-spectrum-datastore-csv10/4ab0f83e7d0930d737af162ced369524eb3cea5e7623385e089df17c21714aac/customer=3/visitYearMonth=199307/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199308) location 's3://redshift-spectrum-datastore-csv10/ddd7a00a49834458811b86864012dabb23917a74a04897ce93e451ae4d37738f/customer=3/visitYearMonth=199308/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199309) location 's3://redshift-spectrum-datastore-csv10/dd47486fd7d15db4f7c849b4bf04bcfcf0db4c9ea5e1ac5646c9777b40a214dc/customer=3/visitYearMonth=199309/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199310) location 's3://redshift-spectrum-datastore-csv10/1ed57f4ebb6b19cd543225509452b5d884a9cddd04e65eeabc6ca78e3a74ae50/customer=3/visitYearMonth=199310/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199311) location 's3://redshift-spectrum-datastore-csv10/a23591f0f0c8d7f19ee50089adc818793eab25ec4c6d48a0b8d05daf543fddd8/customer=3/visitYearMonth=199311/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199312) location 's3://redshift-spectrum-datastore-csv10/64f7a76141ec5f9c3c5eca165dd66f89f51e86682ec420dc50fcf40e67f00e45/customer=3/visitYearMonth=199312/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199401) location 's3://redshift-spectrum-datastore-csv10/bd6675fe0ad043f759e65f0db06af0d2f97963acc8c8d0a4e0911da0f1fa4094/customer=3/visitYearMonth=199401/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199402) location 's3://redshift-spectrum-datastore-csv10/66d2c1fdeee38aff633c05d3cffaa0f74d3678592501d76a04c0efbecb03ff56/customer=3/visitYearMonth=199402/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199403) location 's3://redshift-spectrum-datastore-csv10/d23177085d50e074f9fa44ed1ec425fffba18653b4cf5fdc7c9d9c150d235046/customer=3/visitYearMonth=199403/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199404) location 's3://redshift-spectrum-datastore-csv10/fa11ff07beacd3a28f4ec2ffdd17245c81c5682fe395da52ea5b8ff0aebeadca/customer=3/visitYearMonth=199404/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199405) location 's3://redshift-spectrum-datastore-csv10/afb8e60909553ab75518b2102a6a34e8fcd56be1c0b0efb2526817c34a61adfd/customer=3/visitYearMonth=199405/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199406) location 's3://redshift-spectrum-datastore-csv10/739ce84fb1944fd631c2b9d33c64fb7bc3741022b98f4707f4c686e01e957fbe/customer=3/visitYearMonth=199406/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199407) location 's3://redshift-spectrum-datastore-csv10/63eec8f19f764ddbd7253d8e55e95ef3ef0160a77d86aa369fe115db985a462b/customer=3/visitYearMonth=199407/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199408) location 's3://redshift-spectrum-datastore-csv10/fd784d55967d527cd7feae56609ba2b98b8e118b22f07fb91e52d3aaa3a1849a/customer=3/visitYearMonth=199408/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199409) location 's3://redshift-spectrum-datastore-csv10/56924eb14e109d8c08a749a48c41d6c50d2d9cf8e1ce9723bdaea4c76f485a32/customer=3/visitYearMonth=199409/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199410) location 's3://redshift-spectrum-datastore-csv10/f7c760fb8a635b9b64bd924721c2a73ecff34a9b4ecd2fb9ff4d58d6599e70b9/customer=3/visitYearMonth=199410/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199411) location 's3://redshift-spectrum-datastore-csv10/2ff46dc0c50d290ba4992d9e5b8c9ce769371d198df473d0e41cbc1ff3c4b253/customer=3/visitYearMonth=199411/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199412) location 's3://redshift-spectrum-datastore-csv10/ed47a807d15ef415be852cde49e04f2d29f2a93e0a8ba6197791d28043ccf9e7/customer=3/visitYearMonth=199412/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199501) location 's3://redshift-spectrum-datastore-csv10/3139a31f40fc709757f6502086ddc880092bb66da917e133c4f40373984e103f/customer=3/visitYearMonth=199501/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199502) location 's3://redshift-spectrum-datastore-csv10/b868937bd48ccd7f6f2a25d92e4f6ab385c64111ed57b27e51a7648089a2af5c/customer=3/visitYearMonth=199502/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199503) location 's3://redshift-spectrum-datastore-csv10/a3152ff252fc5280342501f904c2554b704dc12ee4a27f0aef92d6620a41f8a9/customer=3/visitYearMonth=199503/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199504) location 's3://redshift-spectrum-datastore-csv10/0047d8896508fc5e1258d5a2abed450ced1c56fbe3be1faa17c58a1a7e69b4b3/customer=3/visitYearMonth=199504/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199505) location 's3://redshift-spectrum-datastore-csv10/4686a6730b1bc0df96ec0c4b7046a7aae808f1cc3ccfd8c70f0627cccbb69ea0/customer=3/visitYearMonth=199505/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199506) location 's3://redshift-spectrum-datastore-csv10/2bcdb123fc212b7c63aa06f6e832279bb1a2ec4d22ab56b484cf966c29a1e9de/customer=3/visitYearMonth=199506/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199507) location 's3://redshift-spectrum-datastore-csv10/51f3aa90de232277fb8b588172fe451575fefc05eba50f00203fc0ed8b4e73a6/customer=3/visitYearMonth=199507/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199508) location 's3://redshift-spectrum-datastore-csv10/6a4364678f79fe2cdc29b733a6ea0cb034c496990096873b1a1517273c46f692/customer=3/visitYearMonth=199508/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199509) location 's3://redshift-spectrum-datastore-csv10/97f8a02331bfb8781c4027eb78d9685f73ec40f6164e0338ddd51372801f244f/customer=3/visitYearMonth=199509/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199510) location 's3://redshift-spectrum-datastore-csv10/e440d2f5f3ce796f9e445a932cbde43049ec3e570bcb0138756ae614e1c3f792/customer=3/visitYearMonth=199510/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199511) location 's3://redshift-spectrum-datastore-csv10/5fb28f7cfcd9ef8a96205753a75773db764a087e22e12fc5d79ae3b9a24160b4/customer=3/visitYearMonth=199511/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199512) location 's3://redshift-spectrum-datastore-csv10/710acdcf0ad9075f4058169ef57b4df5614e0f699958a29cb29019d7f9771eba/customer=3/visitYearMonth=199512/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199601) location 's3://redshift-spectrum-datastore-csv10/30f7ead8259392936fe1334184a49350b0f20e9786ade5dfb29686dfb8af0367/customer=3/visitYearMonth=199601/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199602) location 's3://redshift-spectrum-datastore-csv10/3d5c5ab817a4ad19f7f1f6ac2b84283cf3d08e54da5b92365d82776d92245f78/customer=3/visitYearMonth=199602/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199603) location 's3://redshift-spectrum-datastore-csv10/991490b97b81e4f71ae9c5598cbd719e271729832a095986c5e2ab923891dcae/customer=3/visitYearMonth=199603/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199604) location 's3://redshift-spectrum-datastore-csv10/9d1a01ac88d7a6bca4fda0522e9731d86161f279713f6df12d19b663932d1ffd/customer=3/visitYearMonth=199604/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199605) location 's3://redshift-spectrum-datastore-csv10/80fc65efdc8d0058dfe183f68a9b977bc4f038684e56a3c29d47d8e889cad758/customer=3/visitYearMonth=199605/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199606) location 's3://redshift-spectrum-datastore-csv10/322fcfe5f6a86aaa4d1de8796a36dd2d127d4e6b2f66226073a8eeb4eff0fa90/customer=3/visitYearMonth=199606/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199607) location 's3://redshift-spectrum-datastore-csv10/59470ad1e0bb8546dc1b032e13a980438b5636167c68acf512ccee03df9b0fff/customer=3/visitYearMonth=199607/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199608) location 's3://redshift-spectrum-datastore-csv10/8a9de4d0a8e5884f94afe6e7267dfc5b5f0cf8240bb96f0fe2297a47bb5bcb86/customer=3/visitYearMonth=199608/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199609) location 's3://redshift-spectrum-datastore-csv10/83d54e62dfd8ed1714f73ecb39bd964ad1a1909f308096c6a80381fea5edf593/customer=3/visitYearMonth=199609/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199610) location 's3://redshift-spectrum-datastore-csv10/f01bd880bd6b9091ba9d6c472659d2302db5f069e32b3484a7a95a7d47caf9da/customer=3/visitYearMonth=199610/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199611) location 's3://redshift-spectrum-datastore-csv10/e2d57382ea5543fa129089091a0a96dccaf6f2448e7df768bec3a45ccff4e767/customer=3/visitYearMonth=199611/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199612) location 's3://redshift-spectrum-datastore-csv10/20c050c73612372130db1592c2ace8240960d7da30da613071f6e6b42feb653a/customer=3/visitYearMonth=199612/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199701) location 's3://redshift-spectrum-datastore-csv10/b9e642a48fff0b41a8823fb7f61f211b97c3de15e862e34057c3c0f66a0100a3/customer=3/visitYearMonth=199701/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199702) location 's3://redshift-spectrum-datastore-csv10/20d8d296b462eb1d2c1ff7904d8642f479c41aa9e4ccc9844deeb37da2ca889b/customer=3/visitYearMonth=199702/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199703) location 's3://redshift-spectrum-datastore-csv10/841725d2f744ff5e2c71ea8f9435c023562d6b5c839f80f5868d3597804c83c3/customer=3/visitYearMonth=199703/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199704) location 's3://redshift-spectrum-datastore-csv10/978d1450deea3102c1f5ef75d683cf922ee62f986cb77e4190d5477ff8db517e/customer=3/visitYearMonth=199704/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199705) location 's3://redshift-spectrum-datastore-csv10/c465449d93535d85f715bf4022e752873b746f135cafc65669e9bd3a93505b40/customer=3/visitYearMonth=199705/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199706) location 's3://redshift-spectrum-datastore-csv10/d0bff38520dfb9b61ba2af5393cef1387b42650167c6a291d6effe5f91072f8d/customer=3/visitYearMonth=199706/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199707) location 's3://redshift-spectrum-datastore-csv10/2df9fa56168ad47265b4f6046ce5297f4033e5d929fd2bc3d56e603acd702725/customer=3/visitYearMonth=199707/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199708) location 's3://redshift-spectrum-datastore-csv10/4fb3d1473e2a4782e7f27556f8ae43cb1e2b187665fb1cb55e73ca64f7e0a50e/customer=3/visitYearMonth=199708/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199709) location 's3://redshift-spectrum-datastore-csv10/1c9ace88a4e17739e6044505c316d9ac5a4afed03245421dd090ed82d1acfe11/customer=3/visitYearMonth=199709/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199710) location 's3://redshift-spectrum-datastore-csv10/c04d96f292f974cf77ecc8457bfea6da213a9e345c3f512d3f8032198206c445/customer=3/visitYearMonth=199710/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199711) location 's3://redshift-spectrum-datastore-csv10/33ec08f7bd0223c4382579c92de603a97d4dd955d46c6c483fe98bf3d6ce27ba/customer=3/visitYearMonth=199711/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199712) location 's3://redshift-spectrum-datastore-csv10/38e7023c107d1002c82b67a4ed2b939ee4360ab6e26c2b520d0495e3eef91b1d/customer=3/visitYearMonth=199712/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199801) location 's3://redshift-spectrum-datastore-csv10/aae65cfdcd7a16d87c12e09772ddc2ad764de2547e5ef7634b5cc5266c68b229/customer=3/visitYearMonth=199801/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199802) location 's3://redshift-spectrum-datastore-csv10/b9ee8bb38f04ff0a13564acf106bbdee9f23e866d901b684c1cc6c9f5abacf72/customer=3/visitYearMonth=199802/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199803) location 's3://redshift-spectrum-datastore-csv10/8b4c18942f23e5922a1ac0380ffafe62c29d35cb3b100fab97ef3485288c25fa/customer=3/visitYearMonth=199803/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199804) location 's3://redshift-spectrum-datastore-csv10/b233fe79a29d0807e6dfb9f80d3e4b79a07532fe7c199eb88598ca27f50a0cee/customer=3/visitYearMonth=199804/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199805) location 's3://redshift-spectrum-datastore-csv10/92770269ac0d4f2ceaef56fe4c03ed26e25e971629f95301fab74cd4f08c2f96/customer=3/visitYearMonth=199805/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199806) location 's3://redshift-spectrum-datastore-csv10/57284afb7931eb72607f99af3b7b6e6106212c84a083967093d421955691d9e0/customer=3/visitYearMonth=199806/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199807) location 's3://redshift-spectrum-datastore-csv10/75abc708addb3460e71e5d436c8a3ef30317607500d243fc31f9baaf5561a2cb/customer=3/visitYearMonth=199807/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199808) location 's3://redshift-spectrum-datastore-csv10/9912b0eb7ccbe17ec063991e7db55cb497ce3337492d6e395d29849548a713db/customer=3/visitYearMonth=199808/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199809) location 's3://redshift-spectrum-datastore-csv10/aef18feece64f43ab137858453e4968412cae78d0b3917c705372e8c5b0a5948/customer=3/visitYearMonth=199809/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199810) location 's3://redshift-spectrum-datastore-csv10/9abb0a96a637ac2073b2e0eadafc57341018380e66fa2c565ee930076c3aab47/customer=3/visitYearMonth=199810/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199811) location 's3://redshift-spectrum-datastore-csv10/39ed736eac5c72a410d66ba053e9ee959ac4665e2c832592deb8cefdd5d12c44/customer=3/visitYearMonth=199811/';
alter table clickstream.uservisits_csv10 add partition(customer=3, visitYearMonth=199812) location 's3://redshift-spectrum-datastore-csv10/25938d13b49adfcde2e72264043baaa1da85ff75c8014d4cff15300c5fb1418c/customer=3/visitYearMonth=199812/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199201) location 's3://redshift-spectrum-datastore-csv10/d5bf6d2e28a20e09caa1d1be29978abb833986f186b68cfafd12d2d76a606599/customer=4/visitYearMonth=199201/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199202) location 's3://redshift-spectrum-datastore-csv10/22d13409a94d8967d6396e224f857b28081ff17a078ae89f4a2297952e57aa9c/customer=4/visitYearMonth=199202/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199203) location 's3://redshift-spectrum-datastore-csv10/0494d2a8b38f5e1a36adda0af4675f2cf948b3aab0b0744334e5649cd00bc8fe/customer=4/visitYearMonth=199203/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199204) location 's3://redshift-spectrum-datastore-csv10/925f7d30db6d4e65e3dd83f7529be2b0e7051dc5116baa7bc587279d31c7a1aa/customer=4/visitYearMonth=199204/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199205) location 's3://redshift-spectrum-datastore-csv10/00fd0c2ead5ea05601f20f7e81032e741c10b2c03898737780f6c853ddabcb16/customer=4/visitYearMonth=199205/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199206) location 's3://redshift-spectrum-datastore-csv10/eeee1a45ab0033b05e67d93feebed3d22e3a8b28d46d98e02990b204cf5f55a6/customer=4/visitYearMonth=199206/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199207) location 's3://redshift-spectrum-datastore-csv10/44afeae521e99d4997853c443b65c66927d375600aa396ef07bfd78ed17ac4c5/customer=4/visitYearMonth=199207/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199208) location 's3://redshift-spectrum-datastore-csv10/ceb275ced46dea1a47410c490f711734abf6fcbedf09ec4a66eb63e8fbb62c1b/customer=4/visitYearMonth=199208/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199209) location 's3://redshift-spectrum-datastore-csv10/c58df73e3c0b20d4c22a97dc30f243791f15812438d9fbfefbc63813ca8bea5b/customer=4/visitYearMonth=199209/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199210) location 's3://redshift-spectrum-datastore-csv10/0c689c26ae48e329b4c97d4ff8f172489768dcb245580058400feca6f157f102/customer=4/visitYearMonth=199210/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199211) location 's3://redshift-spectrum-datastore-csv10/278484387032b0c525cc6d2c9f80674ca2241a2f73504e85b1cd71f66373bba0/customer=4/visitYearMonth=199211/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199212) location 's3://redshift-spectrum-datastore-csv10/60d543c828beaec92e7f325b6c530db447dc31483b1e7c05e4782f2873a2e370/customer=4/visitYearMonth=199212/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199301) location 's3://redshift-spectrum-datastore-csv10/9564d8c31b327326e7b07eaf18f50fa2822e8026176b620cf45acbfe261d4277/customer=4/visitYearMonth=199301/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199302) location 's3://redshift-spectrum-datastore-csv10/e7f1ec2f91c43624a56fb3ba945347e8ab2a81e8ffcfb99b7b4baf77318d10cd/customer=4/visitYearMonth=199302/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199303) location 's3://redshift-spectrum-datastore-csv10/91535aabd9e544c33d7f43ed05e1e064093aca31a22dd7b818b20da3dea41ea8/customer=4/visitYearMonth=199303/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199304) location 's3://redshift-spectrum-datastore-csv10/d25025d18872c2dcaaf0fc1ae456a9237198e0d2a51446c4b5add996def0883f/customer=4/visitYearMonth=199304/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199305) location 's3://redshift-spectrum-datastore-csv10/0f5bb0ca472e1b176fbd1e6e3b49f46532851c610bdc60f77e00bcf0c9a5a194/customer=4/visitYearMonth=199305/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199306) location 's3://redshift-spectrum-datastore-csv10/5fbbdafa2a04f62cf2f330675eebe62ca52a7dd8c733fc8ec85262a56ea4f1bc/customer=4/visitYearMonth=199306/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199307) location 's3://redshift-spectrum-datastore-csv10/ee3c2f7e1c1bc6a27d9d726678f17063788f4bda3f4f2f16a619d65bdd130338/customer=4/visitYearMonth=199307/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199308) location 's3://redshift-spectrum-datastore-csv10/c25aa338ed769195bb5f64dcb83208a6adc1cb87ada318c011fdf3f108a25601/customer=4/visitYearMonth=199308/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199309) location 's3://redshift-spectrum-datastore-csv10/b13c640baf6af03b3f4ccc4e310bd23bc3bab57435fbe597640efc6447c4ce08/customer=4/visitYearMonth=199309/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199310) location 's3://redshift-spectrum-datastore-csv10/6db65ed46e83c0045113c5e9a4da642f74500c9f7687d008a4d7f107c1f81213/customer=4/visitYearMonth=199310/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199311) location 's3://redshift-spectrum-datastore-csv10/30d1a8ed8d45b7cdb8a8d141387b1dd982d900fc9a42541ece9136e43eb21a02/customer=4/visitYearMonth=199311/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199312) location 's3://redshift-spectrum-datastore-csv10/0b8875ac8dd7ebbe345e51e8a3c1371314936d722d66361f7410a4272320feea/customer=4/visitYearMonth=199312/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199401) location 's3://redshift-spectrum-datastore-csv10/26e2ba6ef7bd57c78dc76173f03fe3d9ccf7f6fdd470f9426176170382680d73/customer=4/visitYearMonth=199401/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199402) location 's3://redshift-spectrum-datastore-csv10/052306671e36cc92d45005fea8fef8e67e718511fb034b43b294463f7847398f/customer=4/visitYearMonth=199402/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199403) location 's3://redshift-spectrum-datastore-csv10/4ee550285d90092156a2b685802012fa077463ea436c732ab4b86f8d25ba8ba9/customer=4/visitYearMonth=199403/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199404) location 's3://redshift-spectrum-datastore-csv10/2fb57b42bcd25c7a619b9abf18e4cb9bc27128fea9db04e5a3fe9d40715aa2d3/customer=4/visitYearMonth=199404/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199405) location 's3://redshift-spectrum-datastore-csv10/75d0b741b13f08fb4c4d32f66f464ceed85335c9d05d6e40c13e1b7ab411635a/customer=4/visitYearMonth=199405/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199406) location 's3://redshift-spectrum-datastore-csv10/6b6ace8de56f6df939feb04709cd022468c4b702349694ee8f1bf56c06aa8f1e/customer=4/visitYearMonth=199406/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199407) location 's3://redshift-spectrum-datastore-csv10/07230292eb222cf1a22a8340775515cb0c48ad0be8a33c67226f7e261f92d690/customer=4/visitYearMonth=199407/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199408) location 's3://redshift-spectrum-datastore-csv10/4ed3e0f5c0444cd6abaf7781140ca88088c7847c48b7243b26a3f8e90dffe99e/customer=4/visitYearMonth=199408/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199409) location 's3://redshift-spectrum-datastore-csv10/3e837662fdaea15858c5a71018710da693be70a805cbba1f0d4e571b843d7f79/customer=4/visitYearMonth=199409/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199410) location 's3://redshift-spectrum-datastore-csv10/61b6913eef9eec08709fbf8ba14ff007142b9b24ddcd27b4dbfe3d2f856ebbe7/customer=4/visitYearMonth=199410/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199411) location 's3://redshift-spectrum-datastore-csv10/b5e153e4fca79c745b273819befc2e437b81b447dd55742dc14bab95eb2b2383/customer=4/visitYearMonth=199411/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199412) location 's3://redshift-spectrum-datastore-csv10/e9d8b15443888dee55da4d1b278e2b717eb77ce9cd52b49efa534b34f04e6cfa/customer=4/visitYearMonth=199412/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199501) location 's3://redshift-spectrum-datastore-csv10/2bbdbfc872a4e7d38353efb9110ae07193ee6bd24f95e90a8570ba8f974964f8/customer=4/visitYearMonth=199501/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199502) location 's3://redshift-spectrum-datastore-csv10/e5c91c38f4a282e90b97b4cd139eeb7d382416566df8ca77c365644ba7384303/customer=4/visitYearMonth=199502/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199503) location 's3://redshift-spectrum-datastore-csv10/65f2512f6776d76a2922fca78792eebdfebfee093bd86af59f56b5572e1bac5a/customer=4/visitYearMonth=199503/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199504) location 's3://redshift-spectrum-datastore-csv10/a89fb679ac3d902d647e540368f03f4cc57692252d3756adbaa241c2e106146b/customer=4/visitYearMonth=199504/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199505) location 's3://redshift-spectrum-datastore-csv10/d2fd559bc83aebcadc668950d9da499582c9f67f94552c43c6999ff51ca7e11d/customer=4/visitYearMonth=199505/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199506) location 's3://redshift-spectrum-datastore-csv10/f5bc3efe7c4ce2c1ecc9527073d673dbcd82bb47159e85a8a1178ca46e523364/customer=4/visitYearMonth=199506/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199507) location 's3://redshift-spectrum-datastore-csv10/07bcd5984d9767469ae85485ce64b06eafb0cea6a4d3ab0d23c6a19f1a384e59/customer=4/visitYearMonth=199507/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199508) location 's3://redshift-spectrum-datastore-csv10/5e924d758c4cd49e8f87636eef64bd7c5792c9b3b380205a632ef03cdcd32e03/customer=4/visitYearMonth=199508/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199509) location 's3://redshift-spectrum-datastore-csv10/4e7600116e0decdbff72039cfe81e254518187e4fe936f591bc2fab9daec063a/customer=4/visitYearMonth=199509/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199510) location 's3://redshift-spectrum-datastore-csv10/93a0573c22ddc945ebc5049bc5e2852b6654ca749b819f30a7b7109537b511e6/customer=4/visitYearMonth=199510/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199511) location 's3://redshift-spectrum-datastore-csv10/94049babded5626cd94863414b383b9ed02eee67c510affa582850cd7144870c/customer=4/visitYearMonth=199511/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199512) location 's3://redshift-spectrum-datastore-csv10/382351e8e9762732f826c22d3d5ca2f899ecf0de70e42b5f2f725af961ff7a1c/customer=4/visitYearMonth=199512/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199601) location 's3://redshift-spectrum-datastore-csv10/f7c9a2383222a5b8ced0f676d2c54cf89aea20d5b955c151403e538863489d53/customer=4/visitYearMonth=199601/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199602) location 's3://redshift-spectrum-datastore-csv10/c9faaa4d2509bc8a5e7825f42a35e8cdab1c29e87480fbf06fbbfa95f025ff0a/customer=4/visitYearMonth=199602/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199603) location 's3://redshift-spectrum-datastore-csv10/a7f67a7d66819a1716ce89df3686a5cdad96d98f07ed7db7cf7c5e22dad41f9c/customer=4/visitYearMonth=199603/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199604) location 's3://redshift-spectrum-datastore-csv10/c7d5ee26f1e0fbd5bc53961fd29b429dfb46f0da96bfa3566851f26e3afc61b4/customer=4/visitYearMonth=199604/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199605) location 's3://redshift-spectrum-datastore-csv10/1a869a74f6dcf59055137e4dbda45be7f2a18dd6a919ea78a9488269c86867dd/customer=4/visitYearMonth=199605/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199606) location 's3://redshift-spectrum-datastore-csv10/6ffdb923aecef94623f37b6b4fc620d685ec093a2122341733d42be413d32e22/customer=4/visitYearMonth=199606/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199607) location 's3://redshift-spectrum-datastore-csv10/1d62e52c4be3febe5043f25d7c8d73fc412cb79320ec2bc0f8a31739821a6a99/customer=4/visitYearMonth=199607/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199608) location 's3://redshift-spectrum-datastore-csv10/ee4caca9e352fa3ac7e2fb3204e836d30b83f6dcb948e4a9f52efe13152fab85/customer=4/visitYearMonth=199608/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199609) location 's3://redshift-spectrum-datastore-csv10/4325a9bb92b8c0aa7f09356761601fde49821853e7b832cc497f71f9bda46843/customer=4/visitYearMonth=199609/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199610) location 's3://redshift-spectrum-datastore-csv10/81d9c655460c4482153ccba41b55088cd065797139b918c5fddca1dcc7d41d71/customer=4/visitYearMonth=199610/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199611) location 's3://redshift-spectrum-datastore-csv10/e37e1c797a8b9da305b24d410c115b3546e097466342edee059ec23afbd60386/customer=4/visitYearMonth=199611/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199612) location 's3://redshift-spectrum-datastore-csv10/9b7ae1dc4776ba077e346aff42571e7f0522a55087066aecd5d5b25920b7578e/customer=4/visitYearMonth=199612/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199701) location 's3://redshift-spectrum-datastore-csv10/a3a8a4cdcd7067fe9c808d116c6c3c4a3e34f91986b4916442d1e341063aae33/customer=4/visitYearMonth=199701/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199702) location 's3://redshift-spectrum-datastore-csv10/976f3b9274403ccf7cde437a014e9113ac04d1ea866d450050c5a1dd723c18ae/customer=4/visitYearMonth=199702/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199703) location 's3://redshift-spectrum-datastore-csv10/5a0dd903fed6d6068f6745f42ddc0cdf9e77989b849f119cd21d202ff01b472a/customer=4/visitYearMonth=199703/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199704) location 's3://redshift-spectrum-datastore-csv10/1ec2c77007fffac9a39aeb176d72734cc5c988dc14fb6e706516dd3c94791037/customer=4/visitYearMonth=199704/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199705) location 's3://redshift-spectrum-datastore-csv10/ee76f840262020e065eb2e66764edc1c9e578251430dcd504bbc471df361f988/customer=4/visitYearMonth=199705/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199706) location 's3://redshift-spectrum-datastore-csv10/a8e563cc8f7d8dff70104d3430bd01656d6a5befb533ca7613b57c330a2a6114/customer=4/visitYearMonth=199706/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199707) location 's3://redshift-spectrum-datastore-csv10/35a2d156f4af4f20e7939f49c797462f8c326288de9fbb1e6cbb154f52a0ef7d/customer=4/visitYearMonth=199707/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199708) location 's3://redshift-spectrum-datastore-csv10/7bb6c9128f6d9d1c6494a2587053e94eb7f882a5d8b1cc0d15d43635c9bb1334/customer=4/visitYearMonth=199708/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199709) location 's3://redshift-spectrum-datastore-csv10/19205ad1bab12ef09bf741078d5ffd5948cf0a8bfc543fc6b713d5b959a4195c/customer=4/visitYearMonth=199709/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199710) location 's3://redshift-spectrum-datastore-csv10/0549b0113359e380cfc398280e5c2065ff06d1929478d050348b07817610353a/customer=4/visitYearMonth=199710/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199711) location 's3://redshift-spectrum-datastore-csv10/19f642cadf2a350c23386b78751c8ca0f8d105eed006b1e3b6dd378becee662d/customer=4/visitYearMonth=199711/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199712) location 's3://redshift-spectrum-datastore-csv10/9dec72103d861f2fee039ca32d7ff7590eca56f5164cea2edf032cbf67ccb3a7/customer=4/visitYearMonth=199712/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199801) location 's3://redshift-spectrum-datastore-csv10/27d5bccb1423d612a257a4bb77159f7fdabdac2e928e0f590c47c9b1db621dbe/customer=4/visitYearMonth=199801/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199802) location 's3://redshift-spectrum-datastore-csv10/33655ac936b50e39fd403def6fb2cfae937926c9f4e1bd982a99dd5034e49c82/customer=4/visitYearMonth=199802/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199803) location 's3://redshift-spectrum-datastore-csv10/b1a9c574108fa37d1906baf5e74ff0a0c7457d996140d25de14e03ea93cedc23/customer=4/visitYearMonth=199803/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199804) location 's3://redshift-spectrum-datastore-csv10/7124242f2d2270f04f8edf1b2ce262f109a9a7a2488b5352fb7ac8872de3dd0e/customer=4/visitYearMonth=199804/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199805) location 's3://redshift-spectrum-datastore-csv10/90ceaf4bdb01ac4834a6fdf6fb1408460af850efbd55776d2f3b5c52d5e05072/customer=4/visitYearMonth=199805/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199806) location 's3://redshift-spectrum-datastore-csv10/736156303de74d81686b153e7980630995838abf8f9a826dde88c68fe6d6f856/customer=4/visitYearMonth=199806/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199807) location 's3://redshift-spectrum-datastore-csv10/eba7699d3e1aafb705677eec394378b24497e1a8cb863e09dac58cc05e457f79/customer=4/visitYearMonth=199807/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199808) location 's3://redshift-spectrum-datastore-csv10/5450e928beb89a4575523fe5049bbb8af1e40b735e43594ecd3bc957c2761e24/customer=4/visitYearMonth=199808/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199809) location 's3://redshift-spectrum-datastore-csv10/1c56269c6fb8ddb7d7abb77b9d54a1f7ead9567124b766bc4eff57f9d4b85115/customer=4/visitYearMonth=199809/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199810) location 's3://redshift-spectrum-datastore-csv10/758222d8e321545a55efe2471adbf17121695441024f107d4e941438d9f34d05/customer=4/visitYearMonth=199810/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199811) location 's3://redshift-spectrum-datastore-csv10/12142bf8a7dc435ced0e5ccf5c95dc0a77931e541af23cdbb23b3451860a4655/customer=4/visitYearMonth=199811/';
alter table clickstream.uservisits_csv10 add partition(customer=4, visitYearMonth=199812) location 's3://redshift-spectrum-datastore-csv10/094dd4e9b8d74d357c113e90cb4b260605db2f71a74528eb44acbd7fd69fa30f/customer=4/visitYearMonth=199812/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199201) location 's3://redshift-spectrum-datastore-csv10/8c6e63005afc044665e6b1b01b1ec5cc908775b476d71fd5c6899696fcc626ca/customer=5/visitYearMonth=199201/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199202) location 's3://redshift-spectrum-datastore-csv10/472cee68049ad7c24eef37842e148afc30bdb9c6b3576e0be19ffd8bae00ad5b/customer=5/visitYearMonth=199202/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199203) location 's3://redshift-spectrum-datastore-csv10/c2f58e2166e51ff56c5f7191fe6513f5716c27e206c6cae0a36062a85c026159/customer=5/visitYearMonth=199203/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199204) location 's3://redshift-spectrum-datastore-csv10/cb87ea2510ec057729bba26825bc2b7c3ba19332b2d722f347f7ac8c4b172c9c/customer=5/visitYearMonth=199204/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199205) location 's3://redshift-spectrum-datastore-csv10/afbb5fcf6884589d5494aa5e5feef674fe20a160f54deb465931b6dd5fe56126/customer=5/visitYearMonth=199205/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199206) location 's3://redshift-spectrum-datastore-csv10/a81e3dd133ca197fd406896e336edef3ce7820e871ef7d10aef13cbe95c25706/customer=5/visitYearMonth=199206/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199207) location 's3://redshift-spectrum-datastore-csv10/0cff9a55a054a1ee6503d0e3b3b20d7846c98e196f4ff718cd94414cd620d3b2/customer=5/visitYearMonth=199207/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199208) location 's3://redshift-spectrum-datastore-csv10/0470c57c217ac61b0fb8fc14be48b61e551205d82c2458fcedb78919c0275f90/customer=5/visitYearMonth=199208/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199209) location 's3://redshift-spectrum-datastore-csv10/ee8ab2093eeb19bdcc8f1acf7b0f6f85370f9097a9c5d70b6eb2cd3306dcce9b/customer=5/visitYearMonth=199209/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199210) location 's3://redshift-spectrum-datastore-csv10/cbe123e881ffcedd45e602ef1abe1d2041ed4ac5eddb279dd1c6374afe1b716d/customer=5/visitYearMonth=199210/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199211) location 's3://redshift-spectrum-datastore-csv10/622400146866c41cd650d3006a815b0f8fa2e59dbc0ae61e4094cc897fb2cd9e/customer=5/visitYearMonth=199211/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199212) location 's3://redshift-spectrum-datastore-csv10/3972b7a0da2b039a904705e5185327e46195d150c7be33fe52a3e9d869167337/customer=5/visitYearMonth=199212/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199301) location 's3://redshift-spectrum-datastore-csv10/98911235fa20f884bc88855d4da0708f9d0ad5f4f6b2f8e21f0882c6662a6a69/customer=5/visitYearMonth=199301/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199302) location 's3://redshift-spectrum-datastore-csv10/cefd964561b2de79b656526fb77fe643c36c5b8ad5a631dd2821603e322506d1/customer=5/visitYearMonth=199302/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199303) location 's3://redshift-spectrum-datastore-csv10/bf460fd3274813367319cc5617dbaabeb18e597f20002e82ff5f3100a766ecc9/customer=5/visitYearMonth=199303/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199304) location 's3://redshift-spectrum-datastore-csv10/1e95d42e0c8123c219bc0af5f7aa8fa31a2160c2d95046f8aa6a2c5bc23e0f1a/customer=5/visitYearMonth=199304/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199305) location 's3://redshift-spectrum-datastore-csv10/b146d5e39aa96c52bbe23bfadaa9f39ab3f463a2399f2002181220d11f9545fd/customer=5/visitYearMonth=199305/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199306) location 's3://redshift-spectrum-datastore-csv10/ca365cfc9e159e3538133c84c844d5b9a2a9789c4c8734a6b4823bf432547963/customer=5/visitYearMonth=199306/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199307) location 's3://redshift-spectrum-datastore-csv10/9f9313bd2786c00188e30716cb179c00f08b1941aa17c6f360065600f03c17b8/customer=5/visitYearMonth=199307/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199308) location 's3://redshift-spectrum-datastore-csv10/5b8be6b1419578b00e9b597bb5d93e586c57eafde74f326e94a2879cfd81e48e/customer=5/visitYearMonth=199308/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199309) location 's3://redshift-spectrum-datastore-csv10/2691ad8ebb7eb40b9da21bb3cca6d56aed4b3fcc6b5b991fe4a64db6e0c5ce19/customer=5/visitYearMonth=199309/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199310) location 's3://redshift-spectrum-datastore-csv10/8d55c2bf6ac459030dba8152c1954a64ad6aea81a3f3347d8bf2d1e41db3af2d/customer=5/visitYearMonth=199310/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199311) location 's3://redshift-spectrum-datastore-csv10/b17a38d8187391e2e537c3d19e4159941af89ff3f2aeb2d65db78c71c039d88b/customer=5/visitYearMonth=199311/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199312) location 's3://redshift-spectrum-datastore-csv10/225afa5a7c80dcc18c3ba7021d9c24b1d9cc4493a5c43db396f363e2020430c8/customer=5/visitYearMonth=199312/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199401) location 's3://redshift-spectrum-datastore-csv10/60ac2ba985859e59b92f4dadd859e80aabe61723d28f8c3375ff14f9a4be95af/customer=5/visitYearMonth=199401/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199402) location 's3://redshift-spectrum-datastore-csv10/3f13c4c6ed173506331ed2ec2f992f49e033588190cc8f5fb62290f1ba0f9872/customer=5/visitYearMonth=199402/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199403) location 's3://redshift-spectrum-datastore-csv10/a8d1c7dbe1bc5c2ca618d1d968f05d1d2b05de51aba65f064d8eef8d568a83e1/customer=5/visitYearMonth=199403/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199404) location 's3://redshift-spectrum-datastore-csv10/3285eccd48bb5c2d432f9d1e704929f216f91e5a19c09dd8a18d376a145a385d/customer=5/visitYearMonth=199404/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199405) location 's3://redshift-spectrum-datastore-csv10/73ffadee0772bb05fba4d2c223993539a7f3aaf6d84ef4883570fa11cc426467/customer=5/visitYearMonth=199405/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199406) location 's3://redshift-spectrum-datastore-csv10/bbbdec087a446bc3472de8b34d3e8b8088d95e97153d86b2d5c48df3f81d0486/customer=5/visitYearMonth=199406/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199407) location 's3://redshift-spectrum-datastore-csv10/4ef1bad7803fa0f7299199ecfeee8a6f0a116c4f86fad5bb1b8a6edf4b8fa9eb/customer=5/visitYearMonth=199407/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199408) location 's3://redshift-spectrum-datastore-csv10/279752c871fdd2da90bbef3b810e5756431585396e9aedabc9261a9b3b766a62/customer=5/visitYearMonth=199408/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199409) location 's3://redshift-spectrum-datastore-csv10/f094672beada455757202ebb17a3e860f1ddd9b26770977ef3dcb8b88da82660/customer=5/visitYearMonth=199409/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199410) location 's3://redshift-spectrum-datastore-csv10/639bf960a50ec4d825442f8980eaee5e899463e6ae4ee81d6dfd7b3def504772/customer=5/visitYearMonth=199410/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199411) location 's3://redshift-spectrum-datastore-csv10/7c69509ad64a8780004320dc225bdc2438168a4a80d1fd9ecced1f5891016974/customer=5/visitYearMonth=199411/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199412) location 's3://redshift-spectrum-datastore-csv10/58d251734cebb65846aa15320f9e5527465651032e3eab615cf935c8f99fd278/customer=5/visitYearMonth=199412/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199501) location 's3://redshift-spectrum-datastore-csv10/e528d05e4fa7237a2b389737c4a47ec0cc356b4eb1445086be57939cf7d6d67d/customer=5/visitYearMonth=199501/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199502) location 's3://redshift-spectrum-datastore-csv10/3a4f8c8d5741da200db0b039fbdf2246ad6d90538e91923f726400b1e4b11bb1/customer=5/visitYearMonth=199502/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199503) location 's3://redshift-spectrum-datastore-csv10/4b2a5aaff45c68b020d9f26946cf1888ba779865a502722fb156a4a413cd78cf/customer=5/visitYearMonth=199503/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199504) location 's3://redshift-spectrum-datastore-csv10/d5a83bad203bd79238db8fe9fe8c1a988bcf9e303d9f6bf66a81507ebea38564/customer=5/visitYearMonth=199504/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199505) location 's3://redshift-spectrum-datastore-csv10/0f24a5e13e4550051dd9c953ab5e54a0eed90e99f9c130b476747cd3d45376c4/customer=5/visitYearMonth=199505/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199506) location 's3://redshift-spectrum-datastore-csv10/4f0f91bb3eaf3f271f5874c29b00a7081cc662b706cb3eb1e4dc52cc8a1483c3/customer=5/visitYearMonth=199506/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199507) location 's3://redshift-spectrum-datastore-csv10/42723d348a5611535454ab44d836fadc05d1a548862c61f7eed7cb501219e763/customer=5/visitYearMonth=199507/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199508) location 's3://redshift-spectrum-datastore-csv10/7c5fab4ec852b40f1f2ceebf5735a421bc6582f51279f59d8e319e60b14fd050/customer=5/visitYearMonth=199508/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199509) location 's3://redshift-spectrum-datastore-csv10/d4acb75f7c4e2f6b31547c321c544b4ff4a4b325df7521043583a81ccf3f408a/customer=5/visitYearMonth=199509/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199510) location 's3://redshift-spectrum-datastore-csv10/09e1ab0c1bca8ad2fb234265e9887bdea51c62b4ce058d88c381fb267a4c11af/customer=5/visitYearMonth=199510/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199511) location 's3://redshift-spectrum-datastore-csv10/d362bd26aa6bc18d5ee973296656123a74ed6238de883d10023ea1b78ed3d9f1/customer=5/visitYearMonth=199511/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199512) location 's3://redshift-spectrum-datastore-csv10/d5c94bab877462d51787a0d7a0d0d0da747c26546fcb20ce593862042d52ce0e/customer=5/visitYearMonth=199512/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199601) location 's3://redshift-spectrum-datastore-csv10/67eddeaca64aaa287e722392817c4f8e707fb61816e2ddc9f9515d09d99de085/customer=5/visitYearMonth=199601/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199602) location 's3://redshift-spectrum-datastore-csv10/db3c2e85a5202fc00616a3c1db672aa5c923cdfd906dd73b8aa6a217c45ad587/customer=5/visitYearMonth=199602/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199603) location 's3://redshift-spectrum-datastore-csv10/eb1692914aad9b4748095f8cf82f2344032b87b3e114e0d06c9aaba103bb25c8/customer=5/visitYearMonth=199603/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199604) location 's3://redshift-spectrum-datastore-csv10/e18f00569f9a85dfe68b8d660b331317ce9a214c53999709f916067da95838de/customer=5/visitYearMonth=199604/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199605) location 's3://redshift-spectrum-datastore-csv10/3269e828bb41a27de344d9ae06e1a8762a025870eeebd07677c2bd1f45dcca44/customer=5/visitYearMonth=199605/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199606) location 's3://redshift-spectrum-datastore-csv10/6e670a538300bdb60d2a0d625b7845b68e035e3ddff9f3a0276384e4d7b87e29/customer=5/visitYearMonth=199606/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199607) location 's3://redshift-spectrum-datastore-csv10/00a642687c1314ed9b1fa69257ab6d5542ba6f8c0873f900f223f581cb583263/customer=5/visitYearMonth=199607/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199608) location 's3://redshift-spectrum-datastore-csv10/22b07df2e3413f971434851947a363160defb9a4594e13984a79f4da9dda9332/customer=5/visitYearMonth=199608/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199609) location 's3://redshift-spectrum-datastore-csv10/0aa5a7d0ce03472311e4c5e9f5488b56288c04e1eb761afeb326755e6f464add/customer=5/visitYearMonth=199609/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199610) location 's3://redshift-spectrum-datastore-csv10/ff1d9de100d89c6397538d5c2941b290e1f37c9c588f4304563c670dde065758/customer=5/visitYearMonth=199610/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199611) location 's3://redshift-spectrum-datastore-csv10/05223b6ed587fa354bab53d8c2e879ff4a56c64dc5e04a0d2991994dc0c3a27c/customer=5/visitYearMonth=199611/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199612) location 's3://redshift-spectrum-datastore-csv10/df9906108c532cf6046b54da5cd9afc6bb1ed7f775b73ce1b62f1c423f323494/customer=5/visitYearMonth=199612/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199701) location 's3://redshift-spectrum-datastore-csv10/fcab8909581ecd0221336983c65d4c19e89fb159aabceebcb7839c9b5110211d/customer=5/visitYearMonth=199701/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199702) location 's3://redshift-spectrum-datastore-csv10/fca01fb16c5b986ccfea0a4d27e4c0db6ab7d1983a819b0a5b57df81b03d958c/customer=5/visitYearMonth=199702/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199703) location 's3://redshift-spectrum-datastore-csv10/dd8d6245ab8964f3e11d6ba4e542b50b73e46193a4d13c9eaabb51d72674a9b7/customer=5/visitYearMonth=199703/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199704) location 's3://redshift-spectrum-datastore-csv10/b9ad3d2719cb9a8f697e8a181f6ce6b27e6f36fb4e0351c602336933dd185bcd/customer=5/visitYearMonth=199704/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199705) location 's3://redshift-spectrum-datastore-csv10/fd34bb0c8d27e2eb03fe48b606aa638d6b423d216b8a4ae3c559cffebd7336a0/customer=5/visitYearMonth=199705/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199706) location 's3://redshift-spectrum-datastore-csv10/24738a7bc7ce034b5f887514d7a2c642c786523fe72ba41438fc3be3091a77e3/customer=5/visitYearMonth=199706/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199707) location 's3://redshift-spectrum-datastore-csv10/ed86ff88a6f7094dc646c62ac549ba66250215f366986e220efbe3d5ba8819b3/customer=5/visitYearMonth=199707/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199708) location 's3://redshift-spectrum-datastore-csv10/9bef0abc1e61ffafbf8017fbbbcb70db169a8d037b139dea017eb448fcf0bdba/customer=5/visitYearMonth=199708/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199709) location 's3://redshift-spectrum-datastore-csv10/be02b159962d4c4317f7e0975e5c327302867ded6445f6302a3a8fa08ff2ae49/customer=5/visitYearMonth=199709/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199710) location 's3://redshift-spectrum-datastore-csv10/fafbee86227586893b2909f27061ebffeb7d5946335d13d9a88fdbebf95858c7/customer=5/visitYearMonth=199710/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199711) location 's3://redshift-spectrum-datastore-csv10/93d74e506b9b38666a92d2fd0e4550a5dcd0079864da88f84c25c67c58e4dca1/customer=5/visitYearMonth=199711/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199712) location 's3://redshift-spectrum-datastore-csv10/85aba8ee444b32cde43bce09304d0d67ab563a650f948f3fcbc108fe47facea6/customer=5/visitYearMonth=199712/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199801) location 's3://redshift-spectrum-datastore-csv10/e770656fefef210eda8cba94d13156db88e1089ef0652ef0605c10d005321ae6/customer=5/visitYearMonth=199801/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199802) location 's3://redshift-spectrum-datastore-csv10/c4b661041ecf30605f230cadb543c7a359066e1239e304e61c8222f3591c92a7/customer=5/visitYearMonth=199802/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199803) location 's3://redshift-spectrum-datastore-csv10/0647bb586487127b5990a4920b26bc776f18aca849f56cdc669919056c23e198/customer=5/visitYearMonth=199803/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199804) location 's3://redshift-spectrum-datastore-csv10/b18ce85cdad602441001cc3493274639b14d2e0b97dcf365b1b2ed7e6e2b53e8/customer=5/visitYearMonth=199804/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199805) location 's3://redshift-spectrum-datastore-csv10/b508acbd6fff4b660238046ce21e466fb0b12d0b6968c41adbf2a531f734f7f8/customer=5/visitYearMonth=199805/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199806) location 's3://redshift-spectrum-datastore-csv10/e9dc9af2252cdf22efa44073583d55e2edd4519e300df7ead40a0a9293d8a730/customer=5/visitYearMonth=199806/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199807) location 's3://redshift-spectrum-datastore-csv10/ebd6eb2bc042a24f2e20036d11851a46dd27ffdefe8c0e9219e3ed63cc66a452/customer=5/visitYearMonth=199807/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199808) location 's3://redshift-spectrum-datastore-csv10/fb3d9013b62ac83d63f4c6045ee4a16268e8d97c05ada891057893350d15de75/customer=5/visitYearMonth=199808/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199809) location 's3://redshift-spectrum-datastore-csv10/524b650914a3102d72469c4c02143914277dbf0b96094e17c062f6f174406ac3/customer=5/visitYearMonth=199809/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199810) location 's3://redshift-spectrum-datastore-csv10/4e9f45da7d65a4c800b6d6aa2f269b5ad8039b55703f2c7a93a217551f1a506c/customer=5/visitYearMonth=199810/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199811) location 's3://redshift-spectrum-datastore-csv10/79f5c73887cc54470cf89d5a58ffc353727136ecf1c9b96c3a175a9fd3e7a762/customer=5/visitYearMonth=199811/';
alter table clickstream.uservisits_csv10 add partition(customer=5, visitYearMonth=199812) location 's3://redshift-spectrum-datastore-csv10/f630f9bfb9dadffe1b5207a58ec74832eac2942c8f5aa2fbe62e6b4b34fad417/customer=5/visitYearMonth=199812/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199201) location 's3://redshift-spectrum-datastore-csv10/1081cbaee50c5554794362cff1a98d88e207feebc45dab4e38b55a2d0df1060d/customer=6/visitYearMonth=199201/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199202) location 's3://redshift-spectrum-datastore-csv10/45033d2b09068268dd8146febe33e311a56e9105e146cb1f6016e5bc63014fdc/customer=6/visitYearMonth=199202/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199203) location 's3://redshift-spectrum-datastore-csv10/bb239f355ee97b91cd4d3fc7ccbdc3c9e0bef78bb177d4bf0ca2174f257cee70/customer=6/visitYearMonth=199203/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199204) location 's3://redshift-spectrum-datastore-csv10/6826b8399543bb941435ce6969bb6e0981384b6543a49d195a942499e6b12406/customer=6/visitYearMonth=199204/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199205) location 's3://redshift-spectrum-datastore-csv10/76db28294c8eb1371ab01dadcc802bfa663a2edb77b6b9ca5330dc9f650b6ce1/customer=6/visitYearMonth=199205/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199206) location 's3://redshift-spectrum-datastore-csv10/4dcf04f7aa8c26964fa531331327515e26c0964f6619df2abfd6039a26efa2f5/customer=6/visitYearMonth=199206/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199207) location 's3://redshift-spectrum-datastore-csv10/fba9850ab6fed474df22e4e2b719e29305d6671985a5289b3a9dd6a436e5f541/customer=6/visitYearMonth=199207/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199208) location 's3://redshift-spectrum-datastore-csv10/aa1924390b2e2053e29ef64b1b297a83a69752b68370a11a7f2ebd467b2a4a56/customer=6/visitYearMonth=199208/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199209) location 's3://redshift-spectrum-datastore-csv10/aac1f693874d24c79aa8976e20d4c29ef24366219120a1cc2746fea42834432e/customer=6/visitYearMonth=199209/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199210) location 's3://redshift-spectrum-datastore-csv10/6b87b8da42f2bcca69bdecc48324248aa28576e2672cc60f9681a4ae31829cb2/customer=6/visitYearMonth=199210/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199211) location 's3://redshift-spectrum-datastore-csv10/478099b890e308b8f58e46606e969f87a3af57d46065f51a3099a8f125cd887c/customer=6/visitYearMonth=199211/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199212) location 's3://redshift-spectrum-datastore-csv10/406dd400b51982a5f7c8c241da8a2499cd4bc97218fb08444a884fe9034d6e55/customer=6/visitYearMonth=199212/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199301) location 's3://redshift-spectrum-datastore-csv10/b123826bf48615884e93e217bc012b6dfcaea0f6368961f27f398cfa389eac6c/customer=6/visitYearMonth=199301/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199302) location 's3://redshift-spectrum-datastore-csv10/bdce2d0e0d1b8b2884d631848ebd81311232e584f3619407866fa4aeb7a359dd/customer=6/visitYearMonth=199302/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199303) location 's3://redshift-spectrum-datastore-csv10/67f156418a4485c9f19b8cf518d9e64ad31a927205d807ac31f316bd78cf3996/customer=6/visitYearMonth=199303/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199304) location 's3://redshift-spectrum-datastore-csv10/c3b233835c7189fc10457a4618adab763415db7a3161c669ba037dd7297ec9be/customer=6/visitYearMonth=199304/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199305) location 's3://redshift-spectrum-datastore-csv10/378ca31e44b6f431d4da6cd6bde987a3b96b9a7683c98e35912fabf874627a85/customer=6/visitYearMonth=199305/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199306) location 's3://redshift-spectrum-datastore-csv10/6fe907c906f3eed0c6022b39c1733f6ff79a50a27453693828993fbe1b2f9854/customer=6/visitYearMonth=199306/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199307) location 's3://redshift-spectrum-datastore-csv10/45e6fdf934fc67ada588ea65f7dc7e8a87fabe5c6512eee16a97907687b3b065/customer=6/visitYearMonth=199307/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199308) location 's3://redshift-spectrum-datastore-csv10/432efe0ffe2b232b1fb45416675e708cfd6ee017311c8e49125bb730476aa091/customer=6/visitYearMonth=199308/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199309) location 's3://redshift-spectrum-datastore-csv10/0237825e7c5a52ddc5c51b6d38994092cd9a4a9681d98828e51c86a090d47589/customer=6/visitYearMonth=199309/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199310) location 's3://redshift-spectrum-datastore-csv10/ecf42ef4b10f0b51c659f45a37eadaaed1ef5a3bae4866039f12c653e2e0459a/customer=6/visitYearMonth=199310/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199311) location 's3://redshift-spectrum-datastore-csv10/7aa3757468f94ed23e49bd9a3c1a2588acc8a436d2518b98a77543a0e032318e/customer=6/visitYearMonth=199311/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199312) location 's3://redshift-spectrum-datastore-csv10/5b9cedb435c369a8cd09def7dbc4a6d6fbfc19e732f3e175ba62a5f1037536e4/customer=6/visitYearMonth=199312/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199401) location 's3://redshift-spectrum-datastore-csv10/321b878c6f04c17727eca818e1f0b402493be04612af3ca572aed6de26a8500a/customer=6/visitYearMonth=199401/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199402) location 's3://redshift-spectrum-datastore-csv10/7511b29694514127ac4184e798be91174a6090d8cd9f17cbc679738f1fb9ffd0/customer=6/visitYearMonth=199402/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199403) location 's3://redshift-spectrum-datastore-csv10/f822afbe1b928c0953818ad4050b91b94827e3214e827e51ac9902ee3713fc13/customer=6/visitYearMonth=199403/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199404) location 's3://redshift-spectrum-datastore-csv10/effaa93a65034ba9ea331cce73014924572a2cf7b64a32448aa63e9e46804a49/customer=6/visitYearMonth=199404/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199405) location 's3://redshift-spectrum-datastore-csv10/a503c7e3d254f7da247711b40aa1f1be6b7e58d763205dfaa6ab72c85bd11929/customer=6/visitYearMonth=199405/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199406) location 's3://redshift-spectrum-datastore-csv10/5e31ead8879f27c084e56bf2a4c0712cbfa973db81c60ec70c6a8a793b304bdd/customer=6/visitYearMonth=199406/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199407) location 's3://redshift-spectrum-datastore-csv10/a42e9c8ec37e18a418585f7e69fad612b296489fc2368c77ec09b40b7c9cc45a/customer=6/visitYearMonth=199407/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199408) location 's3://redshift-spectrum-datastore-csv10/fba78cd6a70d019eaaeccdee6033dac70b04446c6950e91766ac6ec6d59c2500/customer=6/visitYearMonth=199408/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199409) location 's3://redshift-spectrum-datastore-csv10/9e9fa539d63a536c66327964b16dee8fba3440d8e6f48a00d9052d0de0670d4d/customer=6/visitYearMonth=199409/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199410) location 's3://redshift-spectrum-datastore-csv10/df9fbc24c4603d1613934754e6f146805b80df5bb35a46d9ee8246c1a16f4a19/customer=6/visitYearMonth=199410/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199411) location 's3://redshift-spectrum-datastore-csv10/0382d68499f3893d259c3a219b4948a0e349bc9f1d20bcc9b0e2d79dbdeea2ce/customer=6/visitYearMonth=199411/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199412) location 's3://redshift-spectrum-datastore-csv10/ab96ed4b8802d2cc6f085450f92ef3af9519d874cff00262ac09dae22a4a40e3/customer=6/visitYearMonth=199412/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199501) location 's3://redshift-spectrum-datastore-csv10/a2167832027380753cc3905c2dbe7a828f1a3dece2122a7edad7050348715360/customer=6/visitYearMonth=199501/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199502) location 's3://redshift-spectrum-datastore-csv10/d6ff8fb4f57988b88639acf7d178ed0b575a9b77e6c464df4bb66d8e71ef537e/customer=6/visitYearMonth=199502/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199503) location 's3://redshift-spectrum-datastore-csv10/61650d6949141a7a11d5b4e6c8bef66a498e82fad2410317613f2ba68916b756/customer=6/visitYearMonth=199503/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199504) location 's3://redshift-spectrum-datastore-csv10/eb142f7032b60ac93472939beefdce8eb18508a64e3eb4b589f53fe5589f94e3/customer=6/visitYearMonth=199504/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199505) location 's3://redshift-spectrum-datastore-csv10/2f2780a06544ff05377aff7f5f312544a54a6ccdc2359cf8a6afce80da068e8b/customer=6/visitYearMonth=199505/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199506) location 's3://redshift-spectrum-datastore-csv10/59cc9e4a07f378796bbf0b52788a9891aa9a0bd4733e15f0465c88409d7c4160/customer=6/visitYearMonth=199506/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199507) location 's3://redshift-spectrum-datastore-csv10/3e7b9e3ea9f90f309dd4715a722c26556b88303e9746fce770fb86c5807a57c4/customer=6/visitYearMonth=199507/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199508) location 's3://redshift-spectrum-datastore-csv10/e46c5875c36830802208ad2bbb33a568b535bd35ad729f91c84fba575eecd20d/customer=6/visitYearMonth=199508/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199509) location 's3://redshift-spectrum-datastore-csv10/519f0f75d7dae543e19245599f36480fe805ef17b61ce1dd0e138d8349839519/customer=6/visitYearMonth=199509/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199510) location 's3://redshift-spectrum-datastore-csv10/67c0d13c983be4bcd2e931a00e0f04a775e5b6600aae581478f7c329b9ff8188/customer=6/visitYearMonth=199510/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199511) location 's3://redshift-spectrum-datastore-csv10/930c1277882a8dd80c16a6d4424888bca09ffda1d6f0d1a36a1f3927c787a1c4/customer=6/visitYearMonth=199511/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199512) location 's3://redshift-spectrum-datastore-csv10/f551283717407d2cd1b1318aaebf3a45f5a5927527457a632c9543712d3f2043/customer=6/visitYearMonth=199512/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199601) location 's3://redshift-spectrum-datastore-csv10/549a23dc6c1f36fbb02abd60e7bee0474535550de534d8d6d187f6c2fe56c30d/customer=6/visitYearMonth=199601/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199602) location 's3://redshift-spectrum-datastore-csv10/843c8694c85c3985e7394810c08c0cdea500e4e5959c8c5407351d2cfed81e06/customer=6/visitYearMonth=199602/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199603) location 's3://redshift-spectrum-datastore-csv10/4b16e88814b18ce76b7cacd641be0618bec5d15e312aa8f67839256ee56fc1ac/customer=6/visitYearMonth=199603/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199604) location 's3://redshift-spectrum-datastore-csv10/b583734c5b01ffe7d3d60428fc5016b0d394748efbe15237f2550afaf9ae3780/customer=6/visitYearMonth=199604/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199605) location 's3://redshift-spectrum-datastore-csv10/3d8efe130759d11c3d2276c5d6be7057a88631bab21ac45e974500e67cd051d4/customer=6/visitYearMonth=199605/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199606) location 's3://redshift-spectrum-datastore-csv10/ff89592e85e00581a6864036b7063496071ecb40f51051989ea1c4e969025cba/customer=6/visitYearMonth=199606/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199607) location 's3://redshift-spectrum-datastore-csv10/f247481dfd113dca881106bbcd6298c09d0dd7cd1965f14f49a44b3df4c820da/customer=6/visitYearMonth=199607/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199608) location 's3://redshift-spectrum-datastore-csv10/5fd3f61eca307c00b851590fd0eb4a5d1cb99fb30698d03cb647a0fc6f17005c/customer=6/visitYearMonth=199608/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199609) location 's3://redshift-spectrum-datastore-csv10/3b927048faed138138bb8b951aff90e598ed51b8e39d20ccdff3de3f5380d055/customer=6/visitYearMonth=199609/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199610) location 's3://redshift-spectrum-datastore-csv10/b061f1317172bb81a46c1f9a9663832f4254985a39a10975f7c87377b709b36d/customer=6/visitYearMonth=199610/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199611) location 's3://redshift-spectrum-datastore-csv10/511ac5e55f42b97b2178930ba2af796d81815fb0e0ae53b3032679a5b4faa04d/customer=6/visitYearMonth=199611/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199612) location 's3://redshift-spectrum-datastore-csv10/80a57bc9e3493eb73d022bb1a17413200a9a4cd6d66c04ea69c50a5df4d81195/customer=6/visitYearMonth=199612/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199701) location 's3://redshift-spectrum-datastore-csv10/8fb9b3d11e24435677426cd3803968803671e0e130b4c6bf844640278e9e7765/customer=6/visitYearMonth=199701/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199702) location 's3://redshift-spectrum-datastore-csv10/4df7f34eed0e66cef35d3559264c0fcad35710351e562fe5bc8556456828cc75/customer=6/visitYearMonth=199702/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199703) location 's3://redshift-spectrum-datastore-csv10/c271a6165a3d2265a612e1b7d5d5c84cecfb0279bedb918e7ded9391afef7cd1/customer=6/visitYearMonth=199703/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199704) location 's3://redshift-spectrum-datastore-csv10/aab27722b402a7ab38feb8fbf7fbd657405181c8b5b9dfd34f1571e24a1b28d2/customer=6/visitYearMonth=199704/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199705) location 's3://redshift-spectrum-datastore-csv10/4e3205dc52d6dca740bb8acaabb8c3e4ed61d89cd78ed8f4743aeb9f4ea38a21/customer=6/visitYearMonth=199705/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199706) location 's3://redshift-spectrum-datastore-csv10/a360f314431fa36fbd43b0ae60ed4ee56d981a5c29371f72bdf7ae447c074459/customer=6/visitYearMonth=199706/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199707) location 's3://redshift-spectrum-datastore-csv10/c46b763c67bd4483943d1130f7107d41f537d2d53cc4ee3619867b8f7d34df4f/customer=6/visitYearMonth=199707/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199708) location 's3://redshift-spectrum-datastore-csv10/94383a265dc839d74f1cca65d6c6877a6707c788baab3596a98f1d46ea829346/customer=6/visitYearMonth=199708/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199709) location 's3://redshift-spectrum-datastore-csv10/6a2bc87021698b63fb1b90931610736821778e479593779e3fac0a825cf329b0/customer=6/visitYearMonth=199709/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199710) location 's3://redshift-spectrum-datastore-csv10/f4353788fa53fd2da0738145794a746dfca49359d403e0170140d5da9cd20d5a/customer=6/visitYearMonth=199710/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199711) location 's3://redshift-spectrum-datastore-csv10/7a09b1607028bcbd36b7fd6792b3920a5a8abbe1a568733e3c51bde8e96c9683/customer=6/visitYearMonth=199711/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199712) location 's3://redshift-spectrum-datastore-csv10/826ccbe68e4678a65ab4e3e83bbd544cd0a96e2ef8b766dbc6e30c00f970b1a4/customer=6/visitYearMonth=199712/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199801) location 's3://redshift-spectrum-datastore-csv10/21712a510e99c4c2c4cf55e3cc2e0a3a8048f55618adcea650bad93d642da5ae/customer=6/visitYearMonth=199801/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199802) location 's3://redshift-spectrum-datastore-csv10/5ed063d04029dda1603e535e35bde38443104cb2bac2e3e60f064ab9985566d0/customer=6/visitYearMonth=199802/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199803) location 's3://redshift-spectrum-datastore-csv10/106566eba396cd5cc731296b065dda8861d33352efbc142d25c37c09f08c4bd6/customer=6/visitYearMonth=199803/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199804) location 's3://redshift-spectrum-datastore-csv10/9799d53dbce16bf150842db6556782cf352b51febd15aa698cf39545d172abbf/customer=6/visitYearMonth=199804/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199805) location 's3://redshift-spectrum-datastore-csv10/f265fb77ed371af68fa7b4e73982740e80c6a15b4e9d04a41c3f234b31c1eced/customer=6/visitYearMonth=199805/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199806) location 's3://redshift-spectrum-datastore-csv10/8ead57a1df30dc52d0539d7b936443a5330b526063d63443bd050cf7e5fcda9f/customer=6/visitYearMonth=199806/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199807) location 's3://redshift-spectrum-datastore-csv10/32c78f4b1de4c2152a3f18f5eb2a99f2a921a3ee485dd13fa3807a283b668985/customer=6/visitYearMonth=199807/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199808) location 's3://redshift-spectrum-datastore-csv10/b83da9287db09ad482651f74e173287cae2d5a4f85df8f5dc37d437663685155/customer=6/visitYearMonth=199808/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199809) location 's3://redshift-spectrum-datastore-csv10/7eb74bd5632d64e059eb4f44f8e6ab665090a56172236cfd6b3d1d8880b0a597/customer=6/visitYearMonth=199809/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199810) location 's3://redshift-spectrum-datastore-csv10/0e7bafb8d5a740351c1ed34cc1cced90c3e3ca87cc296e37f33472548e710b9b/customer=6/visitYearMonth=199810/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199811) location 's3://redshift-spectrum-datastore-csv10/cfffa26c1a78a557627e881f9089edc70bef8b69c65ca0486ab9a35d3225c968/customer=6/visitYearMonth=199811/';
alter table clickstream.uservisits_csv10 add partition(customer=6, visitYearMonth=199812) location 's3://redshift-spectrum-datastore-csv10/a3ec09800311f9fa761fb5f009548866c4df46fffd300641c176d3d782b6e7a8/customer=6/visitYearMonth=199812/';