Use of functions in the WHERE clause.

[Andy Srine <an...@gmail.com>]

Team,

Looks like Hive doesn't like functions in the WHERE clause. Any ideas on
how to deal with this? Also, I feel like this used to be supported in the
past. Am I missing something?

SELECT y, m, d FROM emp_table WHERE concat(y, m, d) > '20181216' limit 10;
FAILED: SemanticException InvalidObjectException(message:Operator
'concat(y, m, d) > '20181216'' expects to have a column name on a left
side, but got 'concat(y, m, d)' (Service: AWSGlue; Status Code: 400; Error
Code: InvalidInputException;

This is on Hive 2.3.4 on AWS EMR (metadata on AWS Glue). This works on AWS
Athena (Presto) by the way.

Thanks,
Andy

Re: HiveServer2 via a proxy

[Shawn Weeks <sw...@weeksconsulting.us>]

What proxy are you using and can you share the proxy config and beeline url your trying. 

Thanks
Shawn

Sent from my iPhone

> On Apr 3, 2019, at 2:39 AM, Andy Srine <an...@gmail.com> wrote:
> 
> Team,
> 
> Any ideas on how to connect to HiveServer2 from Beeline via a proxy server. 
> 
> I have tried everything I can think of and am using http as a transport mode, but it still doesn't work.
> 
> Thanks,
> Andy
> 

HiveServer2 via a proxy

[Andy Srine <an...@gmail.com>]

Team,

Any ideas on how to connect to HiveServer2 from Beeline via a proxy server.

I have tried everything I can think of and am using http as a transport
mode, but it still doesn't work.

Thanks,
Andy