Newbie Question, can I store structured sub elements?

[Zac Tolley]

I have a very scenario in which I have a film and showings, each film has
multiple showings at set times on set channels, so I have:

Movie
-----
id
title
description
duration


Showing
-----
id
movie_id
starttime
channelname



I want to know can I store this in solr so that I keep this stucture?

I did try to do an initial import with the DIH using this config:

<entity name="movie" query="SELECT * from movies">
   <field column="ID" name="id"/>
   <field column="TITLE" name="title"/>
   <field name="DESCRIPTION" name="description"/>

   <entity name="showing" query="SELECT * from showings WHERE movie_id = ${
movie.id}">
     <field column="ID" name="id"/>
     <field column="STARTTIME" name="starttime"/>
     <field column="CHANNELNAME" name="channelname"/>
   </entity>
</entity>

I was hoping, for each movie to get a sub entity with the showing like:

<doc>
   <str name="title">.....</str>
   <showing>
     <str name="channelname".....



but instead all the fields are flattened down to the top level.

I know this must be easy, what am I missing... ?