topic Re: Subquery does not work in Databricks Community version? in Data Engineering

Subquery does not work in Databricks Community version?

THIAM_HUATTAN — Mon, 26 Dec 2022 12:59:22 GMT

Based on Page 43, I am OK with the left join, as shown here:

However, when I try with subquery below, it fails, why?

Aviral-Bhardwaj — Mon, 26 Dec 2022 13:07:57 GMT

it must have some github link check there or you cans hare your code and data we can help you

THIAM_HUATTAN — Mon, 26 Dec 2022 14:28:39 GMT

those 3 CSV files are uploaded here:

below SQL code works when I work with SQL Server, but does not work in Databricks SQL.

select e.ename, d.loc,

(select eb.received from emp_bonus eb

where eb.empno=e.empno) as received

from emp e, dept d

where e.deptno=d.deptno

order by 2