Re: Drill WITH clause syntax

[Daniel Barclay]

I am hitting this error. *Error: SYSTEM ERROR: NoSuchFieldError: constants*

That looks like a low-level Java error caused by a version mismatch,
as if one class is referring to a member field named "constants" in
another class, which had the field when the first class was compiled,
but field doesn't actually exist in the version of the other class
that got loaded.

Daniel


Neeraja Rentachintala wrote:

Team
Is this a valid Drill syntax (i.e 2 tables in with clause).

WITH X1
AS
(SELECT city,
AVG(review_count) AS city_reviews_avg
FROM `business.json`
GROUP BY city),
X2
AS
(SELECT X1.city, X1.city_reviews_avg,
MAX(X1.city_reviews_avg)
OVER () AS city_reviews_avg_max
FROM X1)
SELECT X2.city, X2.city_reviews_avg
FROM X2
WHERE X2.city_reviews_avg_max = X2.city_reviews_avg;

I am hitting this error. *Error: SYSTEM ERROR: NoSuchFieldError: constants*

A single table specification in WITH clause works fine.

-Neeraja

--
Daniel Barclay
MapR Technologies