Re: Hive Partitioned View query error

2017-04-24 Thread pratik khadloya
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 wrote: > > > But on Hue or JDBC interface to Hive Server 2, the following error > oc

Re: Hive Partitioned View query error

2017-04-24 Thread Gopal Vijayaraghavan
> 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'; > or

Hive Partitioned View query error

2017-04-24 Thread pratik khadloya
Hello, I have created a regular view on a partitioned table. The view CREATION and SELECT query works fine on Hive CLI. hive> CREATE VIEW pk_test PARTITIONED ON (ds) AS SELECT build, ds FROM agg_build; But on Hue or JDBC interface to Hive Server 2, the following error occurs while SELECT que