Hareesh, Are the object supposed to have the same schema? If yes, then JSONs may be converted to BinaryObjects. If no, then you'll have to store them as blobs or text.
If you want to access such data from SQL, your tables should have a flat structure. You may have nested binary objects, but in SQL they will look flat anyway. Take a look at the following documentation page: https://apacheignite-sql.readme.io/docs/schema-and-indexes#section-indexing-nested-objects Denis пн, 17 дек. 2018 г. в 10:00, HareeshShasrtyMJ <[email protected]>: > Hello All, > > For one of our big data platform, we are evaluating to have Apache Ignite > to > be the data store that is capable of providing, > 1. in-memory processing capabilities for performance, > 2. ANSI SQL-99 interface > 3. Standing up a Dimensional Data Model (Star Schema OR Snowflake) on the > Apache Database, > 4. Provide Interface to DB Visualization Tools viz., Tableau and Power BI, > and > 5. Ability to Write and Read a Nested JSON Into and From Apache Ignite > Table > > We have successfully evaluated all the four aforementioned features > required > for our platform. However, are currently stuck with the 5 requirement as we > are unable to insert Nested JSON into Apache Ignite table using Scala > DataFrame...we are able to load simple JSON though. > > We also followed the Ignite Documentation and articles on blogs that > suggested use of Binary Objects. > However, on evaluation, we found that even Binary Objects do not support > nested levels. > > https://issues.apache.org/jira/browse/IGNITE-6265 > https://issues.apache.org/jira/browse/IGNITE-6266 > > https://stackoverflow.com/questions/45674684/is-apache-ignite-suited-for-nosql-schema > > Hence, any support or direction or workarounds with corresponding examples > on how to handle Nested JSON with Apache Ignite would be of great help and > Appreciated. > > Thank you all in advance. > > > > ----- > > --------------------- > Thanks & Regards, > Hareesh > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
