Error 500310 context: num_tuples != 0

0

Hello. Redshift DB, when making a simple request, I get an error, the reason for which is not clear to me. What could be the problem?
It seems to me that the problem is in the event_timestamp field, but not sure. event_timestamp BIGINT ENCODE az64, only digits, null values are allowed.

SELECT count(*) 
FROM sa_analytics.events  e
WHERE
   e.client  IN ('25af4d33-991b-4734-bfb5-71c84a131c4e','fbdc9c91-c99e-41eb-8ff8-70146f0fced5')
   AND event_timestamp >= datediff(ms,'1970-01-01',(current_date - interval '24 hours')::date)
   AND event_timestamp IS NOT  NULL ;
  error:  Assert
  code:      1000
  context:   num_tuples != 0 - 
  query:     14198439
  location:  vec_fetcher_az64.cpp:291
  process:   query0_125_14198439 [pid=17070]
  -----------------------------------------------;
gefragt vor 2 Jahren205 Aufrufe
1 Antwort
0

i was able to execute a similar statement using the DATEDIFF function. Please open a support ticket for your error.

profile pictureAWS
beantwortet vor 2 Jahren

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen