All geek questions in one place

"Error: unexpected. Try again." BY ACCESSION

The request failed. Error: unexpected. Try again.

I get this ambiguous error in a two-key JOIN. The search only gives me “this is a mistake, we are working on it” several months ago.

SELECT a.user_key as user_key, b.bundleid as bundleid, a.dateFirst as dateFirst FROM ( SELECT user_key, dateFirst FROM game.firstTable) as a JOIN EACH ( SELECT user_key, bundleid, timestamp FROM game.prodbundle) as b ON a.user_key = b.user_key AND a.dateFirst = b.timestamp;

Any new bugs or known issues?

+4
source share
3 answers

Yesterday we upgraded to a new version of the query engine, and there was an inconsistency in the error messages that caused the "Error: Unexpected" errors in some cases when using JOIN ON and GROUP EACH. This change has been canceled since this morning at about 10 a.m. PST.

We are still investigating whether this is simply the wrong category of resources; the error that should have been returned was exceeded or whether there was another problem.

Please let us know if you continue this problem.

+4
source

There is an error connecting timestamps, as well as a temporary fix that you can implement. You can get around it by converting them to microsends using TIMESTAMP_TO_USEC(dateFirst) into SELECT statements.

Take a look at fooobar.com/questions/1489378 / ....

+1
source

There were, but they were fixed after the change, the query now returns the correct results, as expected. Thanks.

0
source

Source: https://habr.com/ru/post/1489377/

More articles:


All Articles