I’m trying to generate a hash based on a field but got the following error:

Query:

select standard_hash(pk_time) from schema.table

Error:

"STANDARD_HASH": invalid identifier

The column type is Integer, but I’ve also tried with other types such as varchar, date and got the same result.

As an extra comment, I started working with this function due to a partitioned table read from AWS Glue using DynamicFrame parallel reading using hashfield option.