Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- zen=# select count(*)
- zen-# from (select distinct age_segment,
- zen(# item_topic,
- zen(# source_topic,
- zen(# date_trunc('minute', to_timestamp(ts / 1000)) as dt
- zen(# from log_raw
- zen(# );
- ERROR: subquery in FROM must have an alias
- LINE 2: from (select distinct age_segment,
- ^
- HINT: For example, FROM (SELECT ...) [AS] foo.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement