Respect table-level conf compression codec `Compression` in multiple scenarios

Currently, we ignore table-specific `compression` conf when the Hive serde tables are converted to the data source tables. We also ignore it when users set `compression` in the TBLPROPERTIES instead of OPTIONS, even if the tables are native data source tables.