'' in subquery source in Hive query

Question

I am running a query on Hive similar to:

SELECT *
FROM (SELECT a
      FROM b
      WHERE
      sex = 'M'
      AND   degree = 'Bs'
      AND   age = 15
      AND   name LIKE 'L%'
      );

the error is:

cannot recognize input near '<EOF>' '<EOF>' '<EOF>' in subquery source

Did you try remove `AND` condition to see which one give you error? — Juan Carlos Oropeza, Apr 05 '17 at 16:33
"Similar to" does not help because it seems like a syntax issue — David דודו Markovitz, Apr 05 '17 at 16:37
Dudu Markovitz: by simiar, I meant I Just changed tables name to a and b and column names to age, ..., otherwise it is exactly the same. — Cyrus, Apr 05 '17 at 16:41
... and by that you have masked possible issue of reserved words — David דודו Markovitz, Apr 05 '17 at 17:01

score 38 · Accepted Answer · edited Sep 17 '17 at 00:03

38

Adding a table alias for your subquery is necessary for Hive. Below I use 't1' as the alias:

SELECT *
FROM (SELECT a
  FROM b
  WHERE
  sex = 'M'
  AND   degree = 'Bs'
  AND   age = 15
  AND   name LIKE 'L%'
  ) t1 ;

edited Sep 17 '17 at 00:03

wellplayed

943
8
16

answered Apr 06 '17 at 13:55

a m Sreekanth

370
3
7

this is great .. worked for me .. but can you please explain what difference it made exactly ? – Earthshaker Jan 11 '19 at 20:49

score 6 · Answer 2 · answered Jun 26 '17 at 22:15

6

All the down-votes are unjustified. Hive often does not produce correct error and throws lazy "EOF" at you. In this case you just need to specify table alias for your sub-query. SELECT * FROM (.....) tbl_alias

answered Jun 26 '17 at 22:15

Abay Bektursun

93
2
6

2

I guess some Hive fan is just down-voting anything that mentions hive bugs – Abay Bektursun Jun 27 '17 at 03:39

'' in subquery source in Hive query

2 Answers2