So Hadoop is not meant to be a backend tool supporting SQL Server similar to how SQL Server can be used as a backend storage for Microsoft Access? ...

So does anyone have experience writing queries with multiple APPLY joins?

Well has 5.6M rows and Permit has 1.4M rows.

The SQL posted is the actual working SQL. I just started at this company (yes, these tables are in a company...

Thanks.

So I actually came up with an alternate solution shortly after making this post. However, getting an alternate solution was not my goal with this post. My goal...

ChrisM@Work (3/21/2014)

---

Check your table aliases:

SELECT s.state_name

, COUNT(DISTINCT DUPS.PermitNumber) AS NumOfDupPermits

, SUM(DistinctPermits) AS DistinctPermits

FROM States S

CROSS APPLY (

SELECT w.StateID, COUNT(*) as DistinctPermits

FROM Permit P

INNER JOIN Well W1 ON...