Query in quarry seems not to finish but same query runs fine in PAWS
Closed, DuplicatePublicBUG REPORT
Actions

Assigned To

None

Authored By

	Effeietsanders
	Jan 15 2022, 9:53 PM

Description

List of steps to reproduce (step by step, including full links if applicable):

Fork https://quarry.wmcloud.org/query/61554
Run the same code in paws https://public.paws.wmcloud.org/User:Martin_Urbanec/wlm-per-year-example.ipynb (thanks Urbanecm)

What happens?:
The query in paws runs very fast, the one in quarry never seems to complete.

What should have happened instead?:
The query in quarry should have either reported an error, or run at least in a reasonable amount of time? Unclear why the same query runs into problems.

Software version (if not a Wikimedia wiki), browser information, screenshots, other information, etc.:

Related Objects

Mentioned Here: T170464: Quarry cannot store results with identical column names

Event Timeline

Effeietsanders created this task.Jan 15 2022, 9:53 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJan 15 2022, 9:53 PM

Aklapper renamed this task from Query in quarry runs into trouble but same query runs fine in PAWS to Query in quarry seems not to finish but same query runs fine in PAWS.Jan 15 2022, 9:57 PM

Urbanecm subscribed.Jan 15 2022, 10:30 PM

This is probably related to T170464 try renaming your one of your same named columns, seemed to work in a fork:
https://quarry.wmcloud.org/query/63679

SELECT
    subcat.page_title,
    catlink2.cl_from,
    pg_img.page_title

became

SELECT
    subcat.page_title,
    catlink2.cl_from,
    pg_img.page_title as title2

@rook thanks, very helpful to be more aware of and silly that I didn't think of it!

I think the ticket is still valid, because expected behavior would still be that an error would be returned - but at least now I know what the error should have been.

GTrang moved this task from Backlog to Quarry replacement (Superset) on the Quarry board.Apr 30 2022, 4:20 AM

taavi closed this task as a duplicate of T170464: Quarry cannot store results with identical column names.Feb 27 2023, 1:05 PM

Query in quarry seems not to finish but same query runs fine in PAWSClosed, DuplicatePublicBUG REPORTActions

Description

Related Objects

Event Timeline

Query in quarry seems not to finish but same query runs fine in PAWS
Closed, DuplicatePublicBUG REPORT
Actions