code: def test_hive_error_msg():
      msg = (
          '{...} errorMessage="Error while compiling statement: FAILED: '
          "SemanticException [Error 10001]: Line 4"
          ":5 Table not found 'fact_ridesfdslakj'\", statusCode=3, "
          "sqlState='42S02', errorCode=10001)){...}"
      )
      assert HiveEngineSpec.extract_error_message(Exception(msg)) == (
          "hive error: Error while compiling statement: FAILED: "
          "SemanticException [Error 10001]: Line 4:5 "
          "Table not found 'fact_ridesfdslakj'"
      )
  
      e = Exception("Some string that doesn't match the regex")
      assert (
          HiveEngineSpec.extract_error_message(e) == f"hive error: {e}"
      )
  
      msg = (
          "errorCode=10001, "
          'errorMessage="Error while compiling statement"), operationHandle'
          '=None)"'
      )
      assert (
          HiveEngineSpec.extract_error_message(Exception(msg))
          == "hive error: Error while compiling statement"
      )
  
imports: from unittest import mock
  import pytest
  import pandas
  from sqlalchemy.sql import select
  from superset.db_engine_specs.hive import HiveEngineSpec, upload_to_s3
  from superset.exceptions import SupersetException
  from superset.sql_parse import Table, ParsedQuery
  from tests.integration_tests.test_app import app
label_desc: Use image node_id 9 for calling a global function with example usage: test_hive_error_msg() without return types