set autocommit=on;

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

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