I'm using wrangler component of cloud data fusion. I want to set new column with current date.
set-column :current_date new("java.time.LocalDateTime.now()");
Throws "The preview of the pipeline "test" has failed. Please check the logs for more information." error for me and many similar code doesn't work too. Logs show nothing code related, only messages like "Failed to add file to Spark environment" or "Aborting task". I'm sure that problem is in JEXL expression because without it or with simple expression like:
var a = 5+5; a
it works fine.
Is it possible to set column with current date?
To add a column with current date, you can use the Add Field transform plugin. It is available from the Hub > Field Adder Transform. For the Field Value property, you can set it as:
${logicalStartTime(yyyy-MM-dd'T'HH-mm-ss)}
On what's possible with Wrangler, here is a cheat sheet blog post.