[FEA] Generate a detailed report for the write ops

[amahussein]

Is your feature request related to a problem? Please describe.

QualTool pulls writeFormats and then filters them out to report the types that are not supported.
This is reported in rapids_4_spark_qualification_output.csv column Unsupported Write Data Format

spark-rapids-tools/core/src/main/scala/org/apache/spark/sql/rapids/tool/qualification/QualificationAppInfo.scala

Line 508 in 58c5964

val writeFormat = writeFormatNotSupported(writeDataFormat)

This only reports write formats that are not supported.

Describe the solution you'd like

We like to have a details report of the writing Ops similar to the data_source_information.csv

The report should include:

• writing operations arguments
• format schema
• the target of the writing ops. (file, table..etc)

Changes required to support this feature

• pull all the information related to writeExecs from the SqlPlanInfo
• Parse the plan and identify the target, source, schema, format..etc
• store the writeFormats in a table to report them at the end.

challenges

We may face some challenges:

• dealing with different write ops like Hive/hadoop/delta..etc.
• different write drivers customized by each customer. It may be challenging to know how to parse those plans unless we have a sample eventlog
• some information might be missing in the eventlogs: truncated schema, AQE truncated final plan..etc
• we need large set of eventlogs for testing.