hibernate/hibernate-orm · error · UnknownTableReferenceException

TableReferences cannot be resolved relative to DerivedTableR

Error message

TableReferences cannot be resolved relative to DerivedTableReferences - '%s' : %s

What it means

Error "TableReferences cannot be resolved relative to DerivedTableReferences - '%s' : %s" thrown in hibernate/hibernate-orm.

Source

Thrown at hibernate-core/src/main/java/org/hibernate/sql/ast/tree/from/DerivedTableReference.java:48

	@Override
	public String getTableId() {
		return null;
	}

	public List<String> getColumnNames() {
		return columnNames;
	}

	public boolean isLateral() {
		return lateral;
	}

	@Override
	public TableReference resolveTableReference(
			NavigablePath navigablePath,
			String tableExpression) {
		throw new UnknownTableReferenceException(
				tableExpression,
				"TableReferences cannot be resolved relative to DerivedTableReferences - '" + tableExpression + "' : " + navigablePath
		);
	}

	@Override
	public TableReference resolveTableReference(
			NavigablePath navigablePath,
			ValuedModelPart modelPart,
			String tableExpression) {
		throw new UnknownTableReferenceException(
				tableExpression,
				"TableReferences cannot be resolved relative to DerivedTableReferences - '" + tableExpression + "' : " + navigablePath
		);
	}

	@Override
	public TableReference getTableReference(

View on GitHub (pinned to fad1729dce)

Solutions

1. Table references cannot be resolved relative to a derived table (subquery in the FROM clause). Restructure the query so the column is qualified by a real table or expose the column from the derived table's select list.
2. If the reference is generated internally by Hibernate, report it as a Hibernate bug.

When it happens

Trigger: A table reference is resolved relative to a derived (subquery) table reference, which is not supported.

Common situations: Qualifying columns with the alias of a derived table (subquery in the FROM clause) in a way that requires resolving its inner table references.

AI-assisted analysis of hibernate/hibernate-orm@fad1729dce (2026-08-22). Data as JSON: /api/errors/e1a5f8e8fc340c1d. Report an issue: GitHub.