t8y2/dbx · error · SQLException

Object source requires database context for Hive/Inceptor ob

Error message

Object source requires database context for Hive/Inceptor objects

What it means

For Hive/Inceptor table/view objects the source is obtained with SHOW CREATE TABLE <db>.<name>; the qualified name requires a database, built from the database/schema arguments. If both are empty the candidate set is empty and the plugin throws before issuing any SQL, because an unqualified SHOW CREATE TABLE would resolve against an arbitrary default database.

Source

Thrown at plugins/jdbc/src/main/java/app/dbx/jdbc/DbxJdbcPlugin.java:4110

                item.put("ref_column", refColumn);
                result.add(item);
            }
        } catch (SQLException | AbstractMethodError | UnsupportedOperationException ignored) {
            // Foreign keys are optional detail; generic DDL must still succeed.
        }
        return result;
    }

    private static JsonNode hive2ShowCreateObjectSource(
        Connection conn,
        String database,
        String schema,
        String name,
        String objectType
    ) throws SQLException {
        LinkedHashSet<String> candidates = hive2DatabaseCandidates(database, schema);
        if (candidates.isEmpty()) {
            throw new SQLException("Object source requires database context for Hive/Inceptor objects");
        }

        SQLException lastError = null;
        for (String candidateSchema : candidates) {
            String sql = "SHOW CREATE TABLE " + qualifiedHiveName(candidateSchema, name);
            try (Statement statement = conn.createStatement();
                 ResultSet rs = statement.executeQuery(sql)) {
                StringBuilder source = new StringBuilder();
                while (rs.next()) {
                    String line = rs.getString(1);
                    if (line == null || line.isBlank()) {
                        continue;
                    }
                    if (!source.isEmpty()) {
                        source.append('\n');
                    }
                    source.append(line);
                }

View on GitHub (pinned to c0390bff16)

Solutions

1. Supply the database (or schema) argument identifying the table's database
2. Find the owning database via SHOW TABLES across candidate databases
3. Configure a default database on the connection if supported

Example fix

// before
objectSource(conn, null, null, "events", "TABLE");
// after
objectSource(conn, "tracking", null, "events", "TABLE");

if ((database == null || database.isBlank()) && (schema == null || schema.isBlank())) {
    throw new IllegalArgumentException("database or schema is required for Hive/Inceptor object source");
}

static boolean hasText(String s) { return s != null && !s.isBlank(); }
boolean hasDbContext = hasText(database) || hasText(schema);

try {
    JsonNode src = rpc.objectSource(db, schema, name, "TABLE");
} catch (SQLException e) {
    if (e.getMessage().contains("requires database context")) {
        // resolve db via SHOW TABLES across databases, then retry
    } else throw e;
}

When it happens

Trigger: Requesting a Hive table or view source with both database and schema empty/null.

Common situations: Client UI omitted the database field; connection has no USE <db> default; API caller assumed name alone is unique across the metastore.

Understand the failure class

Background: "missing required argument" and "the following required arguments were not provided": what required-argument errors mean and how to fix them — this error's family across 20 libraries.

Related errors

• Object source requires database context for Hive/Inceptor ro
• Unsupported object_type for Hive/Inceptor routine source:
• table is required
• SQL is required
• SQL is required

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