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 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则