Is there any performance result available for DeltaLake?

[ArindamHalder]

Specifically for write and read streaming data to HDFS or s3 etc. For IoT specific scenario how it performs on time series transactional data. Can we consider delta table as time series table?

[Kaniz_Fatma]

Hi @ ArindamHalder! My name is Kaniz, and I'm a technical moderator here. Great to meet you, and thanks for your question! Let's see if your peers on the Forum have an answer to your questions first. Or else I will follow up shortly with a response.

[mathan_pillai · Accepted solution]

Hi @Arindam Halder​ , Delta lake is more performant compared to a regular parquet table. pls check below for some stats on the performance

https://docs.azuredatabricks.net/_static/notebooks/delta/optimize-python.html

yes, you can use it for time series forecasting. You could watch the below video to see how forecasting is done at scale using Delta lake

https://databricks.com/session_na20/real-time-forecasting-at-scale-using-delta-lake-and-delta-cachin...

you could also find the delta streaming APIs here

https://docs.databricks.com/delta/delta-streaming.html#table-streaming-reads-and-writes

[Kaniz_Fatma]

Hi @Arindam Halder​ , How is it going?

Were you able to resolve your problem?