-
Notifications
You must be signed in to change notification settings - Fork 2
/
RF2.sql
3 lines (3 loc) · 14.2 KB
/
RF2.sql
1
2
3
use tpch;
DELETE FROM LINEITEM WHERE L_ORDERKEY in (1,2,3,4,5,6,7,32,33,34,35,36,37,38,39,64,65,66,67,68,69,70,71,96,97,98,99,100,101,102,103,128,129,130,131,132,133,134,135,160,161,162,163,164,165,166,167,192,193,194,195,196,197,198,199,224,225,226,227,228,229,230,231,256,257,258,259,260,261,262,263,288,289,290,291,292,293,294,295,320,321,322,323,324,325,326,327,352,353,354,355,356,357,358,359,384,385,386,387,388,389,390,391,416,417,418,419,420,421,422,423,448,449,450,451,452,453,454,455,480,481,482,483,484,485,486,487,512,513,514,515,516,517,518,519,544,545,546,547,548,549,550,551,576,577,578,579,580,581,582,583,608,609,610,611,612,613,614,615,640,641,642,643,644,645,646,647,672,673,674,675,676,677,678,679,704,705,706,707,708,709,710,711,736,737,738,739,740,741,742,743,768,769,770,771,772,773,774,775,800,801,802,803,804,805,806,807,832,833,834,835,836,837,838,839,864,865,866,867,868,869,870,871,896,897,898,899,900,901,902,903,928,929,930,931,932,933,934,935,960,961,962,963,964,965,966,967,992,993,994,995,996,997,998,999,1024,1025,1026,1027,1028,1029,1030,1031,1056,1057,1058,1059,1060,1061,1062,1063,1088,1089,1090,1091,1092,1093,1094,1095,1120,1121,1122,1123,1124,1125,1126,1127,1152,1153,1154,1155,1156,1157,1158,1159,1184,1185,1186,1187,1188,1189,1190,1191,1216,1217,1218,1219,1220,1221,1222,1223,1248,1249,1250,1251,1252,1253,1254,1255,1280,1281,1282,1283,1284,1285,1286,1287,1312,1313,1314,1315,1316,1317,1318,1319,1344,1345,1346,1347,1348,1349,1350,1351,1376,1377,1378,1379,1380,1381,1382,1383,1408,1409,1410,1411,1412,1413,1414,1415,1440,1441,1442,1443,1444,1445,1446,1447,1472,1473,1474,1475,1476,1477,1478,1479,1504,1505,1506,1507,1508,1509,1510,1511,1536,1537,1538,1539,1540,1541,1542,1543,1568,1569,1570,1571,1572,1573,1574,1575,1600,1601,1602,1603,1604,1605,1606,1607,1632,1633,1634,1635,1636,1637,1638,1639,1664,1665,1666,1667,1668,1669,1670,1671,1696,1697,1698,1699,1700,1701,1702,1703,1728,1729,1730,1731,1732,1733,1734,1735,1760,1761,1762,1763,1764,1765,1766,1767,1792,1793,1794,1795,1796,1797,1798,1799,1824,1825,1826,1827,1828,1829,1830,1831,1856,1857,1858,1859,1860,1861,1862,1863,1888,1889,1890,1891,1892,1893,1894,1895,1920,1921,1922,1923,1924,1925,1926,1927,1952,1953,1954,1955,1956,1957,1958,1959,1984,1985,1986,1987,1988,1989,1990,1991,2016,2017,2018,2019,2020,2021,2022,2023,2048,2049,2050,2051,2052,2053,2054,2055,2080,2081,2082,2083,2084,2085,2086,2087,2112,2113,2114,2115,2116,2117,2118,2119,2144,2145,2146,2147,2148,2149,2150,2151,2176,2177,2178,2179,2180,2181,2182,2183,2208,2209,2210,2211,2212,2213,2214,2215,2240,2241,2242,2243,2244,2245,2246,2247,2272,2273,2274,2275,2276,2277,2278,2279,2304,2305,2306,2307,2308,2309,2310,2311,2336,2337,2338,2339,2340,2341,2342,2343,2368,2369,2370,2371,2372,2373,2374,2375,2400,2401,2402,2403,2404,2405,2406,2407,2432,2433,2434,2435,2436,2437,2438,2439,2464,2465,2466,2467,2468,2469,2470,2471,2496,2497,2498,2499,2500,2501,2502,2503,2528,2529,2530,2531,2532,2533,2534,2535,2560,2561,2562,2563,2564,2565,2566,2567,2592,2593,2594,2595,2596,2597,2598,2599,2624,2625,2626,2627,2628,2629,2630,2631,2656,2657,2658,2659,2660,2661,2662,2663,2688,2689,2690,2691,2692,2693,2694,2695,2720,2721,2722,2723,2724,2725,2726,2727,2752,2753,2754,2755,2756,2757,2758,2759,2784,2785,2786,2787,2788,2789,2790,2791,2816,2817,2818,2819,2820,2821,2822,2823,2848,2849,2850,2851,2852,2853,2854,2855,2880,2881,2882,2883,2884,2885,2886,2887,2912,2913,2914,2915,2916,2917,2918,2919,2944,2945,2946,2947,2948,2949,2950,2951,2976,2977,2978,2979,2980,2981,2982,2983,3008,3009,3010,3011,3012,3013,3014,3015,3040,3041,3042,3043,3044,3045,3046,3047,3072,3073,3074,3075,3076,3077,3078,3079,3104,3105,3106,3107,3108,3109,3110,3111,3136,3137,3138,3139,3140,3141,3142,3143,3168,3169,3170,3171,3172,3173,3174,3175,3200,3201,3202,3203,3204,3205,3206,3207,3232,3233,3234,3235,3236,3237,3238,3239,3264,3265,3266,3267,3268,3269,3270,3271,3296,3297,3298,3299,3300,3301,3302,3303,3328,3329,3330,3331,3332,3333,3334,3335,3360,3361,3362,3363,3364,3365,3366,3367,3392,3393,3394,3395,3396,3397,3398,3399,3424,3425,3426,3427,3428,3429,3430,3431,3456,3457,3458,3459,3460,3461,3462,3463,3488,3489,3490,3491,3492,3493,3494,3495,3520,3521,3522,3523,3524,3525,3526,3527,3552,3553,3554,3555,3556,3557,3558,3559,3584,3585,3586,3587,3588,3589,3590,3591,3616,3617,3618,3619,3620,3621,3622,3623,3648,3649,3650,3651,3652,3653,3654,3655,3680,3681,3682,3683,3684,3685,3686,3687,3712,3713,3714,3715,3716,3717,3718,3719,3744,3745,3746,3747,3748,3749,3750,3751,3776,3777,3778,3779,3780,3781,3782,3783,3808,3809,3810,3811,3812,3813,3814,3815,3840,3841,3842,3843,3844,3845,3846,3847,3872,3873,3874,3875,3876,3877,3878,3879,3904,3905,3906,3907,3908,3909,3910,3911,3936,3937,3938,3939,3940,3941,3942,3943,3968,3969,3970,3971,3972,3973,3974,3975,4000,4001,4002,4003,4004,4005,4006,4007,4032,4033,4034,4035,4036,4037,4038,4039,4064,4065,4066,4067,4068,4069,4070,4071,4096,4097,4098,4099,4100,4101,4102,4103,4128,4129,4130,4131,4132,4133,4134,4135,4160,4161,4162,4163,4164,4165,4166,4167,4192,4193,4194,4195,4196,4197,4198,4199,4224,4225,4226,4227,4228,4229,4230,4231,4256,4257,4258,4259,4260,4261,4262,4263,4288,4289,4290,4291,4292,4293,4294,4295,4320,4321,4322,4323,4324,4325,4326,4327,4352,4353,4354,4355,4356,4357,4358,4359,4384,4385,4386,4387,4388,4389,4390,4391,4416,4417,4418,4419,4420,4421,4422,4423,4448,4449,4450,4451,4452,4453,4454,4455,4480,4481,4482,4483,4484,4485,4486,4487,4512,4513,4514,4515,4516,4517,4518,4519,4544,4545,4546,4547,4548,4549,4550,4551,4576,4577,4578,4579,4580,4581,4582,4583,4608,4609,4610,4611,4612,4613,4614,4615,4640,4641,4642,4643,4644,4645,4646,4647,4672,4673,4674,4675,4676,4677,4678,4679,4704,4705,4706,4707,4708,4709,4710,4711,4736,4737,4738,4739,4740,4741,4742,4743,4768,4769,4770,4771,4772,4773,4774,4775,4800,4801,4802,4803,4804,4805,4806,4807,4832,4833,4834,4835,4836,4837,4838,4839,4864,4865,4866,4867,4868,4869,4870,4871,4896,4897,4898,4899,4900,4901,4902,4903,4928,4929,4930,4931,4932,4933,4934,4935,4960,4961,4962,4963,4964,4965,4966,4967,4992,4993,4994,4995,4996,4997,4998,4999,5024,5025,5026,5027,5028,5029,5030,5031,5056,5057,5058,5059,5060,5061,5062,5063,5088,5089,5090,5091,5092,5093,5094,5095,5120,5121,5122,5123,5124,5125,5126,5127,5152,5153,5154,5155,5156,5157,5158,5159,5184,5185,5186,5187,5188,5189,5190,5191,5216,5217,5218,5219,5220,5221,5222,5223,5248,5249,5250,5251,5252,5253,5254,5255,5280,5281,5282,5283,5284,5285,5286,5287,5312,5313,5314,5315,5316,5317,5318,5319,5344,5345,5346,5347,5348,5349,5350,5351,5376,5377,5378,5379,5380,5381,5382,5383,5408,5409,5410,5411,5412,5413,5414,5415,5440,5441,5442,5443,5444,5445,5446,5447,5472,5473,5474,5475,5476,5477,5478,5479,5504,5505,5506,5507,5508,5509,5510,5511,5536,5537,5538,5539,5540,5541,5542,5543,5568,5569,5570,5571,5572,5573,5574,5575,5600,5601,5602,5603,5604,5605,5606,5607,5632,5633,5634,5635,5636,5637,5638,5639,5664,5665,5666,5667,5668,5669,5670,5671,5696,5697,5698,5699,5700,5701,5702,5703,5728,5729,5730,5731,5732,5733,5734,5735,5760,5761,5762,5763,5764,5765,5766,5767,5792,5793,5794,5795,5796,5797,5798,5799,5824,5825,5826,5827,5828,5829,5830,5831,5856,5857,5858,5859,5860,5861,5862,5863,5888,5889,5890,5891,5892,5893,5894,5895,5920,5921,5922,5923,5924,5925,5926,5927,5952,5953,5954,5955,5956,5957,5958,5959,5984,5985,5986,5987,5988);
DELETE FROM ORDERS WHERE O_ORDERKEY in (1,2,3,4,5,6,7,32,33,34,35,36,37,38,39,64,65,66,67,68,69,70,71,96,97,98,99,100,101,102,103,128,129,130,131,132,133,134,135,160,161,162,163,164,165,166,167,192,193,194,195,196,197,198,199,224,225,226,227,228,229,230,231,256,257,258,259,260,261,262,263,288,289,290,291,292,293,294,295,320,321,322,323,324,325,326,327,352,353,354,355,356,357,358,359,384,385,386,387,388,389,390,391,416,417,418,419,420,421,422,423,448,449,450,451,452,453,454,455,480,481,482,483,484,485,486,487,512,513,514,515,516,517,518,519,544,545,546,547,548,549,550,551,576,577,578,579,580,581,582,583,608,609,610,611,612,613,614,615,640,641,642,643,644,645,646,647,672,673,674,675,676,677,678,679,704,705,706,707,708,709,710,711,736,737,738,739,740,741,742,743,768,769,770,771,772,773,774,775,800,801,802,803,804,805,806,807,832,833,834,835,836,837,838,839,864,865,866,867,868,869,870,871,896,897,898,899,900,901,902,903,928,929,930,931,932,933,934,935,960,961,962,963,964,965,966,967,992,993,994,995,996,997,998,999,1024,1025,1026,1027,1028,1029,1030,1031,1056,1057,1058,1059,1060,1061,1062,1063,1088,1089,1090,1091,1092,1093,1094,1095,1120,1121,1122,1123,1124,1125,1126,1127,1152,1153,1154,1155,1156,1157,1158,1159,1184,1185,1186,1187,1188,1189,1190,1191,1216,1217,1218,1219,1220,1221,1222,1223,1248,1249,1250,1251,1252,1253,1254,1255,1280,1281,1282,1283,1284,1285,1286,1287,1312,1313,1314,1315,1316,1317,1318,1319,1344,1345,1346,1347,1348,1349,1350,1351,1376,1377,1378,1379,1380,1381,1382,1383,1408,1409,1410,1411,1412,1413,1414,1415,1440,1441,1442,1443,1444,1445,1446,1447,1472,1473,1474,1475,1476,1477,1478,1479,1504,1505,1506,1507,1508,1509,1510,1511,1536,1537,1538,1539,1540,1541,1542,1543,1568,1569,1570,1571,1572,1573,1574,1575,1600,1601,1602,1603,1604,1605,1606,1607,1632,1633,1634,1635,1636,1637,1638,1639,1664,1665,1666,1667,1668,1669,1670,1671,1696,1697,1698,1699,1700,1701,1702,1703,1728,1729,1730,1731,1732,1733,1734,1735,1760,1761,1762,1763,1764,1765,1766,1767,1792,1793,1794,1795,1796,1797,1798,1799,1824,1825,1826,1827,1828,1829,1830,1831,1856,1857,1858,1859,1860,1861,1862,1863,1888,1889,1890,1891,1892,1893,1894,1895,1920,1921,1922,1923,1924,1925,1926,1927,1952,1953,1954,1955,1956,1957,1958,1959,1984,1985,1986,1987,1988,1989,1990,1991,2016,2017,2018,2019,2020,2021,2022,2023,2048,2049,2050,2051,2052,2053,2054,2055,2080,2081,2082,2083,2084,2085,2086,2087,2112,2113,2114,2115,2116,2117,2118,2119,2144,2145,2146,2147,2148,2149,2150,2151,2176,2177,2178,2179,2180,2181,2182,2183,2208,2209,2210,2211,2212,2213,2214,2215,2240,2241,2242,2243,2244,2245,2246,2247,2272,2273,2274,2275,2276,2277,2278,2279,2304,2305,2306,2307,2308,2309,2310,2311,2336,2337,2338,2339,2340,2341,2342,2343,2368,2369,2370,2371,2372,2373,2374,2375,2400,2401,2402,2403,2404,2405,2406,2407,2432,2433,2434,2435,2436,2437,2438,2439,2464,2465,2466,2467,2468,2469,2470,2471,2496,2497,2498,2499,2500,2501,2502,2503,2528,2529,2530,2531,2532,2533,2534,2535,2560,2561,2562,2563,2564,2565,2566,2567,2592,2593,2594,2595,2596,2597,2598,2599,2624,2625,2626,2627,2628,2629,2630,2631,2656,2657,2658,2659,2660,2661,2662,2663,2688,2689,2690,2691,2692,2693,2694,2695,2720,2721,2722,2723,2724,2725,2726,2727,2752,2753,2754,2755,2756,2757,2758,2759,2784,2785,2786,2787,2788,2789,2790,2791,2816,2817,2818,2819,2820,2821,2822,2823,2848,2849,2850,2851,2852,2853,2854,2855,2880,2881,2882,2883,2884,2885,2886,2887,2912,2913,2914,2915,2916,2917,2918,2919,2944,2945,2946,2947,2948,2949,2950,2951,2976,2977,2978,2979,2980,2981,2982,2983,3008,3009,3010,3011,3012,3013,3014,3015,3040,3041,3042,3043,3044,3045,3046,3047,3072,3073,3074,3075,3076,3077,3078,3079,3104,3105,3106,3107,3108,3109,3110,3111,3136,3137,3138,3139,3140,3141,3142,3143,3168,3169,3170,3171,3172,3173,3174,3175,3200,3201,3202,3203,3204,3205,3206,3207,3232,3233,3234,3235,3236,3237,3238,3239,3264,3265,3266,3267,3268,3269,3270,3271,3296,3297,3298,3299,3300,3301,3302,3303,3328,3329,3330,3331,3332,3333,3334,3335,3360,3361,3362,3363,3364,3365,3366,3367,3392,3393,3394,3395,3396,3397,3398,3399,3424,3425,3426,3427,3428,3429,3430,3431,3456,3457,3458,3459,3460,3461,3462,3463,3488,3489,3490,3491,3492,3493,3494,3495,3520,3521,3522,3523,3524,3525,3526,3527,3552,3553,3554,3555,3556,3557,3558,3559,3584,3585,3586,3587,3588,3589,3590,3591,3616,3617,3618,3619,3620,3621,3622,3623,3648,3649,3650,3651,3652,3653,3654,3655,3680,3681,3682,3683,3684,3685,3686,3687,3712,3713,3714,3715,3716,3717,3718,3719,3744,3745,3746,3747,3748,3749,3750,3751,3776,3777,3778,3779,3780,3781,3782,3783,3808,3809,3810,3811,3812,3813,3814,3815,3840,3841,3842,3843,3844,3845,3846,3847,3872,3873,3874,3875,3876,3877,3878,3879,3904,3905,3906,3907,3908,3909,3910,3911,3936,3937,3938,3939,3940,3941,3942,3943,3968,3969,3970,3971,3972,3973,3974,3975,4000,4001,4002,4003,4004,4005,4006,4007,4032,4033,4034,4035,4036,4037,4038,4039,4064,4065,4066,4067,4068,4069,4070,4071,4096,4097,4098,4099,4100,4101,4102,4103,4128,4129,4130,4131,4132,4133,4134,4135,4160,4161,4162,4163,4164,4165,4166,4167,4192,4193,4194,4195,4196,4197,4198,4199,4224,4225,4226,4227,4228,4229,4230,4231,4256,4257,4258,4259,4260,4261,4262,4263,4288,4289,4290,4291,4292,4293,4294,4295,4320,4321,4322,4323,4324,4325,4326,4327,4352,4353,4354,4355,4356,4357,4358,4359,4384,4385,4386,4387,4388,4389,4390,4391,4416,4417,4418,4419,4420,4421,4422,4423,4448,4449,4450,4451,4452,4453,4454,4455,4480,4481,4482,4483,4484,4485,4486,4487,4512,4513,4514,4515,4516,4517,4518,4519,4544,4545,4546,4547,4548,4549,4550,4551,4576,4577,4578,4579,4580,4581,4582,4583,4608,4609,4610,4611,4612,4613,4614,4615,4640,4641,4642,4643,4644,4645,4646,4647,4672,4673,4674,4675,4676,4677,4678,4679,4704,4705,4706,4707,4708,4709,4710,4711,4736,4737,4738,4739,4740,4741,4742,4743,4768,4769,4770,4771,4772,4773,4774,4775,4800,4801,4802,4803,4804,4805,4806,4807,4832,4833,4834,4835,4836,4837,4838,4839,4864,4865,4866,4867,4868,4869,4870,4871,4896,4897,4898,4899,4900,4901,4902,4903,4928,4929,4930,4931,4932,4933,4934,4935,4960,4961,4962,4963,4964,4965,4966,4967,4992,4993,4994,4995,4996,4997,4998,4999,5024,5025,5026,5027,5028,5029,5030,5031,5056,5057,5058,5059,5060,5061,5062,5063,5088,5089,5090,5091,5092,5093,5094,5095,5120,5121,5122,5123,5124,5125,5126,5127,5152,5153,5154,5155,5156,5157,5158,5159,5184,5185,5186,5187,5188,5189,5190,5191,5216,5217,5218,5219,5220,5221,5222,5223,5248,5249,5250,5251,5252,5253,5254,5255,5280,5281,5282,5283,5284,5285,5286,5287,5312,5313,5314,5315,5316,5317,5318,5319,5344,5345,5346,5347,5348,5349,5350,5351,5376,5377,5378,5379,5380,5381,5382,5383,5408,5409,5410,5411,5412,5413,5414,5415,5440,5441,5442,5443,5444,5445,5446,5447,5472,5473,5474,5475,5476,5477,5478,5479,5504,5505,5506,5507,5508,5509,5510,5511,5536,5537,5538,5539,5540,5541,5542,5543,5568,5569,5570,5571,5572,5573,5574,5575,5600,5601,5602,5603,5604,5605,5606,5607,5632,5633,5634,5635,5636,5637,5638,5639,5664,5665,5666,5667,5668,5669,5670,5671,5696,5697,5698,5699,5700,5701,5702,5703,5728,5729,5730,5731,5732,5733,5734,5735,5760,5761,5762,5763,5764,5765,5766,5767,5792,5793,5794,5795,5796,5797,5798,5799,5824,5825,5826,5827,5828,5829,5830,5831,5856,5857,5858,5859,5860,5861,5862,5863,5888,5889,5890,5891,5892,5893,5894,5895,5920,5921,5922,5923,5924,5925,5926,5927,5952,5953,5954,5955,5956,5957,5958,5959,5984,5985,5986,5987,5988);