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,
Is it something related to the json file you used?
I tried the following query, replacing "business.json' with
cp.`employee.json`. It works fine. (no row returned, which is
expected).
0: jdbc:drill:zk=local> WITH X1
. . . . . . . . . . . > AS
. . . . . . . . . . . > (SELECT city,
. . . . . . . .
Works for me.
WITH X1
AS
(SELECT city,
AVG(review_count) AS city_reviews_avg
FROM `yelp_academic_dataset_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
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
