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/
