-
Notifications
You must be signed in to change notification settings - Fork 2
Expand file tree
/
Copy pathcreate_sql.py
More file actions
71 lines (57 loc) · 57.9 KB
/
Copy pathcreate_sql.py
File metadata and controls
71 lines (57 loc) · 57.9 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
from sqlalchemy import create_engine, text
from sqlalchemy.orm import sessionmaker
def run():
db_name = "a"
org_tbl_name = "7b_input_embedding"
org_tbl_sk_name = "embedding"
org_tbl_pk_name = "__mo_fake_pk_col"
original_tbl_vec_idx_name = "idx1"
input_vector_val = "[0.014953613, 0.002029419, 0.0010528564, 0.019042969, -0.0023345947, 0.0035552979, -0.0039367676, -0.013000488, -0.0025939941, -0.000579834, -0.0059509277, -0.028076172, -0.02355957, -0.0022277832, -0.018188477, 0.008239746, 0.006591797, -0.01550293, -0.020996094, -0.0107421875, 0.028930664, 0.008544922, 0.030761719, 0.016113281, 0.014404297, 0.0051574707, -0.0029907227, 0.0026245117, 0.026489258, 0.0040893555, -0.022338867, -0.0038909912, -0.005340576, 0.0042419434, 0.00793457, -0.009338379, -0.0019226074, -0.025878906, -0.012268066, -0.026855469, 0.00078201294, -0.0115356445, 0.032958984, -0.014953613, -0.0059814453, -0.021484375, 0.0014572144, 0.004638672, -0.036376953, 0.01574707, -0.04296875, 0.008728027, -0.025268555, 0.0119018555, -0.013977051, -0.036132812, -0.013916016, 0.029785156, -0.017333984, -0.030151367, -0.0065307617, -0.020263672, -0.009277344, 0.013305664, -0.022460938, 0.0015563965, 0.010498047, 0.010192871, 0.040283203, -0.041503906, 0.025756836, -0.016845703, -0.052001953, 0.0016708374, 0.027832031, 0.015258789, -0.020874023, 0.007080078, -0.008483887, -0.011962891, -0.0018463135, 0.023071289, 0.0027618408, -0.00014400482, -0.016235352, 0.0064086914, -0.011352539, 0.005493164, -0.014831543, -0.025146484, 0.021850586, 0.007507324, 0.012268066, 0.0099487305, -0.0020446777, -0.004486084, 0.032958984, -0.006164551, -0.022949219, 0.0058288574, -0.016601562, -0.010009766, 0.049316406, 0.008300781, 0.012817383, 0.011047363, 0.012451172, 0.018676758, 0.0005722046, -0.020141602, -0.014587402, -0.016479492, 0.014587402, 0.010314941, -0.0029449463, -0.016357422, -0.0138549805, -0.026733398, -0.015991211, 0.00059890747, 0.0074768066, -0.0043029785, 0.024536133, 0.014709473, 0.009216309, -0.0056152344, -0.01373291, -0.0059814453, -0.015563965, 0.0015106201, -0.009460449, -0.0079956055, -0.015319824, -0.01928711, 0.012207031, -0.0011978149, -0.024658203, 0.016235352, 0.018066406, -0.0034637451, -0.015625, 0.048828125, 0.004638672, 0.017089844, 0.01977539, 0.040527344, -0.018066406, 0.0061035156, 0.008666992, 0.016113281, 0.006164551, 0.026245117, 0.010559082, -0.011474609, -0.009277344, 0.0009651184, 0.007598877, -0.011047363, 0.026000977, -0.030639648, 0.017089844, -0.014465332, -0.03564453, 0.023925781, 0.0060424805, -0.008911133, 0.010498047, -0.015380859, 0.01928711, -0.021240234, 0.023925781, 0.0056152344, -0.020019531, 0.0044555664, 0.016357422, -0.0032806396, 0.002166748, 0.018188477, 0.028686523, 0.018676758, -0.00390625, 0.0014038086, -0.008850098, 0.036865234, -0.003753662, 0.020996094, 0.037353516, 0.041748047, 0.008056641, -0.028076172, -0.0069274902, 0.010620117, 0.017456055, 0.026611328, 0.012268066, 0.0015640259, 0.0021820068, -0.037353516, 0.006439209, 0.016357422, 0.010070801, 0.0033874512, -0.036865234, 0.030761719, 0.017456055, 0.022216797, 0.010192871, 0.0043945312, -0.0390625, -0.0019989014, 0.030029297, -0.0065307617, -0.004211426, 0.0015106201, 0.024658203, -0.009399414, 0.009155273, 0.016967773, -0.012145996, -0.0134887695, -0.018310547, 0.013061523, -0.0071105957, 0.03540039, 0.006011963, 0.0077209473, 0.0015029907, 0.0015945435, 0.040527344, -0.022583008, 0.0099487305, -0.00982666, 0.022460938, 0.009338379, -0.0050964355, -0.0068969727, -0.012939453, 0.00006532669, -0.015075684, 0.01940918, 0.001335144, -0.01184082, -0.012573242, -0.0011901855, 0.011047363, 0.024902344, -0.020874023, -0.013549805, -0.023071289, 0.03100586, -0.00076293945, 0.032714844, 0.009216309, 0.0078125, -0.010864258, 0.015014648, -0.004333496, 0.006378174, -0.02355957, -0.009216309, -0.009338379, -0.0074157715, 0.011047363, 0.011169434, 0.008728027, -0.00793457, -0.010009766, 0.025268555, 0.010498047, -0.003189087, 0.017333984, 0.0046081543, 0.007232666, -0.037353516, 0.005340576, 0.0076904297, -0.0107421875, 0.025390625, -0.0115356445, 0.025024414, 0.02722168, 0.015136719, -0.017333984, -0.02722168, 0.005859375, 0.006713867, 0.009094238, -0.011291504, -0.0065307617, -0.018554688, -0.0019836426, -0.01977539, -0.01940918, -0.0069885254, -0.024536133, -0.0053100586, 0.011474609, -0.037841797, -0.024902344, -0.0146484375, -0.011047363, -0.017700195, 0.028198242, 0.0107421875, 0.023071289, 0.0040283203, -0.010009766, -0.0119018555, 0.016845703, -0.009460449, -0.010864258, -0.009399414, -0.006713867, 0.003112793, 0.01953125, 0.015380859, -0.015014648, -0.010864258, -0.005279541, 0.02368164, -0.020019531, 0.004272461, -0.017456055, -0.0022583008, 0.008361816, 0.014404297, 0.048828125, -0.0001449585, 0.0060424805, -0.0025787354, 0.022827148, -0.01550293, 0.017333984, 0.027954102, 0.0033874512, -0.01361084, -0.0058898926, 0.012573242, -0.016479492, -0.0048217773, -0.024047852, 0.041748047, -0.0052490234, -0.016967773, 0.015258789, 0.02758789, -0.006652832, 0.0025482178, 0.012451172, 0.031982422, 0.004852295, -0.0015563965, -0.024169922, -0.030029297, 0.0017166138, -0.044677734, 0.008972168, 0.02709961, 0.029541016, 0.018554688, -0.012329102, 0.002243042, 0.0002632141, -0.011474609, -0.013671875, 0.00579834, -0.0038146973, -0.025268555, 0.009277344, -0.013000488, 0.026977539, -0.020874023, -0.033935547, -0.020751953, 0.026245117, 0.032470703, 0.01940918, -0.012390137, 0.0032043457, -0.012145996, 0.001625061, -0.009155273, -0.026245117, -0.007385254, -0.0016098022, 0.009460449, 0.0017623901, -0.02722168, -0.02734375, 0.020751953, 0.017822266, -0.0022735596, 0.0095825195, -0.012390137, 0.0020599365, -0.0016326904, -0.006225586, -0.013122559, -0.0026855469, 0.008239746, -0.005432129, 0.016479492, -0.009643555, 0.0012054443, -0.019165039, 0.01928711, -0.013671875, 0.013061523, 0.0026550293, 0.0040283203, 0.00390625, -0.004638672, -0.0099487305, 0.0022125244, 0.053710938, -0.0039367676, 0.01361084, 0.007080078, -0.0045776367, 0.006866455, -0.011962891, 0.016601562, -0.01574707, 0.00390625, 0.002746582, 0.020629883, 0.01171875, -0.018188477, -0.022094727, -0.004272461, -0.010192871, 0.024658203, -0.01965332, 0.008422852, 0.004486084, 0.024658203, -0.013366699, 0.010620117, -0.0071411133, -0.021606445, 0.024169922, 0.012573242, 0.012145996, 0.0005950928, -0.011169434, -0.014892578, 0.005126953, 0.0073242188, -0.017089844, -0.012512207, 0.022705078, -0.018188477, 0.0043029785, -0.010864258, 0.0021362305, -0.02355957, 0.021240234, 0.018066406, -0.017089844, 0.013366699, -0.018432617, -0.0029296875, -0.00048065186, -0.0070495605, 0.022583008, -0.01965332, 0.008972168, 0.0234375, -0.010559082, 0.0234375, 0.008605957, -0.00074768066, 0.016723633, 0.016479492, -0.0025177002, 0.0021514893, -0.014343262, -0.020019531, -0.0036621094, 0.029418945, -0.0045166016, 0.03125, 0.0077819824, 0.0047302246, -0.032226562, -0.024291992, -0.016357422, -0.010131836, 0.03881836, 0.004058838, 0.0052490234, 0.011413574, -0.024902344, 0.018554688, -0.022216797, 0.016967773, 0.005493164, 0.011474609, -0.0059509277, -0.01965332, -0.029907227, -0.0033569336, 0.0015716553, -0.005493164, -0.028198242, 0.01574707, 0.006652832, -0.018310547, -0.018432617, 0.0009765625, -0.029663086, 0.0022277832, 0.008728027, -0.00048828125, 0.030517578, -0.032470703, 0.0067749023, 0.012329102, 0.03491211, -0.012512207, 0.029785156, -0.014465332, -0.010314941, -0.0021514893, -0.0107421875, -0.0034942627, -0.009399414, -0.014892578, -0.0026397705, 0.008544922, 0.0015945435, -0.001373291, 0.003768921, -0.0039367676, 0.024658203, 0.020263672, -0.004547119, -0.001953125, -0.015136719, 0.008056641, 0.012329102, 0.025878906, 0.018920898, -0.017578125, 0.0074768066, 0.003036499, 0.02331543, -0.014160156, 0.015380859, -0.027709961, -0.020996094, -0.003967285, -0.0009651184, -0.02331543, -0.03491211, -0.03100586, -0.015075684, 0.0078125, 0.000057697296, 0.016723633, 0.009094238, 0.0007133484, -0.0012588501, 0.007873535, 0.0030670166, 0.0063171387, 0.036132812, -0.014038086, -0.021850586, -0.044433594, 0.004058838, -0.012451172, -0.001449585, 0.0077209473, 0.02368164, -0.001625061, 0.0065307617, -0.013977051, -0.0017623901, -0.012145996, -0.005645752, 0.012878418, -0.008300781, -0.009033203, -0.00014400482, -0.009765625, -0.026855469, 0.021240234, 0.006072998, 0.011047363, 0.032470703, -0.024780273, -0.020141602, 0.002822876, 0.00033569336, 0.0031433105, -0.0057678223, -0.033203125, 0.0001373291, 0.012084961, -0.024047852, -0.000579834, 0.012512207, -0.0022125244, 0.003753662, -0.03491211, -0.0054016113, 0.021484375, -0.020263672, -0.006866455, -0.02722168, 0.033203125, 0.0025787354, -0.0032806396, 0.033447266, -0.017211914, 0.005432129, -0.041259766, -0.010009766, -0.0051574707, 0.025512695, 0.0029144287, -0.011047363, 0.014770508, -0.05053711, -0.003967285, -0.047851562, -0.002746582, -0.0047302246, 0.021728516, -0.0012741089, -0.0054016113, 0.015197754, 0.008361816, 0.0071105957, 0.0025177002, -0.012329102, -0.0040283203, 0.0019454956, -0.005859375, -0.015625, -0.0039978027, 0.0040283203, 0.008728027, -0.021728516, 0.013793945, -0.01965332, -0.007293701, -0.012207031, -0.029052734, -0.003967285, -0.008666992, 0.00020503998, -0.025634766, 0.013122559, -0.024658203, 0.012939453, -0.0007362366, -0.0053100586, 0.0063476562, -0.024902344, -0.030151367, 0.010681152, -0.024536133, -0.01361084, -0.021484375, 0.0072631836, 0.020507812, 0.0072021484, -0.0010757446, 0.0010299683, -0.0035247803, 0.020996094, -0.020629883, 0.022583008, 0.0072021484, -0.0012817383, -0.020141602, -0.0014648438, 0.021118164, 0.011169434, -0.021362305, -0.007873535, -0.01977539, 0.014770508, 0.0039978027, -0.0018310547, -0.00289917, -0.022338867, -0.0038604736, 0.028076172, -0.010986328, 0.008911133, 0.0030059814, 0.014770508, 0.014892578, -0.0072631836, 0.005645752, -0.025146484, 0.004180908, 0.0036773682, -0.015197754, -0.024414062, 0.028564453, 0.014709473, -0.0024414062, -0.0033721924, 0.0049743652, 0.034423828, 0.011779785, -0.004180908, 0.016479492, -0.016967773, -0.008422852, 0.010253906, 0.016479492, 0.009399414, 0.0002861023, -0.037353516, 0.009094238, 0.004272461, -0.015136719, -0.0010910034, 0.0036621094, -0.013916016, 0.020019531, -0.006164551, 0.00491333, -0.018432617, 0.013305664, 0.020996094, 0.014831543, 0.025512695, 0.0077209473, 0.01574707, 0.02319336, -0.026977539, -0.0022583008, -0.029418945, 0.0036315918, 0.0031433105, 0.026245117, 0.008178711, -0.009277344, 0.008605957, 0.0027770996, 0.013977051, 0.017700195, -0.016967773, -0.022094727, 0.010009766, -0.0025634766, 0.028808594, 0.0009765625, -0.008178711, -0.010009766, 0.0048828125, 0.0034942627, -0.010375977, -0.048095703, -0.01184082, 0.029663086, -0.03125, 0.0146484375, -0.008666992, 0.0138549805, -0.018554688, 0.0095825195, -0.025268555, 0.0015487671, 0.019042969, 0.016113281, -0.012817383, -0.0003643036, -0.0087890625, 0.008178711, -0.03125, -0.020141602, -0.018920898, -0.0045776367, 0.017944336, -0.010986328, 0.009094238, -0.0066223145, -0.014343262, 0.0028076172, -0.004852295, 0.00970459, -0.019042969, -0.0016021729, 0.022338867, -0.022094727, 0.0068359375, 0.004547119, -0.0027008057, 0.0060424805, 0.002166748, -0.0052490234, -0.008056641, 0.0134887695, -0.003479004, -0.004547119, 0.0027618408, 0.004852295, 0.022949219, 0.004119873, 0.016113281, -0.0046691895, 0.0079956055, 0.015197754, -0.003479004, -0.03100586, -0.03173828, -0.005432129, -0.009338379, 0.013061523, -0.026123047, 0.024902344, 0.013000488, 0.009155273, -0.014770508, 0.015258789, -0.01953125, -0.022216797, 0.003250122, 0.014404297, -0.005859375, -0.010498047, -0.028198242, -0.010620117, -0.0005950928, -0.010314941, -0.022949219, -0.015625, 0.026733398, 0.0013580322, 0.018798828, -0.018798828, -0.019165039, 0.026733398, 0.00982666, -0.0067443848, 0.00793457, 0.009643555, -0.0045166016, -0.020141602, 0.0022735596, -0.003829956, 0.0073242188, -0.0026245117, 0.0022888184, -0.0008125305, 0.0015716553, 0.010314941, -0.0027313232, -0.017211914, -0.020263672, -0.00015354156, 0.016479492, -0.015991211, 0.0051574707, -0.0045776367, 0.026489258, -0.009338379, 0.03100586, 0.03491211, -0.041015625, 0.020996094, -0.004180908, -0.01977539, 0.026489258, -0.012878418, 0.01373291, -0.03564453, -0.014709473, -0.011657715, 0.029785156, 0.0009765625, 0.020996094, 0.020507812, 0.016723633, -0.010803223, 0.01574707, 0.026245117, 0.012145996, -0.00042533875, 0.010498047, 0.020385742, -0.0027923584, -0.0011520386, -0.007873535, 0.013366699, 0.012329102, -0.038330078, 0.0054016113, -0.008056641, -0.010864258, 0.020019531, 0.041259766, 0.0048217773, 0.008300781, -0.026245117, 0.005859375, 0.009887695, 0.011413574, -0.012329102, 0.0058898926, 0.009521484, -0.0021362305, -0.014953613, 0.012145996, -0.0009651184, -0.00579834, -0.040039062, -0.025268555, 0.021850586, -0.033691406, -0.006866455, 0.012939453, -0.010070801, 0.021118164, -0.031982422, 0.007751465, 0.028198242, -0.024780273, -0.018554688, -0.012329102, -0.023071289, 0.0018463135, 0.0015106201, -0.02319336, 0.017089844, -0.00680542, -0.003967285, -0.012329102, 0.013549805, -0.018432617, -0.018432617, -0.0018615723, 0.004638672, 0.011962891, 0.010986328, 0.0048217773, 0.011291504, -0.012451172, -0.03125, -0.013183594, -0.012512207, 0.010070801, -0.00062179565, 0.0031433105, 0.031982422, 0.011108398, 0.017089844, 0.0071411133, -0.009216309, 0.011169434, -0.02368164, -0.000034332275, 0.007232666, -0.03112793, -0.022827148, 0.014099121, -0.07421875, -0.008361816, -0.003540039, 0.014221191, -0.01928711, 0.010864258, -0.009460449, 0.025634766, -0.017700195, 0.033203125, -0.0032348633, 0.0016937256, 0.013061523, 0.01940918, 0.0015182495, 0.004547119, -0.0010147095, 0.0059814453, -0.015319824, -0.0025939941, 0.009277344, -0.014831543, -0.033691406, 0.007232666, 0.020751953, 0.012573242, 0.00970459, 0.042236328, 0.0058898926, -0.0046691895, -0.0019683838, -0.016113281, 0.021484375, -0.010559082, 0.024902344, 0.0015182495, 0.0020751953, 0.0013046265, -0.0018615723, -0.018310547, 0.03564453, 0.016601562, -0.0074157715, -0.025878906, -0.014160156, -0.0010910034, 0.01965332, -0.0049743652, -0.004638672, -0.024291992, -0.013671875, 0.030151367, 0.0051574707, -0.032958984, -0.021118164, -0.010070801, 0.036132812, -0.005859375, 0.01574707, 0.005004883, -0.041015625, 0.00016212463, -0.022094727, -0.01373291, 0.0045776367, 0.013122559, 0.005126953, 0.011962891, -0.01171875, -0.022216797, 0.010375977, -0.0040893555, 0.0099487305, -0.017211914, 0.017211914, -0.007232666, -0.021118164, -0.0012054443, 0.010925293, 0.008422852, -0.0013198853, -0.018310547, 0.007659912, 0.013916016, -0.019897461, 0.010009766, -0.013977051, -0.045166016, 0.020751953, 0.011291504, -0.00592041, 0.0024871826, -0.018920898, -0.005340576, 0.032470703, 0.014831543, 0.0014343262, 0.0017623901, 0.006164551, -0.000015079975, 0.009643555, -0.01928711, 0.010986328, 0.021606445, 0.010559082, 0.024169922, 0.019897461, 0.0046081543, -0.01586914, 0.0010299683, -0.016235352, -0.0031738281, -0.010864258, -0.017700195, 0.0035247803, -0.004638672, 0.014038086, 0.015625, -0.0019226074, -0.017333984, -0.005859375, -0.018432617, -0.0025024414, 0.012207031, -0.025024414, 0.005004883, -0.0078125, 0.011657715, -0.0032196045, 0.021362305, -0.018066406, -0.011230469, -0.018188477, -0.008422852, -0.0032196045, 0.01361084, 0.019165039, 0.024902344, 0.0031738281, -0.0095825195, 0.006591797, 0.016357422, -0.038330078, -0.010925293, -0.02331543, -0.009277344, 0.020019531, 0.03149414, 0.010192871, -0.016235352, 0.017944336, -0.0034942627, 0.037841797, -0.0014724731, 0.0032043457, -0.0077209473, -0.010681152, -0.028686523, 0.014953613, -0.0054626465, -0.005004883, -0.010131836, -0.003967285, -0.03173828, 0.005340576, 0.020996094, -0.004852295, 0.011230469, 0.0016021729, 0.010375977, -0.0020599365, -0.03173828, -0.0020446777, 0.009643555, 0.002380371, 0.009643555, -0.0050964355, 0.028076172, 0.021118164, 0.012817383, 0.006286621, 0.03100586, 0.011352539, 0.0046081543, 0.011413574, 0.008178711, -0.022094727, 0.019897461, 0.025024414, -0.016357422, 0.0068969727, -0.014709473, -0.015625, 0.025756836, -0.0053710938, -0.008117676, -0.01373291, 0.00024223328, 0.022338867, -0.030761719, -0.021606445, 0.018066406, 0.032714844, 0.021606445, -0.007873535, 0.006072998, -0.0119018555, 0.015136719, -0.0031280518, -0.0107421875, 0.0037841797, 0.01977539, 0.01184082, -0.0027770996, 0.016723633, 0.0016174316, 0.029785156, 0.0064086914, 0.020141602, -0.008972168, 0.022094727, -0.0107421875, -0.0043945312, -0.017578125, 0.007171631, 0.01184082, 0.020629883, -0.020263672, 0.03100586, -0.009155273, -0.041992188, 0.01586914, -0.0033874512, -0.0035858154, -0.011291504, 0.023071289, -0.0004081726, -0.021362305, 0.022460938, 0.023803711, 0.028808594, 0.00016212463, -0.049560547, 0.016601562, 0.027709961, -0.0016174316, -0.025512695, 0.0024871826, -0.007598877, 0.017211914, 0.0006942749, -0.017333984, -0.0023651123, -0.010375977, -0.012084961, -0.020996094, 0.0134887695, -0.0115356445, 0.025512695, 0.0059814453, 0.00970459, 0.028930664, 0.004211426, 0.017700195, 0.029052734, -0.051513672, -0.025634766, -0.03955078, -0.012878418, 0.008728027, -0.010864258, -0.04711914, 0.00093078613, 0.012756348, -0.008728027, -0.0154418945, 0.0071411133, 0.0057373047, -0.0058288574, -0.006866455, 0.021118164, 0.021972656, -0.0066223145, -0.017333984, 0.006164551, -0.015625, 0.0019989014, 0.022705078, -0.010375977, 0.032958984, -0.00390625, -0.00680542, 0.010131836, 0.023071289, -0.02722168, -0.0060424805, 0.001953125, -0.0115356445, -0.0007019043, 0.012268066, -0.022216797, 0.0019226074, 0.02355957, -0.010375977, 0.024536133, 0.020751953, -0.00016307831, -0.0042419434, -0.0014038086, 0.011474609, -0.003967285, -0.0051879883, 0.010681152, 0.011779785, -0.023803711, -0.027709961, 0.005126953, 0.0069885254, -0.014770508, 0.006591797, -0.017456055, -0.0039978027, -0.007598877, 0.01977539, 0.012756348, -0.026245117, -0.0018386841, -0.0076904297, -0.0043029785, 0.00060653687, 0.024169922, 0.00026130676, 0.0018234253, -0.02746582, 0.008544922, 0.003326416, 0.025634766, -0.0038909912, -0.022583008, -0.027709961, -0.004333496, 0.0146484375, 0.003112793, -0.002822876, -0.020019531, -0.005126953, -0.018188477, 0.022827148, -0.008911133, -0.002243042, -0.022705078, 0.040527344, 0.016601562, 0.024047852, -0.007446289, 0.034179688, -0.0011520386, 0.0029754639, -0.002166748, 0.012329102, -0.0027770996, 0.03564453, -0.0063171387, 0.010314941, -0.022338867, 0.0087890625, 0.014709473, 0.020629883, -0.011291504, -0.004852295, 0.001121521, 0.013122559, 0.0007324219, -0.036132812, -0.045654297, 0.000869751, 0.01940918, -0.008056641, -0.001701355, 0.0073242188, -0.01940918, -0.0043945312, -0.018188477, 0.0007171631, -0.0034179688, -0.003967285, -0.008850098, -0.013916016, 0.037597656, -0.009094238, 0.007385254, -0.028076172, -0.006958008, 0.036132812, 0.014343262, -0.008605957, -0.023803711, -0.026123047, -0.00002026558, -0.02709961, -0.030639648, 0.0107421875, -0.0119018555, -0.017333984, -0.034423828, -0.024291992, -0.013366699, -0.001739502, 0.008422852, -0.027832031, -0.002105713, 0.017944336, -0.0087890625, -0.012207031, -0.033935547, -0.00390625, -0.026367188, -0.006164551, -0.029663086, -0.017700195, 0.01586914, 0.011779785, -0.0012435913, -0.01373291, 0.004333496, 0.00970459, -0.005279541, -0.0061035156, -0.014282227, -0.0077819824, -0.034179688, -0.00289917, -0.020629883, -0.011779785, -0.017700195, 0.028686523, 0.015319824, -0.008483887, 0.018554688, -0.036865234, -0.03515625, -0.007507324, -0.005706787, -0.003753662, 0.0029144287, -0.01574707, -0.0006942749, -0.016845703, -0.022216797, -0.020141602, -0.0063476562, 0.01977539, 0.0039367676, 0.00592041, 0.036865234, -0.0011138916, 0.014221191, -0.0005340576, -0.034423828, -0.011108398, 0.0134887695, 0.0068969727, 0.013366699, 0.020019531, -0.0029296875, 0.0018539429, 0.017578125, 0.014282227, 0.022827148, 0.0057678223, -0.033203125, -0.009460449, 0.020385742, -0.008483887, 0.026367188, 0.029052734, 0.01171875, 0.013244629, -0.0006942749, -0.0023651123, 0.015991211, 0.00092697144, -0.018310547, -0.0024719238, -0.024169922, 0.0051879883, 0.032714844, 0.00041007996, 0.00793457, 0.018066406, 0.01928711, 0.020263672, -0.0000060796738, -0.006225586, 0.013000488, -0.010803223, 0.015258789, 0.0040283203, -0.009521484, 0.015075684, 0.017333984, 0.00289917, -0.008544922, 0.034179688, -0.010070801, -0.026855469, 0.030517578, -0.016601562, -0.018920898, 0.010986328, -0.020751953, -0.016479492, 0.016479492, 0.01928711, 0.0022735596, -0.010375977, 0.004852295, 0.012756348, -0.010620117, -0.01928711, -0.017578125, 0.029785156, 0.018066406, 0.017700195, -0.0072631836, 0.0053710938, 0.0033721924, -0.009521484, 0.006866455, 0.0099487305, 0.013549805, 0.013671875, -0.036376953, -0.0069885254, 0.005584717, 0.018432617, -0.00018501282, -0.011413574, 0.014892578, 0.010437012, -0.026489258, -0.020874023, 0.0042419434, 0.014404297, 0.00045585632, -0.0053710938, 0.03491211, 0.005584717, 0.020263672, -0.01574707, -0.0031738281, -0.005004883, 0.0012130737, -0.0072021484, -0.016723633, -0.0006713867, -0.004486084, 0.0074157715, 0.005859375, 0.0058898926, 0.02709961, -0.008056641, -0.0013275146, -0.013244629, -0.016235352, -0.0029754639, -0.011413574, 0.009460449, -0.008239746, -0.025146484, -0.019042969, -0.020874023, 0.023803711, 0.0063171387, -0.022094727, 0.001953125, 0.027709961, -0.0037231445, -0.0017852783, 0.00000017881393, 0.0073547363, 0.017944336, -0.007019043, 0.0057373047, 0.0013656616, -0.02319336, -0.008300781, -0.027954102, -0.018798828, -0.0134887695, 0.0078125, 0.009338379, -0.009216309, 0.002822876, 0.0038452148, -0.014770508, 0.0038452148, 0.009216309, -0.0054626465, 0.016357422, -0.021240234, 0.016479492, -0.0014648438, -0.0035095215, 0.007232666, 0.020751953, -0.011230469, 0.012634277, -0.014709473, -0.012878418, -0.03540039, -0.018554688, 0.01171875, 0.011474609, 0.033447266, -0.0009613037, 0.0138549805, -0.010498047, -0.014587402, -0.008422852, 0.023803711, 0.017333984, 0.0033416748, -0.014953613, 0.02722168, -0.011230469, 0.011657715, 0.0068969727, 0.011291504, 0.01574707, -0.026123047, -0.0154418945, 0.00024414062, -0.00091552734, 0.010131836, 0.021728516, 0.020263672, 0.021728516, -0.01940918, 0.01574707, -0.009521484, 0.013977051, -0.0049743652, -0.0030212402, -0.0029449463, -0.018798828, -0.0045166016, -0.014404297, -0.018920898, -0.0040283203, 0.020996094, 0.010498047, -0.013244629, -0.0031738281, 0.018554688, 0.0075683594, -0.0069274902, -0.0003414154, 0.013366699, 0.0047912598, -0.01361084, -0.002456665, -0.0061950684, -0.05126953, -0.010925293, -0.0021362305, 0.0062561035, 0.00048828125, -0.001953125, -0.0039367676, -0.0028076172, -0.0013275146, 0.023925781, 0.013244629, 0.0019989014, -0.019897461, -0.029541016, 0.020263672, -0.014709473, -0.0053100586, -0.006652832, 0.00009441376, -0.017822266, -0.020019531, 0.02319336, -0.01574707, -0.018920898, 0.0011444092, 0.016113281, -0.010620117, -0.015563965, -0.017822266, -0.05126953, -0.009033203, 0.009094238, -0.034179688, 0.023803711, -0.0027618408, -0.0005607605, 0.029907227, 0.015625, -0.0030975342, 0.0011444092, -0.030517578, -0.0063476562, 0.0019302368, 0.014953613, -0.0043640137, -0.027954102, 0.016601562, -0.0044555664, -0.025512695, -0.024902344, 0.0053710938, 0.0078125, 0.045654297, 0.010070801, -0.012939453, 0.0126953125, 0.0065307617, 0.011108398, 0.00075149536, -0.011657715, -0.0051574707, -0.00064468384, -0.017333984, 0.01953125, 0.024780273, -0.016845703, -0.024536133, -0.00006771088, -0.002105713, -0.0008010864, -0.016845703, 0.02758789, -0.01586914, -0.030151367, 0.013183594, -0.03540039, 0.005584717, -0.0026245117, 0.0054626465, -0.026000977, 0.0040283203, -0.0064086914, -0.011108398, 0.00078201294, -0.019897461, -0.013000488, -0.002609253, 0.010986328, -0.020507812, -0.00793457, 0.021240234, 0.00059890747, -0.026123047, -0.037353516, -0.014160156, -0.026245117, 0.02319336, 0.014099121, -0.0058898926, -0.008544922, 0.008483887, -0.02709961, -0.0037078857, 0.0079956055, 0.026000977, 0.006713867, 0.025268555, 0.0051574707, -0.0032348633, 0.03125, 0.0071411133, -0.0126953125, 0.018432617, 0.011474609, -0.00091171265, 0.014343262, -0.0056762695, -0.018554688, -0.02734375, -0.012634277, -0.014526367, -0.010498047, -0.036621094, -0.018798828, 0.020507812, -0.0095825195, 0.0029296875, -0.0043945312, 0.0030212402, -0.014892578, -0.019897461, 0.002532959, -0.005706787, 0.008422852, -0.0087890625, -0.012023926, -0.023925781, -0.003829956, -0.013549805, -0.022705078, 0.020385742, -0.010620117, -0.033935547, 0.013549805, 0.007873535, -0.0031433105, 0.012390137, 0.03564453, 0.007873535, 0.009521484, -0.017211914, 0.014831543, 0.015991211, 0.016113281, -0.017211914, -0.037597656, -0.021484375, -0.01977539, -0.0061950684, -0.022949219, -0.006591797, -0.021606445, 0.0095825195, -0.0038604736, 0.0040893555, -0.012207031, -0.0018844604, 0.024291992, -0.009765625, 0.0051879883, -0.036865234, -0.010925293, 0.003829956, -0.0041503906, -0.016845703, 0.028076172, 0.0033111572, 0.015380859, -0.007232666, 0.016113281, -0.017700195, 0.00061798096, -0.0022735596, 0.010192871, 0.0031433105, 0.022216797, 0.025390625, -0.016479492, -0.0028076172, 0.03173828, -0.021362305, 0.005065918, -0.021728516, 0.0059814453, -0.032958984, -0.0068969727, 0.020629883, 0.00579834, 0.004333496, -0.056884766, 0.01373291, 0.010009766, 0.037353516, -0.009521484, -0.026489258, 0.015991211, 0.0022277832, -0.01184082, -0.008300781, -0.005126953, -0.009521484, -0.018310547, -0.009216309, -0.0064697266, -0.03466797, -0.013000488, -0.009033203, 0.006958008, -0.010131836, -0.0134887695, 0.013671875, -0.001701355, 0.015563965, -0.004638672, -0.011779785, -0.032958984, -0.00018596649, 0.014221191, -0.029541016, 0.026489258, -0.0014190674, -0.011413574, -0.013183594, 0.016723633, -0.02722168, -0.012390137, 0.010009766, 0.0073547363, -0.012023926, 0.0006790161, 0.008972168, -0.02355957, -0.0041503906, -0.009399414, 0.012084961, 0.020385742, -0.017211914, 0.022949219, 0.005859375, 0.007171631, -0.0001783371, 0.018798828, -0.00390625, -0.021118164, 0.005706787, -0.005859375, -0.013549805, 0.021484375, -0.049804688, -0.006378174, -0.0011062622, -0.011657715, -0.024536133, -0.013061523, -0.00074005127, 0.011047363, -0.032226562, -0.016113281, 0.023071289, 0.00006866455, 0.031982422, 0.013244629, 0.044921875, 0.0055236816, -0.024658203, -0.009216309, -0.025024414, 0.009521484, 0.048583984, 0.047607422, 0.010314941, 0.001701355, 0.003326416, -0.0006599426, 0.0035858154, 0.033691406, 0.0025787354, 0.018432617, 0.0234375, -0.0051879883, -0.013061523, -0.0009765625, 0.016479492, -0.009643555, 0.002105713, 0.015991211, 0.02355957, -0.004333496, -0.029418945, 0.011352539, -0.026611328, -0.02368164, 0.0056762695, 0.0026855469, 0.015380859, 0.0035552979, -0.0045776367, 0.0060424805, 0.0008773804, -0.008300781, 0.0048828125, 0.006378174, -0.0010299683, 0.00390625, 0.011779785, 0.012084961, -0.012207031, -0.004272461, -0.020874023, 0.009277344, -0.008422852, -0.00043296814, -0.011474609, 0.04248047, 0.028930664, 0.01574707, 0.013244629, -0.014160156, -0.0019836426, 0.010314941, -0.005645752, 0.013183594, 0.0028381348, -0.016601562, -0.021118164, 0.0036010742, -0.016357422, 0.0058898926, -0.010192871, -0.03125, 0.022949219, -0.007232666, -0.026245117, -0.020507812, 0.007232666, 0.03112793, 0.021728516, -0.021484375, 0.0044555664, 0.00028038025, 0.020019531, -0.02758789, -0.0024108887, 0.00023174286, -0.014770508, 0.0146484375, 0.018310547, 0.025756836, -0.0028381348, 0.0053710938, -0.014709473, -0.0008430481, -0.007873535, -0.007751465, 0.005645752, 0.0072021484, -0.01574707, -0.0069885254, -0.0013809204, 0.031982422, 0.0087890625, 0.0030212402, -0.028808594, -0.010559082, -0.0025177002, 0.032714844, 0.019165039, 0.001411438, -0.030395508, -0.022094727, 0.02758789, 0.03100586, -0.026367188, -0.0076293945, -0.008117676, -0.011291504, 0.00048828125, -0.015197754, -0.021118164, -0.0022735596, 0.016967773, 0.026855469, -0.0154418945, 0.006652832, 0.025512695, -0.011474609, -0.018676758, 0.017211914, -0.015136719, -0.012084961, -0.002166748, -0.0038909912, 0.009155273, -0.014892578, 0.01940918, 0.021850586, 0.0019836426, -0.0013809204, 0.008361816, 0.025756836, -0.016601562, 0.0074768066, -0.033447266, -0.014892578, -0.014099121, -0.0013275146, -0.0040283203, -0.0053100586, 0.036132812, 0.01953125, 0.016845703, -0.013427734, 0.010070801, 0.015563965, 0.018432617, -0.001449585, -0.029052734, -0.0390625, -0.001914978, 0.003967285, -0.0390625, -0.011291504, 0.008483887, 0.011779785, -0.020263672, -0.014404297, -0.015625, 0.019165039, -0.00793457, -0.01928711, -0.011291504, 0.0021972656, -0.011047363, 0.000096321106, -0.0056762695, 0.010437012, 0.008544922, 0.011474609, 0.010192871, 0.026000977, -0.0069274902, -0.011413574, 0.0057678223, 0.040039062, -0.0064086914, 0.003692627, 0.0009841919, -0.025390625, -0.00793457, -0.017700195, 0.016845703, 0.017944336, -0.021850586, -0.012512207, -0.0045776367, 0.008300781, 0.02746582, 0.021972656, 0.023071289, -0.020263672, -0.009887695, 0.0099487305, 0.0126953125, -0.036621094, -0.024536133, -0.0061035156, -0.0079956055, -0.00028800964, -0.0010375977, 0.0043945312, -0.012145996, -0.010498047, -0.016235352, -0.011169434, -0.026245117, -0.00050354004, 0.018798828, -0.014526367, 0.012512207, 0.0026855469, 0.028808594, 0.013122559, -0.02368164, 0.0069274902, 0.016235352, -0.0146484375, 0.0004043579, -0.010864258, -0.0099487305, 0.014526367, -0.009338379, 0.012268066, 0.014465332, 0.03149414, 0.026489258, 0.0010528564, 0.0009765625, 0.0033721924, -0.0134887695, -0.021118164, -0.018920898, 0.021606445, 0.005279541, 0.0099487305, -0.026855469, 0.010070801, -0.023071289, 0.003326416, -0.011962891, -0.027832031, 0.0047302246, 0.01574707, -0.018920898, 0.014465332, -0.004760742, -0.018066406, 0.011291504, -0.009094238, -0.010253906, -0.030639648, 0.011230469, -0.008239746, -0.015014648, -0.010192871, -0.037109375, 0.0043640137, -0.0064697266, -0.016601562, -0.037353516, 0.01574707, 0.006500244, 0.016723633, -0.017211914, -0.017089844, -0.01965332, -0.022094727, 0.00579834, 0.0099487305, 0.022460938, -0.0068359375, -0.020629883, 0.021362305, 0.008117676, -0.018188477, 0.027709961, 0.020263672, -0.013793945, 0.008911133, -0.01171875, 0.0024414062, -0.00074005127, -0.033935547, 0.0055236816, -0.0115356445, -0.0065612793, 0.012023926, 0.0010604858, 0.013793945, 0.015991211, -0.020629883, 0.036376953, -0.010375977, -0.0029907227, -0.005493164, -0.02331543, -0.018432617, 0.00793457, -0.0069885254, 0.013916016, -0.0041503906, 0.008666992, 0.0063476562, -0.005645752, -0.01965332, -0.014587402, 0.010864258, 0.0026245117, -0.024414062, -0.021240234, -0.020385742, -0.0046691895, -0.0066833496, 0.024902344, -0.015075684, -0.03955078, -0.008483887, 0.012207031, -0.0066223145, -0.011352539, -0.003967285, 0.005218506, 0.013671875, -0.04711914, -0.01574707, -0.0043640137, 0.010253906, 0.012512207, -0.020874023, 0.02319336, 0.01373291, 0.019165039, 0.009521484, -0.018554688, 0.006591797, -0.0077209473, -0.012268066, -0.0046081543, -0.010375977, 0.005432129, 0.0013046265, 0.0027313232, -0.004333496, -0.003768921, 0.00970459, 0.00019550323, -0.0064697266, -0.01586914, 0.02368164, -0.008422852, -0.028930664, -0.02355957, -0.03857422, 0.01574707, -0.00030517578, -0.004058838, -0.02734375, 0.013916016, 0.014038086, -0.010864258, -0.0018692017, 0.029418945, -0.010925293, 0.005340576, -0.0058898926, -0.010314941, -0.0067443848, -0.03173828, -0.008117676, 0.0074157715, 0.020263672, 0.0008735657, -0.016113281, -0.021118164, -0.022827148, -0.00592041, 0.010864258, 0.011962891, -0.0079956055, -0.00074386597, -0.022094727, 0.0060424805, -0.015991211, 0.0034484863, -0.0059814453, 0.004333496, 0.01928711, -0.0062561035, 0.026245117, -0.012145996, -0.016601562, -0.014404297, 0.0022583008, -0.016235352, 0.007293701, 0.0066833496, 0.00079345703, -0.0030975342, 0.03930664, -0.012023926, -0.010498047, -0.032714844, -0.00592041, 0.020996094, -0.0035858154, -0.0056152344, 0.018798828, -0.03515625, 0.020874023, 0.010131836, 0.011657715, 0.0079956055, 0.015991211, -0.008544922, -0.0039367676, 0.007873535, 0.025756836, 0.01965332, 0.0043945312, 0.015197754, -0.013183594, -0.0001487732, -0.0234375, -0.021850586, 0.024902344, 0.006439209, -0.034423828, 0.0053710938, -0.0025024414, -0.008422852, 0.009338379, 0.012634277, 0.02355957, 0.010375977, 0.0030059814, 0.03112793, -0.01953125, 0.017211914, -0.01953125, -0.025146484, 0.022216797, -0.020751953, 0.012878418, 0.0019683838, 0.010498047, 0.0063171387, -0.008056641, -0.017578125, -0.010559082, 0.015319824, 0.0021209717, -0.0062561035, -0.002380371, -0.005493164, -0.023803711, 0.0027618408, -0.0052490234, 0.00063705444, -0.013244629, 0.02331543, -0.013366699, -0.017944336, -0.008422852, -0.00005221367, -0.037109375, -0.025390625, 0.014587402, -0.02319336, 0.0069885254, 0.015197754, 0.04321289, 0.008239746, 0.026733398, 0.02758789, 0.0126953125, -0.025024414, 0.019165039, -0.01977539, -0.0071411133, -0.008117676, 0.004547119, 0.016235352, -0.009094238, 0.0077209473, 0.010925293, 0.022338867, -0.011169434, 0.019042969, -0.019165039, 0.029541016, -0.014770508, 0.017211914, 0.020996094, 0.0009994507, -0.0038757324, -0.010009766, -0.00970459, -0.009155273, 0.002029419, 0.012451172, -0.029785156, -0.011962891, 0.03955078, -0.01171875, -0.043701172, -0.04345703, -0.03540039, 0.023071289, -0.0019302368, 0.0062561035, 0.009460449, -0.0037231445, 0.03515625, 0.008422852, -0.006958008, 0.0066223145, -0.008239746, 0.057861328, 0.0053710938, 0.009399414, 0.008666992, 0.016113281, 0.012207031, 0.017211914, 0.009338379, -0.013671875, -0.007446289, 0.03173828, 0.024780273, -0.013244629, 0.017700195, -0.0049743652, -0.015625, 0.012084961, 0.0072631836, -0.023071289, -0.008361816, 0.017211914, -0.014587402, -0.0022125244, -0.0003414154, 0.013061523, -0.015625, -0.0023651123, 0.033935547, -0.00043678284, -0.010314941, -0.001953125, -0.02722168, -0.016967773, 0.03540039, 0.0044555664, -0.034423828, -0.016479492, -0.03173828, -0.006439209, -0.0037994385, -0.0023498535, -0.008483887, 0.0051879883, -0.008972168, 0.006378174, -0.010009766, 0.018310547, -0.016967773, -0.011657715, -0.0041503906, -0.020629883, 0.0070495605, -0.002380371, 0.016845703, -0.004211426, 0.00045776367, -0.0033874512, -0.028076172, -0.009033203, 0.009033203, 0.0019302368, -0.034179688, 0.024047852, -0.032226562, -0.021728516, 0.00970459, 0.0017852783, -0.012451172, 0.0047302246, 0.0008277893, -0.0034637451, -0.0069274902, -0.024536133, 0.016845703, -0.03491211, 0.012634277, 0.0025482178, -0.018798828, -0.016235352, -0.010192871, 0.026489258, 0.00093078613, -0.04272461, -0.009887695, -0.0076293945, -0.01586914, -0.008117676, -0.00075531006, 0.012451172, 0.029174805, 0.018554688, -0.024169922, 0.0012435913, 0.021240234, -0.007751465, -0.025390625, -0.014404297, 0.02746582, 0.005126953, -0.00005888939, 0.028198242, -0.015014648, 0.02709961, -0.006439209, -0.007507324, 0.0107421875, 0.0034484863, 0.017211914, 0.016601562, -0.028076172, 0.020507812, -0.0076293945, -0.005340576, -0.0072021484, -0.005432129, 0.004638672, -0.0034942627, 0.0107421875, -0.0010757446, -0.00390625, 0.013305664, -0.033447266, -0.0031738281, -0.009094238, 0.012329102, -0.00047683716, 0.0004081726, 0.007659912, 0.0025177002, -0.0012817383, -0.0038909912, -0.007659912, -0.025878906, -0.0079956055, 0.016357422, -0.018554688, -0.01928711, 0.016113281, -0.0057678223, 0.017211914, 0.026489258, 0.009033203, -0.00021743774, 0.016235352, -0.0072021484, 0.0008239746, 0.012451172, -0.015380859, 0.010253906, 0.00680542, -0.03930664, -0.015625, 0.00090408325, -0.005065918, 0.0036010742, 0.0134887695, -0.010192871, 0.017944336, 0.018920898, -0.01965332, 0.019165039, 0.0033111572, 0.025024414, -0.01586914, -0.016357422, -0.0071411133, 0.010375977, -0.014221191, -0.013916016, -0.03125, 0.011108398, 0.008178711, 0.0034942627, -0.0067749023, -0.016601562, 0.011474609, 0.0018463135, 0.0067749023, 0.025024414, 0.010375977, 0.0044555664, -0.028808594, 0.0050354004, -0.003692627, 0.018066406, -0.0076293945, 0.0008163452, 0.013183594, -0.044189453, 0.036621094, 0.0011367798, -0.0039367676, 0.025268555, -0.003616333, -0.022338867, 0.01574707, -0.012756348, -0.010803223, 0.007598877, -0.003967285, 0.02709961, -0.0067443848, 0.026123047, -0.0047302246, -0.018310547, 0.012084961, 0.028808594, 0.0053100586, 0.0049438477, 0.028198242, 0.030883789, 0.008850098, -0.010314941, -0.021240234, 0.0036468506, 0.018188477, -0.044189453, 0.00065231323, 0.01159668, 0.008483887, -0.008544922, 0.014343262, -0.016235352, -0.010681152, 0.0036773682, 0.016967773, -0.0020599365, 0.030029297, 0.032470703, 0.0032653809, -0.008239746, 0.010803223, 0.010070801, -0.00592041, -0.008300781, -0.029296875, 0.020629883, -0.00049591064, 0.018554688, 0.010986328, -0.0026855469, 0.04248047, -0.020385742, -0.023803711, -0.004058838, 0.03149414, 0.0011978149, -0.017578125, 0.012084961, 0.0011062622, 0.0066833496, 0.020996094, -0.005279541, 0.032714844, -0.016723633, -0.030151367, 0.007080078, -0.028198242, -0.0064697266, 0.002090454, 0.012390137, -0.025756836, 0.033203125, -0.018554688, 0.006652832, 0.035888672, -0.012145996, -0.0066223145, 0.018066406, 0.01361084, -0.027709961, -0.014770508, 0.016357422, 0.006164551, 0.017578125, -0.007019043, 0.034423828, 0.043945312, -0.030273438, -0.009277344, -0.0067749023, -0.0029754639, 0.03881836, 0.006866455, -0.014099121, 0.0038757324, 0.011230469, 0.012390137, 0.0056152344, -0.016967773, -0.0059814453, -0.01171875, 0.013183594, 0.0069885254, -0.029174805, 0.015197754, 0.008239746, -0.03540039, 0.0050354004, -0.014709473, 0.0046081543, 0.027709961, 0.016845703, -0.0019302368, -0.020385742, 0.016601562, -0.013122559, 0.032714844, 0.008666992, -0.013793945, 0.005126953, -0.025634766, -0.001701355, 0.009521484, -0.020385742, -0.0069885254, 0.008483887, -0.014587402, 0.017578125, 0.0011901855, 0.009765625, 0.002822876, -0.005279541, -0.0016098022, -0.0012664795, -0.002746582, -0.016845703, -0.0075683594, -0.020263672, 0.0038604736, 0.026000977, -0.004699707, -0.0052490234, -0.0046081543, -0.023071289, 0.015075684, 0.029296875, -0.016357422, -0.0037231445, -0.0095825195, -0.013122559, -0.011962891, -0.022460938, 0.024414062, -0.018920898, 0.022460938, -0.006866455, -0.022705078, 0.027832031, -0.0022735596, 0.022338867, 0.007446289, 0.013305664, 0.00026130676, -0.017822266, -0.015136719, 0.026855469, -0.010375977, 0.0076904297, 0.0048828125, -0.009399414, -0.029418945, 0.01373291, 0.0078125, -0.03173828, 0.00075149536, -0.016113281, -0.016601562, 0.0065612793, 0.008239746, -0.024291992, 0.02319336, 0.012145996, -0.022216797, 0.0036010742, 0.0036010742, 0.044921875, 0.01928711, 0.0041503906, -0.027954102, -0.034179688, -0.0016021729, 0.011657715, 0.008911133, -0.00031852722, -0.012451172, 0.011474609, 0.016723633, -0.0037994385, 0.0057678223, -0.012878418, -0.016723633, 0.008300781, 0.0069885254, 0.015319824, -0.022094727, 0.010498047, 0.00074005127, 0.005554199, -0.0009841919, 0.009338379, 0.040771484, 0.005218506, 0.02722168, 0.0066833496, -0.018432617, -0.0045776367, -0.0012130737, -0.016357422, 0.010437012, 0.0021972656, 0.015014648, -0.010009766, 0.008605957, -0.020385742, -0.01965332, 0.013916016, -0.015258789, 0.017456055, -0.008056641, 0.02368164, 0.01940918, 0.017089844, 0.030761719, -0.015136719, 0.002746582, 0.0013046265, -0.026977539, -0.017333984, 0.01184082, -0.020507812, 0.016967773, 0.036621094, 0.020019531, 0.022338867, 0.010437012, -0.011962891, -0.013000488, -0.017089844, -0.011291504, -0.012634277, -0.016723633, 0.026123047, -0.023071289, -0.014709473, 0.013000488, 0.03149414, 0.006225586, -0.002456665, 0.006011963, 0.001159668, -0.01574707, 0.00023078918, 0.03564453, -0.0062561035, 0.009887695, -0.03173828, -0.012878418, -0.004852295, -0.024291992, 0.010986328, 0.007659912, -0.02368164, -0.0146484375, 0.0038909912, 0.0119018555, -0.010986328, 0.008422852, -0.028686523, 0.010620117, -0.0016937256, 0.0126953125, -0.0040893555, -0.014038086, -0.034179688, -0.015136719, 0.0011672974, -0.0063476562, 0.026733398, 0.011413574, 0.008972168, 0.0056152344, -0.0095825195, -0.0050964355, 0.020996094, -0.0013275146, 0.01159668, 0.022338867, 0.014892578, -0.015136719, 0.014953613, 0.007171631, 0.016845703, 0.037841797, -0.020629883, 0.012390137, 0.026489258, -0.0050354004, -0.008422852, -0.011474609, -0.019165039, -0.016845703, -0.009155273, 0.01373291, -0.02355957, 0.032470703, -0.009887695, -0.013305664, 0.002029419, 0.0011749268, -0.044921875, -0.009277344, 0.020141602, 0.0023040771, -0.024414062, 0.009338379, 0.015625, 0.036865234, -0.012145996, 0.021240234, 0.0234375, -0.010986328, -0.00025558472, 0.0115356445, -0.026245117, -0.041503906, -0.032958984, -0.014282227, -0.00289917, 0.013122559, 0.004547119, 0.0050964355, -0.0025634766, -0.015380859, -0.009033203, 0.00011301041, 0.004760742, 0.0055236816, 0.009155273, -0.009033203, -0.0079956055, -0.011108398, 0.028808594, -0.035888672, 0.0053710938, -0.021850586, -0.01184082, 0.02709961, 0.01184082, 0.0034179688, 0.006378174, 0.0014266968, 0.0069885254, -0.011413574, 0.019165039, -0.011108398, -0.010375977, -0.017700195, -0.016479492, 0.025268555, 0.0043945312, 0.017578125, -0.016479492, -0.0006752014, 0.0061950684, 0.020141602, 0.011657715, 0.008178711, -0.016479492, -0.000055789948, 0.008911133, -0.03100586, -0.009094238, -0.0018234253, 0.0064697266, 0.0037231445, 0.014709473, -0.0015716553, 0.01574707, -0.006866455, 0.0005569458, 0.01586914, 0.010314941, 0.028686523, -0.009033203, 0.029785156, -0.01171875, 0.0045166016, 0.018188477, 0.02368164, 0.0071411133, 0.0115356445, -0.0015029907, -0.011108398, -0.016845703, -0.003616333, 0.0014648438, 0.014831543, 0.018676758, -0.022460938, -0.0030670166, 0.0038452148, 0.009338379, -0.0030670166, -0.012878418, -0.0071411133, 0.0013198853, 0.0005340576, -0.014709473, 0.0065612793, -0.030029297, 0.015625, 0.01550293, 0.0029907227, -0.018188477, 0.0030670166, 0.02319336, -0.013366699, 0.010498047, -0.015380859, 0.01928711, 0.01586914, 0.002380371, -0.035888672, 0.01586914, 0.029907227, 0.014099121, -0.00491333, 0.011352539, 0.0068359375, -0.0234375, -0.0030822754, -0.0016479492, 0.015136719, -0.041992188, -0.0059509277, -0.0028533936, -0.014282227, 0.0022583008, -0.004638672, -0.020507812, -0.014160156, 0.018676758, 0.012145996, -0.027954102, 0.0028839111, -0.009765625, -0.030273438, -0.010498047, 0.011169434, -0.024291992, -0.026733398, 0.005554199, 0.03857422, 0.0059509277, -0.01928711, -0.015625, 0.020385742, -0.026489258, 0.014343262, -0.026733398, -0.01953125, 0.00019073486, 0.037841797, 0.023925781, -0.030395508, -0.016113281, 0.005340576, -0.00680542, 0.0060424805, -0.017089844, 0.033691406, -0.011352539, -0.010559082, 0.02758789, -0.0029144287, 0.0021362305, 0.014404297, 0.00970459, 0.00579834, -0.0058898926, -0.01373291, -0.00063705444, 0.008605957, -0.004211426, -0.0020446777, -0.014526367, 0.02319336, -0.011108398, -0.03466797, 0.017700195, 0.009643555, 0.009216309, -0.035888672, 0.014587402, 0.012390137, -0.00390625, -0.026733398, 0.039794922, 0.004699707, 0.016845703, 0.025634766, -0.0058898926, -0.01953125, 0.00050354004, -0.0154418945, -0.0035705566, -0.010131836, -0.033691406, -0.009643555, -0.01953125, -0.010498047, 0.011352539, -0.0010604858, 0.021850586, -0.0047912598, 0.019165039, 0.0039367676, 0.040283203, 0.026733398, -0.03466797, -0.004699707, 0.0016555786, 0.01940918, 0.008239746, -0.032226562, 0.0036315918, 0.0076904297, -0.0012664795, -0.013793945, 0.047607422, -0.026245117, -0.0011901855, 0.02331543, 0.015136719, 0.005554199, 0.0009460449, 0.012451172, -0.0076904297, 0.0017623901, -0.023803711, -0.003692627, -0.008178711, -0.004272461, -0.0049743652, -0.0057678223, 0.0012283325, 0.006500244, 0.00051116943, 0.032958984, -0.0138549805, 0.010009766, -0.016235352, 0.014282227, 0.020019531, -0.009521484, -0.037597656, -0.011779785, -0.0052490234, 0.0061035156, -0.014709473, 0.045654297, -0.011779785, 0.010131836, 0.00046539307, -0.012817383, -0.0018463135, -0.00092315674, 0.014343262, 0.011352539, -0.017578125, 0.020874023, -0.0006752014, -0.017456055, 0.0035095215, 0.0040283203, 0.037841797, 0.021728516, -0.0063476562, 0.020507812, 0.006866455, 0.014953613, -0.000579834, -0.015014648, -0.020751953, 0.017089844, -0.017578125, 0.0021820068, -0.0049438477, -0.007232666, -0.026489258, 0.026977539, -0.0067443848, 0.0030059814, -0.016845703, -0.020385742, 0.016479492, -0.014709473, -0.0038757324, -0.016235352, 0.00063323975, 0.010131836, 0.00025177002, 0.008117676, 0.007507324, 0.017700195, -0.017944336, 0.03173828, -0.013061523, -0.00039100647, -0.004852295, 0.0026550293, 0.013061523, -0.022949219, 0.026611328, -0.018920898, 0.028930664, -0.021118164, 0.017089844, -0.01361084, 0.028320312, -0.019897461, 0.0035705566, 0.000039339066, 0.008728027, -0.002670288, 0.004547119, 0.010375977, -0.025390625, 0.018188477, 0.0029296875, -0.0021514893, 0.0066833496, -0.024047852, -0.021972656, -0.009643555, 0.014465332, -0.044921875, 0.012023926, -0.004211426, 0.013793945, 0.021606445, -0.012512207, -0.002532959, -0.008178711, 0.010498047, -0.019897461, 0.011779785, -0.012145996, 0.011169434, -0.0046081543, 0.00017547607, -0.008422852, -0.011047363, -0.01586914, -0.0054626465, -0.0067749023, 0.0063476562, 0.009460449, 0.012451172, -0.021728516, 0.017944336, 0.007446289, -0.0053710938, 0.009399414, 0.008911133, 0.024291992, 0.030151367, -0.034423828, 0.0033111572, 0.03930664, -0.020996094, -0.016967773, -0.015136719, 0.0022888184, 0.017822266, -0.016113281, 0.0023345947, -0.012756348, -0.028198242, -0.011474609, 0.011352539, 0.033691406, 0.0010299683, -0.010498047, -0.02709961, -0.012939453, -0.032470703, 0.008850098, -0.025146484, -0.02758789, 0.007293701, -0.018432617, -0.03857422, -0.0033721924, -0.01171875, -0.00015926361, 0.024047852, 0.00390625, 0.016357422, 0.0043640137, -0.0000269413, -0.015991211, -0.016601562, 0.013122559, -0.010131836, -0.0046691895, -0.008178711, -0.018554688, -0.022216797, -0.003326416, 0.008850098, -0.004211426, 0.0037994385, -0.0038452148, 0.01171875, -0.009887695, -0.0033111572, 0.013977051, -0.010253906, 0.0059509277, 0.006378174, 0.008972168, 0.0050354004, 0.0023040771, 0.0010757446, -0.013061523, 0.0045776367, 0.0031280518, 0.0040283203, 0.008911133, 0.018798828, 0.009033203, -0.006591797, -0.014343262, 0.005004883, -0.009399414, 0.020629883, -0.026123047, -0.025024414, -0.007873535, -0.0045776367, -0.030029297, -0.01965332, -0.0065307617, 0.0021820068, 0.013122559, 0.0038909912, 0.004333496, -0.022949219, 0.0069274902, 0.0095825195, -0.022338867, -0.033447266, 0.0054016113, -0.011413574, -0.016479492, -0.019897461, 0.010009766, -0.013977051, 0.0095825195, -0.009521484, 0.034423828, 0.0066833496, -0.022583008, 0.018920898, -0.018920898, -0.028686523, -0.00060272217, 0.019897461, 0.012207031, -0.010131836, -0.0029296875, 0.0050354004, 0.052978516, -0.020385742, 0.00015258789, 0.020874023, -0.006591797, -0.017211914, 0.0010375977, -0.026123047, 0.022094727, -0.01965332, 0.0069885254, -0.008117676, -0.0024414062, 0.0067749023, -0.004180908, -0.0015640259, -0.0045776367, -0.014709473, 0.0026245117, -0.013305664, -0.026245117, -0.023925781, -0.008911133, 0.0027313232, 0.003692627, -0.008911133, 0.011352539, -0.008666992, 0.015136719, -0.01586914, -0.055419922, -0.00023365021, -0.0035247803, -0.0040283203, -0.02368164, 0.017456055, 0.025390625, 0.016113281, -0.019042969, -0.0061950684, 0.0057373047, -0.015991211, -0.0053100586, -0.0030822754, -0.052978516, -0.0234375, 0.014404297, 0.02722168, 0.007873535, 0.015991211, 0.017944336, -0.008056641, -0.014587402, 0.0007171631, 0.026733398, -0.01373291, 0.005493164, -0.02319336, 0.0069885254, -0.0052490234, -0.0013580322, -0.0068359375, 0.021362305, -0.01965332, -0.0035247803, 0.010620117, 0.01574707, -0.0037841797, -0.0041503906, -0.008483887, -0.0030975342, 0.0065612793, -0.016845703, -0.041259766, 0.017456055, 0.021118164, 0.012023926, 0.005279541, -0.012939453, -0.010681152, 0.0073547363, -0.013549805, -0.010620117, 0.0033874512, 0.010192871, 0.0030212402, 0.010925293, -0.0012359619, -0.008117676, -0.010925293, -0.01171875, -0.0025482178, 0.016723633, -0.0042419434, 0.018188477, -0.009094238, -0.023803711, -0.0014724731, 0.0066223145, 0.01977539, 0.0115356445, 0.0138549805, 0.006652832, -0.018798828, 0.022338867, -0.0057373047, 0.0015258789, -0.005065918, 0.00039863586, -0.0008125305, -0.0061035156, -0.01574707, 0.0068969727, 0.01361084, 0.014892578, 0.009338379, -0.013916016, 0.0051574707, -0.009521484, 0.0062561035, 0.017211914, 0.008300781, -0.012084961, -0.009338379, 0.016357422, 0.0078125, 0.02709961, 0.010437012, 0.0058288574, -0.039794922, 0.0041503906, -0.007873535, -0.029296875, -0.007659912, -0.032958984, 0.013671875, -0.01184082, 0.0043945312, -0.0005531311, -0.008972168, -0.013793945, 0.0039367676, 0.022583008, 0.0054016113, 0.016967773, -0.012268066, 0.0017318726, 0.024536133, 0.0015335083, -0.029907227, -0.0040283203, 0.009887695, 0.0019989014, 0.008850098, -0.0014266968, 0.028808594, -0.0077209473, -0.020874023, -0.014831543, -0.00062561035, -0.012329102, 0.03515625, 0.006958008, -0.00041770935, 0.01171875, 0.017333984, 0.0037078857, -0.003326416, -0.032714844, 0.029418945, -0.020874023, -0.002029419, 0.020385742, -0.016845703, -0.014282227, -0.029174805, -0.017578125, 0.030029297, -0.009216309, 0.0065307617, -0.039794922, -0.010986328, -0.0077819824, 0.025146484, 0.0026397705, 0.0069274902, -0.006011963, -0.006286621, 0.02734375, 0.0043945312, -0.0019226074, -0.009521484, 0.049316406, -0.02722168, -0.03149414, -0.01159668, 0.010375977, 0.015991211, -0.024414062, 0.033203125, 0.0048217773, 0.0030517578, -0.01373291, 0.013916016, 0.022583008, 0.01574707, 0.0049743652, 0.008605957, -0.0077819824, -0.01940918, 0.005493164, 0.022216797, -0.0005226135, -0.01586914, 0.025512695, 0.029907227, 0.005340576, -0.0055236816, 0.014770508, -0.011657715, -0.0030975342, 0.00579834, 0.0050354004, -0.00061416626, 0.041748047, -0.019042969, -0.013000488, -0.011352539, 0.012634277, 0.018066406, -0.004272461, -0.0063171387, -0.030517578, -0.020141602, -0.0022735596, -0.009460449, -0.007751465, 0.016235352, 0.0022583008, 0.003753662, 0.025268555, 0.021484375, 0.00011777878, 0.004272461, -0.009399414, 0.020507812, 0.005493164, 0.030761719, 0.010803223, -0.01965332, -0.004699707, -0.01586914, 0.006286621, 0.0019378662, -0.016235352, 0.041015625, 0.01965332, -0.0014953613, 0.018554688, -0.006958008, 0.000081539154, 0.007537842, -0.0134887695, 0.0058288574, 0.010559082, -0.02722168, -0.025512695, 0.0012283325, -0.009399414, 0.016967773, -0.024536133, 0.006164551, -0.0017929077, 0.008605957, 0.007293701, -0.020263672, -0.013366699, -0.01940918, -0.0046691895, -0.0087890625, 0.00064849854, 0.015991211, 0.0027618408, -0.0013275146, -0.016235352, -0.0042419434, 0.008239746, -0.0061950684, -0.04321289, -0.015075684, -0.012145996, -0.016479492, -0.0038909912, -0.030151367, -0.016113281, 0.041748047, -0.0019989014, -0.011779785, -0.020141602, -0.0107421875, -0.00016593933, -0.00680542, -0.0017929077, -0.020141602, 0.008239746, 0.022583008, -0.03491211, -0.0073242188, -0.0048828125, 0.010559082, 0.016479492, -0.007385254, 0.015258789, 0.006500244, -0.0060424805, 0.013061523, -0.0076904297, -0.009033203, -0.0027008057, -0.0023956299, 0.0073547363, 0.018310547, 0.024291992, 0.01171875, -0.021972656, 0.020874023, 0.036132812, 0.0075683594, -0.020019531, 0.029418945, -0.006500244, -0.01171875, -0.01550293, -0.022338867, -0.010437012, -0.018798828, -0.020996094, -0.028198242, 0.01965332, -0.00793457, 0.012207031, -0.009521484, 0.01574707, -0.010314941, -0.00018596649, 0.0050354004, -0.009399414, -0.018310547, 0.0060424805, 0.00024414062, 0.020751953, -0.019042969, 0.016357422, -0.0021972656, 0.016967773, -0.010681152, 0.015197754, 0.023925781, 0.043701172, 0.020874023, 0.01965332, -0.016235352, -0.010314941, 0.03466797, 0.0029907227, 0.0154418945, -0.0076904297, 0.0047912598, -0.0066833496, -0.0022888184, 0.020385742, 0.0036315918, 0.0013580322, 0.017089844, 0.02319336, -0.007598877, -0.00021839142, -0.008544922, 0.025634766, 0.010681152, -0.0062561035, -0.0043945312, -0.017456055, -0.007171631, -0.0027160645, 0.00017929077, 0.032470703, 0.026733398, -0.023071289, -0.029418945, 0.017578125, -0.016723633, -0.010498047, -0.05102539, -0.00028419495, 0.021240234, -0.004180908, -0.016113281, -0.016479492, 0.004760742, -0.017822266, -0.009216309, 0.009277344, -0.042236328, 0.0026245117, -0.0059509277, -0.03125, 0.00982666, -0.010681152, -0.0044555664, -0.011657715, 0.015991211, -0.013427734, -0.003753662, -0.017089844, 0.006652832, -0.012634277, 0.002166748, -0.015991211, -0.009094238, 0.015991211, 0.0119018555, -0.021972656, 0.028686523, 0.022094727, 0.039794922, 0.024780273, 0.021362305, 0.017944336, 0.023071289, -0.036621094, -0.021362305, 0.005218506, -0.012268066, -0.011108398, -0.019042969, -0.00793457, -0.0027160645, -0.011108398, 0.010986328, -0.033935547, -0.0062561035, 0.030639648, -0.024902344, -0.017211914, -0.0009422302, -0.008056641, -0.008056641, -0.013305664, 0.014282227, 0.014465332, -0.01940918, 0.009765625, 0.00025749207, 0.008117676, 0.016967773, 0.017211914, -0.009338379, -0.011291504, -0.018554688, 0.009399414, 0.021484375, -0.0013122559, 0.024780273, 0.0019226074, 0.01361084, -0.016967773, 0.036865234, 0.010681152, 0.008666992, 0.006378174, -0.0073242188, -0.0016784668, -0.0069274902, 0.007507324, -0.020751953, -0.01586914, -0.009765625, 0.00074386597, 0.010925293, 0.008056641, 0.0058288574, 0.0043945312, -0.013183594, 0.010437012, 0.004699707, -0.0011901855, -0.0004234314, -0.030883789, -0.014282227, 0.008300781, 0.018188477, -0.012756348, -0.008483887, 0.013366699, -0.022705078, -0.003967285, -0.002532959, 0.0037841797, 0.0013122559, -0.01373291, 0.029663086, -0.013671875, -0.03466797, 0.01953125, 0.011352539, 0.033203125, 0.0008621216, 0.041015625, 0.008239746, 0.00036239624, 0.0018310547, -0.0021514893, 0.020751953, -0.018920898, -0.027709961, -0.0035095215, -0.03540039, -0.0033111572, 0.028930664, 0.00039482117, 0.032958984, 0.010192871, -0.0003681183, 0.022094727, 0.0050964355, -0.009094238, -0.023071289, 0.0030517578, 0.015991211, -0.003967285, 0.028564453, -0.0064086914, 0.010620117, -0.012939453, 0.017700195, -0.025756836, 0.0034942627, 0.014099121, 0.00793457, 0.006072998, -0.010253906, 0.012451172, -0.021484375, 0.007873535, -0.022094727, -0.006591797, -0.013793945, -0.005493164, 0.000541687, 0.014282227, 0.0029754639, 0.010131836, 0.040283203, 0.0154418945, -0.021484375, 0.020874023, 0.022827148, -0.02734375, -0.04663086, -0.011413574, -0.0066833496, 0.004425049, -0.009765625, -0.0000063180923, -0.0024719238, -0.0032043457, -0.014831543, 0.021118164, -0.012573242, 0.003112793, -0.030761719, 0.020263672, -0.005004883, -0.030151367, 0.008056641, -0.023071289, 0.03149414, 0.0018386841, 0.025634766, -0.004486084, 0.0046081543, -0.010681152, -0.021606445, 0.020751953, 0.005554199, -0.0079956055, 0.005493164, 0.015563965, -0.002105713, 0.024414062, -0.0107421875, -0.005432129, -0.0032958984, 0.005645752, -0.0066833496, -0.0051879883, -0.02368164, -0.009155273, -0.0013122559, -0.020629883, -0.019042969, 0.020263672, 0.040039062, -0.0003414154, -0.03173828, -0.009338379, 0.010070801, -0.017211914, 0.012451172, 0.015075684, -0.0017852783, -0.04711914, -0.017822266, 0.021484375, 0.02722168, -0.0057373047, -0.00064849854, -0.020874023, -0.016601562, -0.0019989014, -0.024047852, -0.022583008, -0.0019454956, 0.009399414, 0.013671875, 0.021240234, -0.0154418945, -0.0023498535, -0.018188477, -0.008300781, -0.023803711, -0.011657715, -0.0026855469, -0.012512207, -0.0060424805, 0.0054016113, -0.0019454956, -0.032958984, 0.02355957, 0.018920898, 0.0037841797, -0.012390137, 0.000957489, -0.041992188, 0.017456055, -0.0007286072, 0.0038604736, -0.0037078857, -0.0029754639, -0.015380859, -0.0076904297, -0.0018692017, 0.013122559, -0.020874023, 0.037353516, 0.013977051, 0.005218506, 0.0064086914, -0.017944336, 0.0006866455, -0.025878906, -0.008239746, 0.012451172, 0.018676758, -0.007537842, 0.007080078, -0.0073242188, 0.0075683594, 0.001663208, -0.009094238, 0.012207031, 0.012268066, 0.00016593933, -0.030883789, -0.036865234, -0.003829956, 0.01953125, 0.014221191, -0.014099121, -0.014099121, -0.029052734, 0.007080078, 0.014831543, -0.036376953, 0.015014648, -0.020141602, 0.021606445, 0.032226562, 0.020629883, -0.026000977, -0.006652832, -0.026977539, -0.017822266, -0.008300781, -0.030517578, -0.031982422, 0.01171875, -0.011169434, -0.009765625]"
probe_val = 1
number_of_outputs = 1
engine = create_engine("mysql+pymysql://root:111@127.0.0.1:6001/" + db_name)
Session = sessionmaker(bind=engine)
session = Session()
get_meta_tables = text("select algo_table_type,index_table_name from mo_catalog.mo_indexes where name=:idx_name"
+ " and column_name=:org_tbl_sk_name;")
result = session.execute(get_meta_tables, {"idx_name": original_tbl_vec_idx_name,
"org_tbl_sk_name": org_tbl_sk_name})
meta_tables = result.fetchall()
idx_metadata_tbl_name = ""
idx_centroids_tbl_name = ""
idx_entries_tbl_name = ""
for row in meta_tables:
algo_table_type, index_table_name = row
if algo_table_type == 'metadata':
idx_metadata_tbl_name = index_table_name
elif algo_table_type == 'centroids':
idx_centroids_tbl_name = index_table_name
elif algo_table_type == 'entries':
idx_entries_tbl_name = index_table_name
# get the current centroid version
get_centroid_version_query = f"select cast(__mo_index_val as BIGINT) from `{idx_metadata_tbl_name}` where __mo_index_key = 'version';"
get_centroid_version = text(get_centroid_version_query)
result = session.execute(get_centroid_version)
centroid_version = result.fetchone()[0] # Assuming there's only one row
# print("centroid version", centroid_version)
# get the centroids nearest to the input vector
get_centroids = text("select `__mo_index_centroid_id` from `" + idx_centroids_tbl_name + "` "
+ " where `__mo_index_centroid_version`=" + str(centroid_version) + " "
+ " order by l2_distance(`__mo_index_centroid`, normalize_l2(\"" + input_vector_val + "\")) asc "
+ " limit " + str(probe_val) + "")
# get the nearest vectors in the centroid
get_entries_pk = text("select distinct(`__mo_index_pri_col`) from `" + idx_entries_tbl_name + "` "
+ " where `__mo_index_centroid_fk_version`=" + str(centroid_version) + " and "
+ " `__mo_index_centroid_fk_id` in ( " + get_centroids.text + ") ")
# print(get_entries_pk.text)
# get the nearest vector from the original table
get_original_tbl_vector = text("select * from `" + org_tbl_name + "` "
+ " where `" + org_tbl_pk_name + "` in ( " + get_entries_pk.text + ") "
+ " order by l2_distance(`" + org_tbl_sk_name + "`, \"" + input_vector_val + "\") "
+ "asc limit " + str(number_of_outputs) + "")
print(get_original_tbl_vector.text)
# result = session.execute(get_original_tbl_vector)
# rows = result.fetchall()
# for row in rows:
# print(row)
run()