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
column.
With greater flexibility comes responsibility to understand certain operations better in this
environment.
—Andries
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?
|