Details
-
Type:
Task
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Fix Version/s: 10.0.17
-
Component/s: Storage Engine - Connect
-
Labels:
Description
A JSON table type for CONNECT would be very welcome.
It is not uncommon for JSON data structures to have a fixed structure - thus, the data can be inserted into a relational table. Many programs and web services export data in JSON nowadays.
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Interesting comment, Roberto. The first style is much more used, so in my opinion it is the most important one. But the second style is much more compact and it is just perfect for tables, so implementing it would be useful.
i think we could close this as duplicated of https://mariadb.com/kb/en/mariadb/connect-json-table-type/
Olivier Bertrand, I've just noticed this task. It might be already done, then you can close it at once.
The JSON table type is now supported by CONNECT. See the online documentation for details.
Note: Fix version is given as 10.0.17 but a first version of this implementation is already included in version 10.016.
very interesting, i have some doubts about the file format and json structure
the json is sometimes referred as 'new csv' file format, the problem is, what file format will connect support? for example... how we will create rows and cell with json format? or we will execute a json->xml convert and after use the xml format of connect ? some exemple of json formats
[ {'colum1':'value','colume2':'value'}, // row 1 {'colum1':'value','colume2':'value'}, // row 2 ... etc ] check that this format allow a dynamic column use! {'column1':{'dinamic_colomn':1234,'blabla':234},'column2':'value'} ....or we will use something like
{ 'columns':['column1','column2','column3' .... ], 'rows':[ ['a','b','c'], // row 1 ['a','b','c'], // row 2 ['a','b','c'], // row 3 ] } we support dynamic too... ['a',{'dynamic_column':1234},'c'], // row 3or any other format?