I see that subqueries are possible with DP4 and I see an example in doc. Is something like this possible? If not how else can I run this?
SELECT Event,COUNT(*)
FROM (SELECT Event FROM default LIMIT 10000);
I see that subqueries are possible with DP4 and I see an example in doc. Is something like this possible? If not how else can I run this?
SELECT Event,COUNT(*)
FROM (SELECT Event FROM default LIMIT 10000);
We do not support subqueries in a FROM clause. It can usually be achieved using GROUP BY and WHERE.
In your example, did you want a GROUP BY?
Yes I missed the GROUP BY. But that still doesn’t solve the problem.
This is a pretty big database. So querying the whole database would take time. So I wanted to sample it for only 10,000 rows and then run the query.
I don’t want to build an index either as this query is a one-off ad-hoc query.
You are correct. We will be adding support for subqueries in the FROM clause. For now, you can do the following:
INSERT INTO tmp-bucket (KEY, VALUE) SELECT Event FROM … LIMIT 10000;
SELECT e, COUNT(*) FROM tmp-bucket GROUP BY …;
Thanks. That should help.
Hi @ssingaram,
FYI, we did add support for subqueries in the FROM clause.