Details
-
Improvement
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
Description
In Hive, the SQL:
select * from (select * from table1);
will throw an exception:
Error: Error while compiling statement: FAILED: ParseException line 1:36 cannot recognize input near '<EOF>' '<EOF>' '<EOF>' in subquery source (state=42000,code=40000)
The SQL:
select * from (select * from table1) as table2;
works well.
So when we generate the Hive SQL in the Jdbc adapter, we need to create an alias for the sub-query in the From clause.
Attachments
Issue Links
- links to