Re: How to Write and Read a Nested JSON Into and From Apache Ignite Table

2019-01-14 Thread ilya.kasnacheev
Hello! You can nest BinaryObjects as deep as you need. I know that there are users who routinely serialize JSON to BinaryObject. However, you will not be actually refer to nested data in SQL queries, only to top-level values. Regards, -- Sent from: http://apache-ignite-users.70518.x6.nabble.c

Re: How to Write and Read a Nested JSON Into and From Apache Ignite Table

2018-12-17 Thread HareeshShasrtyMJ
Hello Dennis, Thank you for the response. Yes, the Objects need to have same schema. With regards to Converting to BinaryObjects, please let me know whether Nested BinaryObject fields more than one level is supported. My understanding is NO. My requirement is, 1. Write Simple and Nested JSON in

Re: How to Write and Read a Nested JSON Into and From Apache Ignite Table

2018-12-17 Thread Denis Mekhanikov
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 SQ

How to Write and Read a Nested JSON Into and From Apache Ignite Table

2018-12-16 Thread HareeshShasrtyMJ
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 Apach