Drill indexes

2016-03-25 Thread Wilburn, Scott
Hello, Is there a way to index or create primary keys for fields in Drill? I'm interested in indexing for performance and also for creating unique constraints. If there is no way to create indexes, then is there another way to generate a unique constraint? Thanks, Scott Wilburn

Re: Reading Avro Arrays

2016-03-25 Thread Stefán Baxter
Johannes, Jacques is right. I only tested the flattening of maps and not the flattening of list-of-maps. -Stefan On Fri, Mar 25, 2016 at 4:12 PM, Jacques Nadeau wrote: > I think there is some incorrect information and confusion in this thread. > Could you please share a

Re: Reading Avro Arrays

2016-03-25 Thread Jacques Nadeau
I think there is some incorrect information and confusion in this thread. Could you please share a piece of sample data and a specific query? The error message shown in your original email is suggesting that you were trying to flatten a map rather than an array of maps. Flatten is for arrays only.

Re: Error parsing JSON (drill 1.6.0)

2016-03-25 Thread Shankar Mane
I have opened JIRA for the same. You can track it here " https://issues.apache.org/jira/browse/DRILL-4520; For the time being I am using older approach which is *hive*. *Below are the steps I am following:* 1. Drill - Creating flattened table from HDFS json logs. But as I mentioned in trail

Re: Reading Avro Arrays

2016-03-25 Thread Johannes Schulte
Hi Stefan, thanks for this information - so it seems that there is currently no way of accessing nested rich objects with drill; I somehow got that wrong from the documentation... Cheers, Johannes On Thu, Mar 24, 2016 at 2:14 PM, Stefán Baxter wrote: > FYI: