incubator-drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ted Dunning <>
Subject Re: Usage of Secondary Indexes
Date Mon, 30 Jun 2014 07:09:01 GMT

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 <> 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 <> | My
> Social Cause <> | My Blogs : LiveJournal
> <>

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message