Can anyone recommend a good book on current Hive? The ones I've come across
on Amazon have reviews stating that they're quite outdated.
Are you using SQL Authorisation? If you create tables using the hive cli,
you won't be able to select the table from a connection to the hive
server.
On Thu, 18 Apr 2019 at 04:34, Alan Gates wrote:
> See
>
8 AM, Devopam Mittra wrote:
>
> Please try with subquery alias .
> Regards
>
>
> On Mon, Dec 9, 2019, 6:06 AM Dan Horne wrote:
>
>> Hi All
>>
>> I'm trying to run the following subquery but it returns an error that
>> says "cannot recognize
Hi All
I'm trying to run the following subquery but it returns an error that says
"cannot recognize input near 'select' 'max' '(' in expression specification"
select id,
first_name,
last_name,
change_seq
from person_source
where change_seq >
(select max(change_seq) from person_target);