[ https://issues.apache.org/jira/browse/HIVE-24050?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vitaliy Fuks updated HIVE-24050: -------------------------------- Fix Version/s: (was: 2.3.7) > ParseException in query with subqueries > --------------------------------------- > > Key: HIVE-24050 > URL: https://issues.apache.org/jira/browse/HIVE-24050 > Project: Hive > Issue Type: Bug > Components: Hive > Affects Versions: 3.1.2, 2.3.7 > Environment: Hadoop-3.0.0 > Hive-2.3.7, Hive-3.1.2 > Reporter: Ruslan Krylov > Assignee: Eugene Koifman > Priority: Major > > h2. > The query which runs in hive 2.1 fails in hive 2.3 with ParseException. > Hive-3.1.2 also has this issue. > *STEPS TO REPRODUCE:* > {code:java} > 1. Create tables: > CREATE TABLE IF NOT EXISTS t1 (id INT, c1 INT); > CREATE TABLE IF NOT EXISTS t2 (id INT, c2 INT); > 2. Run the query: > SELECT * FROM > ((SELECT c1 FROM t1) AS X) > JOIN > ((SELECT c2 FROM t2) AS Y) > ON > X.c1 = Y.c2; > {code} > *ACTUAL RESULT:* > The query fails with an exception you can find below. > {code:java} > hive> CREATE TABLE IF NOT EXISTS t1 (id INT, c1 INT); > OK > Time taken: 0.348 seconds > hive> CREATE TABLE IF NOT EXISTS t2 (id INT, c2 INT); > OK > Time taken: 0.186 seconds > hive> SELECT * FROM > > > > ((SELECT c1 FROM t1) AS X) > > > > JOIN > > > > ((SELECT c2 FROM t2) AS Y) > > > > ON > > > > X.c1 = Y.c2; > FAILED: ParseException line 7:21 missing ) at 'AS' near 'Y' > line 7:25 missing EOF at ')' near 'Y'{code} -- This message was sent by Atlassian Jira (v8.3.4#803005)