prestodb/presto · error · ViewNotFoundException

View '%s' not found

Error message

View '%s' not found

What it means

TestingMetadata.dropView: the named view does not exist in this test connector's in-memory map, so the drop is refused. The %s names the view that was not found; this guard lets tests assert drop-missing behavior.

Source

Thrown at presto-main-base/src/main/java/com/facebook/presto/testing/TestingMetadata.java:220

    }

    @Override
    public void createView(ConnectorSession session, ConnectorTableMetadata viewMetadata, String viewData, boolean replace)
    {
        SchemaTableName viewName = viewMetadata.getTable();
        if (replace) {
            views.put(viewName, viewData);
        }
        else if (views.putIfAbsent(viewName, viewData) != null) {
            throw new PrestoException(ALREADY_EXISTS, "View already exists: " + viewName);
        }
    }

    @Override
    public void dropView(ConnectorSession session, SchemaTableName viewName)
    {
        if (views.remove(viewName) == null) {
            throw new ViewNotFoundException(viewName);
        }
    }

    @Override
    public List<SchemaTableName> listViews(ConnectorSession session, Optional<String> schemaName)
    {
        ImmutableList.Builder<SchemaTableName> builder = ImmutableList.builder();
        for (SchemaTableName viewName : views.keySet()) {
            if (schemaName.map(viewName.getSchemaName()::equals).orElse(true)) {
                builder.add(viewName);
            }
        }
        return builder.build();
    }

    @Override
    public Map<SchemaTableName, ConnectorViewDefinition> getViews(ConnectorSession session, SchemaTablePrefix prefix)
    {

View on GitHub (pinned to 55bb57d202)

Solutions

1. Verify the view exists (SHOW CREATE VIEW) before dropping
2. Check schema and view name spelling
3. Create the view before the drop in the test sequence

When it happens

Trigger: Thrown at presto-main-base/src/main/java/com/facebook/presto/testing/TestingMetadata.java:220 when the library encounters an invalid state.

Common situations: See trigger scenarios.

AI-assisted analysis of prestodb/presto@55bb57d202 (2026-09-04). Data as JSON: /api/errors/8b4d0e173c91c2e3. Report an issue: GitHub.