drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andries Engelbrecht <aengelbre...@maprtech.com>
Subject Re: Drill 1.0 schema changes
Date Tue, 19 May 2015 16:11:44 GMT
Seems like you are trying to do a count on a column family in MapR-DB or HBase.

Try using a specific column rather than a column family.

select count(c.personal.name) from maprdb.customers c;

Please keep in mind that Drill has to manage schema on the fly, so it can’t assume that
the schema will stay the same, thus operations like count(*) or in this case count on a column
family is very tricky to manage. For most reliable operation, it is best to select a specific

With greater flexibility comes responsibility to understand certain operations better in this


On May 19, 2015, at 8:35 AM, Jim Bates <jbates@maprtech.com> wrote:

> I was doing some basic counts on 1.0 and I noticed that drill is doing a
> schema change and I want to know if I can prevent that and only do it if I
> want it done.
> On the dill sandbox I did a count of a simple field and it worked fine:
> select COUNT(orders) from hive.orders;
> on anything with a nested JSON it throws an error
> select COUNT(personal) from maprdb.customers limit 1;
> java.lang.RuntimeException: java.sql.SQLException: UNSUPPORTED_OPERATION
> ERROR: Streaming aggregate does not support schema changes
> What is the best way to control / mitigate this?

View raw message