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]
  -----------------------------------------------;
已提问 2 年前205 查看次数
1 回答
0

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

profile pictureAWS
已回答 2 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则