Advertisement
mironovichandrei

Untitled

Feb 25th, 2020
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. zen=# select count(*)
  2. zen-# from (select distinct age_segment,
  3. zen(# item_topic,
  4. zen(# source_topic,
  5. zen(# date_trunc('minute', to_timestamp(ts / 1000)) as dt
  6. zen(# from log_raw
  7. zen(# );
  8. ERROR: subquery in FROM must have an alias
  9. LINE 2: from (select distinct age_segment,
  10. ^
  11. HINT: For example, FROM (SELECT ...) [AS] foo.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement