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]
  -----------------------------------------------;
asked 2 years ago192 views
1 Answer
0

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

profile pictureAWS
answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions