Mufy, Since the secondary indexes are being created in separate tables, it sounds like you want to do a relatively straightforward join. It is hard to give specific answers, however, since it isn't clear quite what kinds of queries are being done.
Can you say a bit more? Perhaps give 3 record sample data contents to illustrate? Can you say more about what queries are intended? On Sun, Jun 29, 2014 at 10:49 PM, mufy <[email protected]> wrote: > Hello, > > The following was posted on our forums. How to answer that? > > "We are using M7 tables to store data. Our structure is like > Key,AdditionalInfo, DataColumn1{Json - which can be > nested},DataColumn1{Json - which can be nested}. We create secondary > indexes while we load data, in sep m7 tables. > > We will like to use apache drill to query this data, do aggregations joins > etc Is there examples for drill with M7, i want to understand how can we > incorporate secondary Index, also if we know what are the keys from which i > want to query, how can I use that?" > > --- > Mufeed Usman > My LinkedIn <http://www.linkedin.com/pub/mufeed-usman/28/254/400> | My > Social Cause <http://www.vision2016.org.in/> | My Blogs : LiveJournal > <http://mufeed.livejournal.com> >
