search

manticoresoftware / manticoresearch

Easy to use open source fast database for search | Good alternative to Elasticsearch now | Drop-in replacement for E in the ELK soon
https://manticoresearch.com
GNU General Public License v3.0
9.07k stars 509 forks source link

🆕 Update buddy version (fix/autoschema_float_vector) #2762

Open githubmanticore opened 1 week ago

githubmanticore commented 1 week ago

Update buddy version to: 3.0.1 24111409 989ac95 which includes:

989ac95 Merge branch 'main' into fix/autoschema_float_vector 3861c6b Fixed the handling of incorrect bulk insert (#399) 43b347c Updated JSON data type detection f599a87 fixed mistype in README.md 6707485 Fixed response handling in plugins (#393) 5d89277 Added the handling of bigints; updated deps (#335) 0fd677e Fix github commit detection 111f317 Use head_ref instead of default one on checkout 953eb4a Use update-deps fix 9b46a98 Fixed type comparison 558535e Fixed codestyle, updated tests 3c700f7 Added support for float vector data to autoschema 4554bc9 Added support for float_vector to autoschema, updated tests

github-actions[bot] commented 4 days ago

clt

👎 CLT tests in test/clt-tests/core/ test/clt-tests/expected-errors/ ✅ OK: 28 ❌ Failed: 1 ⏳ Duration: 398s 👉 Check Action Results for commit dd14915 Failed tests:

test/clt-tests/core/test-auto-schema.rec ```diff ––– input ––– rm -f /var/log/manticore/searchd.log; searchd --stopwait > /dev/null; searchd; if timeout 10 grep -qm1 '\[BUDDY\] started' <(tail -n 1000 -f /var/log/manticore/searchd.log); then echo 'Buddy started!'; else echo 'Timeout or failed!'; cat /var/log/manticore/searchd.log;fi ––– output ––– Manticore %{SEMVER} %{COMMITDATE}#!/(\sdev)?\s/!#(columnar %{SEMVER} %{COMMITDATE}) (secondary %{SEMVER} %{COMMITDATE}) (knn %{SEMVER} %{COMMITDATE}) Copyright (c) 2001-2016, Andrew Aksyonoff Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com) Copyright (c) 2017-%{YEAR}, Manticore Software LTD (https://manticoresearch.com) [#!/[0-9]{2}:[0-9]{2}.[0-9]{3}/!#] [#!/[0-9]+/!#] using config file '/etc/manticoresearch/manticore.conf' (%{NUMBER} chars)... starting daemon version '%{SEMVER} %{COMMITDATE}#!/(\sdev)?\s/!#(columnar %{SEMVER} %{COMMITDATE}) (secondary %{SEMVER} %{COMMITDATE}) (knn %{SEMVER} %{COMMITDATE})' ... listening on %{IPADDR}:9312 for sphinx and http(s) listening on %{IPADDR}:9306 for mysql listening on %{IPADDR}:9308 for sphinx and http(s) Buddy started! ––– input ––– mysql -h0 -P9306 -e "drop table test" ––– output ––– ERROR 1064 (42000) at line 1: DROP TABLE failed: unknown table 'test' ––– input ––– curl -X POST "localhost:9308/sql?mode=raw" -d "insert into test(id, f, a, b, j, m, d, v) values (1, 'sample text', 42, 3.1415, '{\"key\": \"value\"}', (1, 2, 3), 1625142600, '[12345678901234, 56789012345678]')"; echo ––– output ––– [{"total":1,"error":"","warning":""}] ––– input ––– mysql -h0 -P9306 -e "select * from test" ––– output ––– - +------+-------------+----------------------------------+------+----------+-----------------+-------+------------+ + +------+-------------+------+----------+-----------------+-------+------------+---------------------------------+ - | id | f | v | a | b | j | m | d | + | id | f | a | b | j | m | d | v | - +------+-------------+----------------------------------+------+----------+-----------------+-------+------------+ + +------+-------------+------+----------+-----------------+-------+------------+---------------------------------+ - | 1 | sample text | [12345678901234, 56789012345678] | 42 | 3.141500 | {"key":"value"} | 1,2,3 | 1625142600 | + | 1 | sample text | 42 | 3.141500 | {"key":"value"} | 1,2,3 | 1625142600 | [12345678901234,56789012345678] | - +------+-------------+----------------------------------+------+----------+-----------------+-------+------------+ + +------+-------------+------+----------+-----------------+-------+------------+---------------------------------+ ––– input ––– mysql -h0 -P9306 -e "describe test" ––– output ––– +-------+--------+----------------+ | Field | Type | Properties | +-------+--------+----------------+ | id | bigint | | | f | text | indexed stored | - | v | text | indexed stored | + | a | uint | | - | a | uint | | + | b | float | | - | b | float | | + | j | json | | - | j | json | | + | m | mva | | - | m | mva | | + | d | uint | | - | d | uint | | + | v | json | | +-------+--------+----------------+ ––– input ––– curl -X POST "localhost:9308/sql?mode=raw" -d "insert into test2(id, model, sold, date_added, storage_capacity, price, additional_info, vector) VALUES (1, 'Model_1', 1, 1620590570251, 512, 654.19, '{\"features\": [\"Feature_1\", \"Feature_2\"]}', '[0.1, 0.2, 0.3, 0.4]'), (2, 'Model_2', 1, 1689374130160, 128, 663.70, '{\"features\": [\"Feature_1\", \"Feature_2\"]}', '[0.5, -0.3, 0.9, -0.1]')"; echo ––– output ––– [{"total":2,"error":"","warning":""}] ––– input ––– mysql -h0 -P9306 -e "select * from test2" ––– output ––– - +------+---------+------------------------+------+---------------+------------------+------------+----------------------------------------+ + +------+---------+------+---------------+------------------+------------+----------------------------------------+-----------------------------------------+ - | id | model | vector | sold | date_added | storage_capacity | price | additional_info | + | id | model | sold | date_added | storage_capacity | price | additional_info | vector | - +------+---------+------------------------+------+---------------+------------------+------------+----------------------------------------+ + +------+---------+------+---------------+------------------+------------+----------------------------------------+-----------------------------------------+ - | 1 | Model_1 | [0.1, 0.2, 0.3, 0.4] | 1 | 1620590570251 | 512 | 654.190002 | {"features":["Feature_1","Feature_2"]} | + | 1 | Model_1 | 1 | 1620590570251 | 512 | 654.190002 | {"features":["Feature_1","Feature_2"]} | [0.100000,0.200000,0.300000,0.400000] | - | 2 | Model_2 | [0.5, -0.3, 0.9, -0.1] | 1 | 1689374130160 | 128 | 663.700012 | {"features":["Feature_1","Feature_2"]} | + | 2 | Model_2 | 1 | 1689374130160 | 128 | 663.700012 | {"features":["Feature_1","Feature_2"]} | [0.500000,-0.300000,0.900000,-0.100000] | - +------+---------+------------------------+------+---------------+------------------+------------+----------------------------------------+ + +------+---------+------+---------------+------------------+------------+----------------------------------------+-----------------------------------------+ ––– input ––– mysql -h0 -P9306 -e "describe test2" ––– output ––– +------------------+--------+----------------+ | Field | Type | Properties | +------------------+--------+----------------+ | id | bigint | | | model | text | indexed stored | - | vector | text | indexed stored | + | sold | uint | | - | sold | uint | | + | date_added | bigint | | - | date_added | bigint | | + | storage_capacity | uint | | - | storage_capacity | uint | | + | price | float | | - | price | float | | + | additional_info | json | | - | additional_info | json | | + | vector | json | | +------------------+--------+----------------+ ```
github-actions[bot] commented 4 days ago

clt

👎 CLT tests in test/clt-tests/core/ test/clt-tests/expected-errors/ ✅ OK: 28 ❌ Failed: 1 ⏳ Duration: 347s 👉 Check Action Results for commit 69cb317 Failed tests:

test/clt-tests/core/test-auto-schema.rec ```diff ––– input ––– rm -f /var/log/manticore/searchd.log; searchd --stopwait > /dev/null; searchd; if timeout 10 grep -qm1 '\[BUDDY\] started' <(tail -n 1000 -f /var/log/manticore/searchd.log); then echo 'Buddy started!'; else echo 'Timeout or failed!'; cat /var/log/manticore/searchd.log;fi ––– output ––– Manticore %{SEMVER} %{COMMITDATE}#!/(\sdev)?\s/!#(columnar %{SEMVER} %{COMMITDATE}) (secondary %{SEMVER} %{COMMITDATE}) (knn %{SEMVER} %{COMMITDATE}) Copyright (c) 2001-2016, Andrew Aksyonoff Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com) Copyright (c) 2017-%{YEAR}, Manticore Software LTD (https://manticoresearch.com) [#!/[0-9]{2}:[0-9]{2}.[0-9]{3}/!#] [#!/[0-9]+/!#] using config file '/etc/manticoresearch/manticore.conf' (%{NUMBER} chars)... starting daemon version '%{SEMVER} %{COMMITDATE}#!/(\sdev)?\s/!#(columnar %{SEMVER} %{COMMITDATE}) (secondary %{SEMVER} %{COMMITDATE}) (knn %{SEMVER} %{COMMITDATE})' ... listening on %{IPADDR}:9312 for sphinx and http(s) listening on %{IPADDR}:9306 for mysql listening on %{IPADDR}:9308 for sphinx and http(s) Buddy started! ––– input ––– mysql -h0 -P9306 -e "drop table test" ––– output ––– ERROR 1064 (42000) at line 1: DROP TABLE failed: unknown table 'test' ––– input ––– curl -X POST "localhost:9308/sql?mode=raw" -d "insert into test(id, f, a, b, j, m, d, v) values (1, 'sample text', 42, 3.1415, '{\"key\": \"value\"}', (1, 2, 3), 1625142600, '[12345678901234, 56789012345678]')"; echo ––– output ––– [{"total":1,"error":"","warning":""}] ––– input ––– mysql -h0 -P9306 -e "select * from test" ––– output ––– - +------+-------------+----------------------------------+------+----------+-----------------+-------+------------+ + +------+-------------+------+----------+-----------------+-------+------------+---------------------------------+ - | id | f | v | a | b | j | m | d | + | id | f | a | b | j | m | d | v | - +------+-------------+----------------------------------+------+----------+-----------------+-------+------------+ + +------+-------------+------+----------+-----------------+-------+------------+---------------------------------+ - | 1 | sample text | [12345678901234, 56789012345678] | 42 | 3.141500 | {"key":"value"} | 1,2,3 | 1625142600 | + | 1 | sample text | 42 | 3.141500 | {"key":"value"} | 1,2,3 | 1625142600 | [12345678901234,56789012345678] | - +------+-------------+----------------------------------+------+----------+-----------------+-------+------------+ + +------+-------------+------+----------+-----------------+-------+------------+---------------------------------+ ––– input ––– mysql -h0 -P9306 -e "describe test" ––– output ––– +-------+--------+----------------+ | Field | Type | Properties | +-------+--------+----------------+ | id | bigint | | | f | text | indexed stored | - | v | text | indexed stored | + | a | uint | | - | a | uint | | + | b | float | | - | b | float | | + | j | json | | - | j | json | | + | m | mva | | - | m | mva | | + | d | uint | | - | d | uint | | + | v | json | | +-------+--------+----------------+ ––– input ––– curl -X POST "localhost:9308/sql?mode=raw" -d "insert into test2(id, model, sold, date_added, storage_capacity, price, additional_info, vector) VALUES (1, 'Model_1', 1, 1620590570251, 512, 654.19, '{\"features\": [\"Feature_1\", \"Feature_2\"]}', '[0.1, 0.2, 0.3, 0.4]'), (2, 'Model_2', 1, 1689374130160, 128, 663.70, '{\"features\": [\"Feature_1\", \"Feature_2\"]}', '[0.5, -0.3, 0.9, -0.1]')"; echo ––– output ––– [{"total":2,"error":"","warning":""}] ––– input ––– mysql -h0 -P9306 -e "select * from test2" ––– output ––– - +------+---------+------------------------+------+---------------+------------------+------------+----------------------------------------+ + +------+---------+------+---------------+------------------+------------+----------------------------------------+-----------------------------------------+ - | id | model | vector | sold | date_added | storage_capacity | price | additional_info | + | id | model | sold | date_added | storage_capacity | price | additional_info | vector | - +------+---------+------------------------+------+---------------+------------------+------------+----------------------------------------+ + +------+---------+------+---------------+------------------+------------+----------------------------------------+-----------------------------------------+ - | 1 | Model_1 | [0.1, 0.2, 0.3, 0.4] | 1 | 1620590570251 | 512 | 654.190002 | {"features":["Feature_1","Feature_2"]} | + | 1 | Model_1 | 1 | 1620590570251 | 512 | 654.190002 | {"features":["Feature_1","Feature_2"]} | [0.100000,0.200000,0.300000,0.400000] | - | 2 | Model_2 | [0.5, -0.3, 0.9, -0.1] | 1 | 1689374130160 | 128 | 663.700012 | {"features":["Feature_1","Feature_2"]} | + | 2 | Model_2 | 1 | 1689374130160 | 128 | 663.700012 | {"features":["Feature_1","Feature_2"]} | [0.500000,-0.300000,0.900000,-0.100000] | - +------+---------+------------------------+------+---------------+------------------+------------+----------------------------------------+ + +------+---------+------+---------------+------------------+------------+----------------------------------------+-----------------------------------------+ ––– input ––– mysql -h0 -P9306 -e "describe test2" ––– output ––– +------------------+--------+----------------+ | Field | Type | Properties | +------------------+--------+----------------+ | id | bigint | | | model | text | indexed stored | - | vector | text | indexed stored | + | sold | uint | | - | sold | uint | | + | date_added | bigint | | - | date_added | bigint | | + | storage_capacity | uint | | - | storage_capacity | uint | | + | price | float | | - | price | float | | + | additional_info | json | | - | additional_info | json | | + | vector | json | | +------------------+--------+----------------+ ```
github-actions[bot] commented 2 days ago

clt

👎 CLT tests in test/clt-tests/core/ test/clt-tests/expected-errors/ ✅ OK: 28 ❌ Failed: 1 ⏳ Duration: 351s 👉 Check Action Results for commit b107169 Failed tests:

test/clt-tests/core/test-auto-schema.rec ```diff ––– input ––– rm -f /var/log/manticore/searchd.log; searchd --stopwait > /dev/null; searchd; if timeout 10 grep -qm1 '\[BUDDY\] started' <(tail -n 1000 -f /var/log/manticore/searchd.log); then echo 'Buddy started!'; else echo 'Timeout or failed!'; cat /var/log/manticore/searchd.log;fi ––– output ––– Manticore %{SEMVER} %{COMMITDATE}#!/(\sdev)?\s/!#(columnar %{SEMVER} %{COMMITDATE}) (secondary %{SEMVER} %{COMMITDATE}) (knn %{SEMVER} %{COMMITDATE}) Copyright (c) 2001-2016, Andrew Aksyonoff Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com) Copyright (c) 2017-%{YEAR}, Manticore Software LTD (https://manticoresearch.com) [#!/[0-9]{2}:[0-9]{2}.[0-9]{3}/!#] [#!/[0-9]+/!#] using config file '/etc/manticoresearch/manticore.conf' (%{NUMBER} chars)... starting daemon version '%{SEMVER} %{COMMITDATE}#!/(\sdev)?\s/!#(columnar %{SEMVER} %{COMMITDATE}) (secondary %{SEMVER} %{COMMITDATE}) (knn %{SEMVER} %{COMMITDATE})' ... listening on %{IPADDR}:9312 for sphinx and http(s) listening on %{IPADDR}:9306 for mysql listening on %{IPADDR}:9308 for sphinx and http(s) Buddy started! ––– input ––– mysql -h0 -P9306 -e "drop table test" ––– output ––– ERROR 1064 (42000) at line 1: DROP TABLE failed: unknown table 'test' ––– input ––– curl -X POST "localhost:9308/sql?mode=raw" -d "insert into test(id, f, a, b, j, m, d, v) values (1, 'sample text', 42, 3.1415, '{\"key\": \"value\"}', (1, 2, 3), 1625142600, '[12345678901234, 56789012345678]')"; echo ––– output ––– [{"total":1,"error":"","warning":""}] ––– input ––– mysql -h0 -P9306 -e "select * from test" ––– output ––– - +------+-------------+------+----------+-----------------+-------+------------+---------------------------------+ + +------+-------------+----------------------------------+------+----------+-----------------+-------+------------+ - | id | f | a | b | j | m | d | v | + | id | f | v | a | b | j | m | d | - +------+-------------+------+----------+-----------------+-------+------------+---------------------------------+ + +------+-------------+----------------------------------+------+----------+-----------------+-------+------------+ - | 1 | sample text | 42 | 3.141500 | {"key":"value"} | 1,2,3 | 1625142600 | [12345678901234,56789012345678] | + | 1 | sample text | [12345678901234, 56789012345678] | 42 | 3.141500 | {"key":"value"} | 1,2,3 | 1625142600 | - +------+-------------+------+----------+-----------------+-------+------------+---------------------------------+ + +------+-------------+----------------------------------+------+----------+-----------------+-------+------------+ ––– input ––– mysql -h0 -P9306 -e "describe test" ––– output ––– +-------+--------+----------------+ | Field | Type | Properties | +-------+--------+----------------+ | id | bigint | | | f | text | indexed stored | - | a | uint | | + | v | text | indexed stored | - | b | float | | + | a | uint | | - | j | json | | + | b | float | | - | m | mva | | + | j | json | | - | d | uint | | + | m | mva | | - | v | json | | + | d | uint | | +-------+--------+----------------+ ––– input ––– curl -X POST "localhost:9308/sql?mode=raw" -d "insert into test2(id, model, sold, date_added, storage_capacity, price, additional_info, vector) VALUES (1, 'Model_1', 1, 1620590570251, 512, 654.19, '{\"features\": [\"Feature_1\", \"Feature_2\"]}', '[0.1, 0.2, 0.3, 0.4]'), (2, 'Model_2', 1, 1689374130160, 128, 663.70, '{\"features\": [\"Feature_1\", \"Feature_2\"]}', '[0.5, -0.3, 0.9, -0.1]')"; echo ––– output ––– [{"total":2,"error":"","warning":""}] ––– input ––– mysql -h0 -P9306 -e "select * from test2" ––– output ––– - +------+---------+------+---------------+------------------+------------+----------------------------------------+-----------------------------------------+ + +------+---------+------------------------+------+---------------+------------------+------------+----------------------------------------+ - | id | model | sold | date_added | storage_capacity | price | additional_info | vector | + | id | model | vector | sold | date_added | storage_capacity | price | additional_info | - +------+---------+------+---------------+------------------+------------+----------------------------------------+-----------------------------------------+ + +------+---------+------------------------+------+---------------+------------------+------------+----------------------------------------+ - | 1 | Model_1 | 1 | 1620590570251 | 512 | 654.190002 | {"features":["Feature_1","Feature_2"]} | [0.100000,0.200000,0.300000,0.400000] | + | 1 | Model_1 | [0.1, 0.2, 0.3, 0.4] | 1 | 1620590570251 | 512 | 654.190002 | {"features":["Feature_1","Feature_2"]} | - | 2 | Model_2 | 1 | 1689374130160 | 128 | 663.700012 | {"features":["Feature_1","Feature_2"]} | [0.500000,-0.300000,0.900000,-0.100000] | + | 2 | Model_2 | [0.5, -0.3, 0.9, -0.1] | 1 | 1689374130160 | 128 | 663.700012 | {"features":["Feature_1","Feature_2"]} | - +------+---------+------+---------------+------------------+------------+----------------------------------------+-----------------------------------------+ + +------+---------+------------------------+------+---------------+------------------+------------+----------------------------------------+ ––– input ––– mysql -h0 -P9306 -e "describe test2" ––– output ––– +------------------+--------+----------------+ | Field | Type | Properties | +------------------+--------+----------------+ | id | bigint | | | model | text | indexed stored | - | sold | uint | | + | vector | text | indexed stored | - | date_added | bigint | | + | sold | uint | | - | storage_capacity | uint | | + | date_added | bigint | | - | price | float | | + | storage_capacity | uint | | - | additional_info | json | | + | price | float | | - | vector | json | | + | additional_info | json | | +------------------+--------+----------------+ ```
github-actions[bot] commented 1 day ago

clt

👎 CLT tests in test/clt-tests/core/ test/clt-tests/expected-errors/ ✅ OK: 28 ❌ Failed: 1 ⏳ Duration: 351s 👉 Check Action Results for commit 0b25aa6 Failed tests:

test/clt-tests/core/test-auto-schema.rec ```diff ––– input ––– rm -f /var/log/manticore/searchd.log; searchd --stopwait > /dev/null; searchd; if timeout 10 grep -qm1 '\[BUDDY\] started' <(tail -n 1000 -f /var/log/manticore/searchd.log); then echo 'Buddy started!'; else echo 'Timeout or failed!'; cat /var/log/manticore/searchd.log;fi ––– output ––– Manticore %{SEMVER} %{COMMITDATE}#!/(\sdev)?\s/!#(columnar %{SEMVER} %{COMMITDATE}) (secondary %{SEMVER} %{COMMITDATE}) (knn %{SEMVER} %{COMMITDATE}) Copyright (c) 2001-2016, Andrew Aksyonoff Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com) Copyright (c) 2017-%{YEAR}, Manticore Software LTD (https://manticoresearch.com) [#!/[0-9]{2}:[0-9]{2}.[0-9]{3}/!#] [#!/[0-9]+/!#] using config file '/etc/manticoresearch/manticore.conf' (%{NUMBER} chars)... starting daemon version '%{SEMVER} %{COMMITDATE}#!/(\sdev)?\s/!#(columnar %{SEMVER} %{COMMITDATE}) (secondary %{SEMVER} %{COMMITDATE}) (knn %{SEMVER} %{COMMITDATE})' ... listening on %{IPADDR}:9312 for sphinx and http(s) listening on %{IPADDR}:9306 for mysql listening on %{IPADDR}:9308 for sphinx and http(s) Buddy started! ––– input ––– mysql -h0 -P9306 -e "drop table test" ––– output ––– ERROR 1064 (42000) at line 1: DROP TABLE failed: unknown table 'test' ––– input ––– curl -X POST "localhost:9308/sql?mode=raw" -d "insert into test(id, f, a, b, j, m, d, v) values (1, 'sample text', 42, 3.1415, '{\"key\": \"value\"}', (1, 2, 3), 1625142600, '[12345678901234, 56789012345678]')"; echo ––– output ––– [{"total":1,"error":"","warning":""}] ––– input ––– mysql -h0 -P9306 -e "select * from test" ––– output ––– - +------+-------------+------+----------+-----------------+-------+------------+---------------------------------+ + +------+-------------+----------------------------------+------+----------+-----------------+-------+------------+ - | id | f | a | b | j | m | d | v | + | id | f | v | a | b | j | m | d | - +------+-------------+------+----------+-----------------+-------+------------+---------------------------------+ + +------+-------------+----------------------------------+------+----------+-----------------+-------+------------+ - | 1 | sample text | 42 | 3.141500 | {"key":"value"} | 1,2,3 | 1625142600 | [12345678901234,56789012345678] | + | 1 | sample text | [12345678901234, 56789012345678] | 42 | 3.141500 | {"key":"value"} | 1,2,3 | 1625142600 | - +------+-------------+------+----------+-----------------+-------+------------+---------------------------------+ + +------+-------------+----------------------------------+------+----------+-----------------+-------+------------+ ––– input ––– mysql -h0 -P9306 -e "describe test" ––– output ––– +-------+--------+----------------+ | Field | Type | Properties | +-------+--------+----------------+ | id | bigint | | | f | text | indexed stored | - | a | uint | | + | v | text | indexed stored | - | b | float | | + | a | uint | | - | j | json | | + | b | float | | - | m | mva | | + | j | json | | - | d | uint | | + | m | mva | | - | v | json | | + | d | uint | | +-------+--------+----------------+ ––– input ––– curl -X POST "localhost:9308/sql?mode=raw" -d "insert into test2(id, model, sold, date_added, storage_capacity, price, additional_info, vector) VALUES (1, 'Model_1', 1, 1620590570251, 512, 654.19, '{\"features\": [\"Feature_1\", \"Feature_2\"]}', '[0.1, 0.2, 0.3, 0.4]'), (2, 'Model_2', 1, 1689374130160, 128, 663.70, '{\"features\": [\"Feature_1\", \"Feature_2\"]}', '[0.5, -0.3, 0.9, -0.1]')"; echo ––– output ––– [{"total":2,"error":"","warning":""}] ––– input ––– mysql -h0 -P9306 -e "select * from test2" ––– output ––– - +------+---------+------+---------------+------------------+------------+----------------------------------------+-----------------------------------------+ + +------+---------+------------------------+------+---------------+------------------+------------+----------------------------------------+ - | id | model | sold | date_added | storage_capacity | price | additional_info | vector | + | id | model | vector | sold | date_added | storage_capacity | price | additional_info | - +------+---------+------+---------------+------------------+------------+----------------------------------------+-----------------------------------------+ + +------+---------+------------------------+------+---------------+------------------+------------+----------------------------------------+ - | 1 | Model_1 | 1 | 1620590570251 | 512 | 654.190002 | {"features":["Feature_1","Feature_2"]} | [0.100000,0.200000,0.300000,0.400000] | + | 1 | Model_1 | [0.1, 0.2, 0.3, 0.4] | 1 | 1620590570251 | 512 | 654.190002 | {"features":["Feature_1","Feature_2"]} | - | 2 | Model_2 | 1 | 1689374130160 | 128 | 663.700012 | {"features":["Feature_1","Feature_2"]} | [0.500000,-0.300000,0.900000,-0.100000] | + | 2 | Model_2 | [0.5, -0.3, 0.9, -0.1] | 1 | 1689374130160 | 128 | 663.700012 | {"features":["Feature_1","Feature_2"]} | - +------+---------+------+---------------+------------------+------------+----------------------------------------+-----------------------------------------+ + +------+---------+------------------------+------+---------------+------------------+------------+----------------------------------------+ ––– input ––– mysql -h0 -P9306 -e "describe test2" ––– output ––– +------------------+--------+----------------+ | Field | Type | Properties | +------------------+--------+----------------+ | id | bigint | | | model | text | indexed stored | - | sold | uint | | + | vector | text | indexed stored | - | date_added | bigint | | + | sold | uint | | - | storage_capacity | uint | | + | date_added | bigint | | - | price | float | | + | storage_capacity | uint | | - | additional_info | json | | + | price | float | | - | vector | json | | + | additional_info | json | | +------------------+--------+----------------+ ```
PavelShilin89 commented 1 day ago

@Nick-S-2018 What changed? Why is vector back to TEXT instead of JSON?