Intelligent Functions not working on Databricks

Ask the Community
1

I am trying to add a new dimension to an existing model by using something very simple as:
epoch(datetime_field)

The expression gets parsed properly but once the new field is saved and i navigate to data into the model to see a sample data i get the error:
S1000 (80) [Simba][Hardy] (80) Syntax or semantic analysis error thrown in server while executing query. Error message from server: org.apache.hive.service.cli.HiveSQLException: Error running query: [UNRESOLVED_ROUTINE] org.apache.spark.sql.AnalysisException: [UNRESOLVED_ROUTINE] Cannot resolve routine epoch on search path [`system`.`builtin`, `system`.`sessio

What do i need to do for Databricks to be able to find this func, is it compatible ?

2

Since i was filling that expression from the visual form, the code was using @sql instead of @aql. By replacing @sql with @aql it worked.

1 Like