Does AWS Timestream support UDFs (user defined functions)

0

Does AWS Timestream support UDFs (user defined functions) similar to the UDFs support in Amazon Athena?

AWS
Ra
已提問 2 年前檢視次數 280 次
1 個回答
0

No, Timestream doesn't support user-defined functions (UDFs) at this time.

If your function is simple enough, you might be able to accomplish your goal with a reduce function, which really lets you apply two inline functions (an input and output function) to transform your data. Here's a link to the docs,

https://docs.aws.amazon.com/timestream/latest/developerguide/timeseries-specific-constructs.functions.filter-reduce.html#w3aac25c13c13c23b9

Otherwise, you could write an AWS Lambda that consumes you table and writes back to either the same table or a different table. Timestream will support sparse columns, so you can have a lambda that is back-filling a column in a multi-measure row that initially doesn't exist for all records. You would need to read out the row, enrich it, and then write back the same data for the other columns with a higher version number.

Finally, scheduled queries are another way to automatically enrich your data. You could have a scheduled query that computes your "function" (separate query) result and pushes the record back to the same table or to a different table, in a different format. The nice thing is that the scheduled query engine will bump the version number for you. Here are the docs on scheduled queries:

https://docs.aws.amazon.com/timestream/latest/developerguide/scheduledqueries.html

NadirS
已回答 2 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南