Sure, you can do that. You do it by creating a persistent virtual column
on the attribute, using COLUMN_GET probably, and then creating a column
on that. In a presentation on JSON and MySQL / MariaDB I show a simple
example of this:
http://www.slideshare.net/blueskarlsson/using-json-with-mariad
there're others things we could support:
https://mariadb.atlassian.net/browse/MDEV-4430
https://mariadb.atlassian.net/browse/MDEV-4414
https://mariadb.atlassian.net/browse/MDEV-4419
2014-04-26 13:18 GMT-03:00 Federico Razzoli :
> If you can write an expression which returns the JSON attribute,
If you can write an expression which returns the JSON attribute, yes, the
(trivial) technique I described in the post can do that. I think that MySQL 5.7
JSON functions are not yet in MariaDB. But maybe they can be added easily?
Or again, maybe you can use MariaDB 10 regexp's?
Federico
---
Does the support for virtual columns allow an index to be created on an
attribute in a JSON object stored in a BLOB column?
http://falseisnotnull.wordpress.com/2014/04/25/descending-indexes-in-mariadb
https://mariadb.com/kb/en/virtual-columns/
--
Mark Callaghan
mdcal...@gmail.com
___
Hello,
A new question has been asked in "CONNECT" by danielkrysiak:
Hi,
I have data in CSV files. Partitioned inside a directory, one file per day,
alive (constantly written to, insert at the end). I want to load them on-line
(not once a day). Normally I would w
5 matches
Mail list logo
