[
https://issues.apache.org/jira/browse/HIVE-24050?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ruslan Krylov updated HIVE-24050:
---------------------------------
Description:
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}
was:
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}
> 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
> Fix For: 2.3.7
>
>
> 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)
