I recently deployed the "Cost Anomalies" dashboard, and I'm encountering a schema mismatch error in the dataset 'ca_summary_view'. The error details are as follows:
Error Type: SQL_EXCEPTION - A general SQL error that could be due to query timeouts, resource constraints, unexpected DDL alterations, or other database errors.
Error Details: HIVE_PARTITION_SCHEMA_MISMATCH. The column 'totalimpactpercentage' in the table 'optimization_data.cost_anomaly_data' is declared as type 'double', but in the partition 'payer_id=6XXXXXXXXXX2/year=2024/month=01/day=16', it's declared as type 'int'. [Execution ID: xxxxxxxx]
I understand this indicates a discrepancy between the main table schema and one of its partitions in terms of the data type for 'totalimpactpercentage'.
Any insights or guidance on how to troubleshoot and resolve this issue would be greatly appreciated. Thank you in advance for your help!
