Tracking issues of adopting features added in OpenDAL v0.6

[Xuanwo]

OpenDAL v0.6 added the following features

• retry able operations
• hdfs services support

Read OpenDAL v0.6 Release for more information

This issue intends to track the adoption of OpenDAL v0.6:

• feat: Introduce opendal 0.6 and enable retry support #5216
• feat: Add HDFS support #5245
• ci(query): Make sure storage-hdfs is buildable #5247