Re: Various ramblings of a newbie

2015-07-11 Thread Ted Dunning
The problem being referred to was one where the type of the data changed and the order in which it was encountered made a difference. For files where the schema is known early (the only thing that ordinary SQL can handle), this won't happen. Also, the problem only occurred in nested data in which

Re: DRILL on HBSE: SELECT COUNT(*) issue

2015-07-11 Thread George Lu
In my Job, I used Drill to query HBase all the time and the HBase contains billions of rows and over 20 columns, I never noticed any count errors. On Sat, Jul 11, 2015 at 3:57 AM, Steven Phillips wrote: > This looks like a bug to me. You should file a jira, and include as much > information as p

Re: Various ramblings of a newbie

2015-07-11 Thread Stefán Baxter
Hi Jacques, and thank you for answering swiftly and clearly :). Some additional questions did arise (see inline): >- *Foreign key lookups (joins)* > I'm guessing my fk_lookup scenario would/could benefit from using other storage options for that. Currently most of this is in Postgres and a

Get resulting table using C++ client

2015-07-11 Thread Oleg Shirokikh
Hello, I've built C++ client for Drill and it seems to run, but I can't get the results of the query - they are always empty... Doing same query through JDBC shell works fine.. Also I can see my C++ queries on Web UI and the status is COMPLETED... querrySubmitter query="SELECT full_name FROM cp.`e

Fwd: Get resulting table using C++ client

2015-07-11 Thread Oleg Shirokikh
Hello, I've built C++ client for Drill and it seems to run, but I can't get the results of the query - they are always empty... Doing same query through JDBC shell works fine.. Also I can see my C++ queries on Web UI and the status is COMPLETED... querrySubmitter query="SELECT full_name FROM cp.`e

Re: Various ramblings of a newbie

2015-07-11 Thread Jacques Nadeau
Hi Stefán, great to hear your thoughts. I'll try to shed some light where I can. > *Misc. observations:* > >- *Foreign key lookups (joins)* >- Coming from the traditional RDBM world I have a hard time wrapping my >head around how this can efficient/fast > Drill is primarily focused

Re: Various ramblings of a newbie

2015-07-11 Thread andrew
Hi, Thanks for this list. I think it would be helpful if you could create some JIRA tickets around these bugs at https://issues.apache.org/jira/browse/DRILL/ . It’s easier to track issues that way than by email. - A > On Jul 11, 2015, at 11:40 AM

Various ramblings of a newbie

2015-07-11 Thread Stefán Baxter
Hi, I'm new to Drill and Parquet and the following are questions/observations I made during my initial discovery phase. I'm sharing them here for other newbies but also to see if some of these concerns are invalid or based on misunderstanding. I made no list of the things that I like of what I h