MySQL 8.0 Labs: JSON aggregation functions

Re:MySQL 8.0 Labs: JSON aggregation functions by morgo on Thursday October 06, 2016 @05:05PM (#12656106)

Here is an example: http://mysqlserverteam.com/indexing-json-documents-via-virtu...

The optimizer will match JSON expressions to virtual columns w/indexes. So that means you can keep your queries in this form and have them indexed:

EXPLAIN SELECT * FROM features WHERE feature->"$.properties.STREET" = 'MARKET'\G

[ Parent | on HN ]

Re:MySQL 8.0 Labs: JSON aggregation functions by malisper on Thursday October 06, 2016 @05:37PM (#12656326)

Is there a way to index JSON in MySQL without creating one index per unique field?

[ Parent | on HN ]

Re:MySQL 8.0 Labs: JSON aggregation functions by morgo on Thursday October 06, 2016 @06:31PM (#12656684)

The mapping is not strictly one index per field, but a virtual column expression must map to a MySQL type. So depending on the use-case you may be able to use more complicated expressions to limit indexes.

But to expand your question, there are two FRs we are looking at:

1) Inverted (aka FULLTEXT) indexes on JSON documents 2) Multi-value indexes

[ Parent | on HN ]