t8y2/dbx · error

HiveServer2 metadata failed (%v); %s fallback failed: %w

Error message

HiveServer2 metadata failed (%v); %s fallback failed: %w

What it means

listTables-style listing tries the HiveServer2 metadata provider first; when it errors, the driver falls back to SHOW TABLES/SHOW VIEWS statements. This error wraps both failures: the original metadata call (%v) and the named fallback operation (%w). Special case: for VIEW requests where SHOW TABLES already succeeded and SHOW VIEWS is unsupported by old Hive/Impala, the error is skipped and the table result is kept.

Source

Thrown at agents/drivers/argo-go/metadata.go:352

	}
	if containsString(requestedTypes, "VIEW") || containsString(requestedTypes, "MATERIALIZED VIEW") {
		fallbackQueries = append(fallbackQueries, fallbackQuery{
			operation:  "SHOW VIEWS",
			statement:  "SHOW VIEWS IN " + quoteHiveIdentifier(schema),
			objectType: "VIEW",
		})
	}
	objectsByName := make(map[string]tableInfo)
	tableFallbackSucceeded := false
	for _, fallback := range fallbackQueries {
		result, err := server.executeQuery(queryOptions{SQL: fallback.statement, MaxRows: metadataQueryLimit})
		if err != nil {
			// Older Hive and Impala versions can list tables but do not support SHOW VIEWS.
			// Keep the usable table result for mixed requests; explicit view requests still fail.
			if fallback.objectType == "VIEW" && tableFallbackSucceeded && showViewsUnsupported(err) {
				continue
			}
			return nil, fmt.Errorf("HiveServer2 metadata failed (%v); %s fallback failed: %w", metadataErr, fallback.operation, err)
		}
		if fallback.objectType == "TABLE" {
			tableFallbackSucceeded = true
		}
		for _, row := range result.Rows {
			name := showTablesRowName(result.Columns, row)
			if name == "" || !metadataNameMatches(name, constraints.Filter) {
				continue
			}
			candidate := tableInfo{Name: name, TableType: fallback.objectType, Comment: nil}
			if existing, ok := objectsByName[name]; ok && existing.TableType == "VIEW" && candidate.TableType != "VIEW" {
				continue
			}
			objectsByName[name] = candidate
		}
	}
	values := make([]tableInfo, 0, len(objectsByName))
	for _, value := range objectsByName {

View on GitHub (pinned to c0390bff16)

Solutions

1. Read the (%v) portion to fix the primary HiveServer2 metadata failure (usually permissions or session state).
2. Run the named fallback statement (e.g. SHOW TABLES IN <schema>) manually as the same user to see why it failed.
3. On old Hive/Impala, avoid view-only listing requests, or upgrade the server to a version supporting SHOW VIEWS.
4. Verify schema/table identifier spelling and quoting in the request.

// Check the server supports SHOW VIEWS before issuing view-only listings on old Hive/Impala.
result, verr := server.executeQuery(queryOptions{SQL: "SHOW VIEWS", MaxRows: 1})
supportsShowViews := verr == nil

tables, err := server.listTables(schema, opts)
if err != nil {
    if supportsShowViews == false && opts.ObjectType == "VIEW" {
        // old Hive/Impala: fall back to treating table listing as the best available result
        return tableOnlyResult, nil
    }
    return fmt.Errorf("table/view listing unavailable; check metadata privileges: %w", err)
}

When it happens

Trigger: Listing tables/views when GetHiveTables (or equivalent) metadata fails AND the corresponding SHOW TABLES / SHOW VIEWS fallback also errors. Explicit view-only requests on old Hive/Impala versions that lack SHOW VIEWS still produce this.

Common situations: Older Hive or Impala versions without SHOW VIEWS support; permission denial on both catalog metadata and SHOW statements; quoting issues in schema names passed to the fallback SQL.

Related errors

• SHOW DATABASES failed (%v); HiveServer2 metadata fallback fa
• HiveServer2 metadata failed (%v); DESCRIBE fallback failed:
• HiveServer2 table comment metadata failed (%v); table listin
• HiveServer2 metadata failed (%v); %s fallback failed: %w
• HiveServer2 table comment metadata failed (%v); table listin

AI-assisted analysis of t8y2/dbx@c0390bff16 (2026-09-05). Data as JSON: /api/errors/0c99f7786a84f0be. Report an issue: GitHub.