1

Given the input column [date_trunc(hour, timestamp)], how can the AnalysisException error of not being able to resolve 'timestamp' be resolved?

edit

• column
• timestamp

asked 2023-02-27 11:00:00 +0000

djk
21 ●1 ●1

edit retag flag offensive close merge delete

add a comment

1

answered 2021-07-01 16:00:00 +0000

pufferfish
41 ●3 ●2

The 'timestamp' field needs to be defined or selected from a specific table in the query. If the table has not been explicitly defined, add it to the query using the FROM clause, e.g. FROM mytable. If the 'timestamp' field is not in the table, it needs to be added or selected from a different table or subquery.

edit flag offensive delete link more

add a comment

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss