Right deep join SQL syntax

Jacobo — Fri, 16 Sep 2022 11:00:10 GMT

Hi.

I was trying to execute a right deep join and found that the following syntax seems to not be supported by Impala parser:

SELECT *
FROM viewA a
JOIN (
	viewB b JOIN (
		viewC c JOIN viewD d ON (c.fieldC = d.fieldD)
		) ON (b.fieldB = d.fieldD)
	) ON (a.fieldA = d.fieldD)

Also not working:

SELECT *
FROM viewA a
JOIN (
	viewB b JOIN (
		viewC c JOIN viewD d ON (c.fieldC = d.fieldD)
		) ON (b.fieldB = d.fieldD)
	) ON (a.fieldA = d.fieldD)

I can execute them by creating a full subquery in each join, but i am used to write this and does not seems to be a problem for other database parsers. Should this syntax work or it is intended to give a syntax error?

Re: Right deep join SQL syntax

Tim Armstrong — Thu, 02 Feb 2017 18:42:59 GMT

I think this is related to https://issues.cloudera.org/browse/IMPALA-4610 . I think you already discovered the workaround of using full subqueries.

question Re: Right deep join SQL syntax in Archives of Support Questions (Read Only)

Right deep join SQL syntax

Re: Right deep join SQL syntax