hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From pratik khadloya <tispra...@gmail.com>
Subject Re: Hive Partitioned View query error
Date Mon, 24 Apr 2017 22:43:33 GMT
Thanks for the quick reply Gopal.

- We are using same versions for CLI and HS2 2.1.1
- COUNT(build) gave the same error.

Any other ideas?

Regards,
Pratik



On Mon, Apr 24, 2017 at 3:36 PM Gopal Vijayaraghavan <gopalv@apache.org>
wrote:

>
> > But on Hue or JDBC interface to Hive Server 2, the following error
> occurs while SELECT querying the view.
>
> You should be getting identical errors for HS2 and CLI, so that suggests
> you might be running different CLI and HS2 versions.
>
> > SELECT COUNT(1) FROM pk_test where ds='2017-04-20';
> >
> org.apache.hadoop.hive.ql.optimizer.calcite.rules.HiveRelFieldTrimmer.trimFields(org.apache.calcite.rel.core.Project,org.apache.calcite.util.ImmutableBitSet,java.util.Set)'
> …
> > Does anyone know whats going on here?
>
> My  guess is that the CBO fieldtrimmer is getting confused that we're
> reading 0 columns from a partitioned table.
>
> Try doing
>
> SELECT COUNT(build) from pk_test where ds='2017-04-20';
>
> If that works, but the count(1) fails - then we can dig a bit deeper into
> the problem.
>
> Cheers,
> Gopal
>
>
>

Mime
View raw message