Hi Charles, Phoenix doesn’t support nested data. I suggest you take a look at other open source projects such as Apache Drill or Presto. Thanks, James
On Sat, Nov 9, 2019 at 8:16 AM Charles Wiese <[email protected]> wrote: > I was very excited about the use case of creating Patient Records with 1:M > records nested (such as Diagnosis, Procedures etc). We have done this in > MongoDB and could use a SQL driver to get the nested “rows”. I understand > that the idea of nested “rows” ate actually columns with “column_name:id” > for each “row value”. Seems a bit odd compare to a document / JSON > layout, but okay. However, how does one use a SQL driver for reporting and > “unnesting” this data? > > Is that even possible … I want to “select count(nested_procedures), > patient_type from patient group by patient_type)”….. in with Mongo driver > it is a virtual table like "select count(patient_procedures > \.nested_procedures), patient_type from patient, patient_procedures group > by patient_type)” > > Is this possible?
