Hi, We're using Impala to write a few queries. I need to rollup a TIMESTAMP field up to a day level. Is there a way to CAST a TIMESTAMP field in to a DATE field? If not, are there other ways to get the same result? For context, I need to join tables on a time field, but the TIMESTAMP field is too granualr (hours, minutes, seconds) and many of the results from the join are lost. I need the field to be of the format yyyy-mm-dd. Thanks.
... View more