prestodb/presto · error · SQLFeatureNotSupportedException

updateArray

Error message

updateArray

What it means

updateArray in PrestoResultSet always throws SQLFeatureNotSupportedException: Array-typed in-place row updates are unsupported because Presto result sets are read-only and java.sql.Array is not implemented by the driver.

Source

Thrown at presto-jdbc/src/main/java/com/facebook/presto/jdbc/PrestoResultSet.java:1271

    @Override
    public void updateClob(int columnIndex, Clob x)
            throws SQLException
    {
        throw new SQLFeatureNotSupportedException("updateClob");
    }

    @Override
    public void updateClob(String columnLabel, Clob x)
            throws SQLException
    {
        throw new SQLFeatureNotSupportedException("updateClob");
    }

    @Override
    public void updateArray(int columnIndex, Array x)
            throws SQLException
    {
        throw new SQLFeatureNotSupportedException("updateArray");
    }

    @Override
    public void updateArray(String columnLabel, Array x)
            throws SQLException
    {
        throw new SQLFeatureNotSupportedException("updateArray");
    }

    @Override
    public RowId getRowId(int columnIndex)
            throws SQLException
    {
        throw new SQLFeatureNotSupportedException("getRowId");
    }

    @Override
    public RowId getRowId(String columnLabel)

View on GitHub (pinned to 55bb57d202)

Solutions

  1. Execute an explicit UPDATE statement to modify array column values
  2. Read array data via supported getters and update through application logic
  3. Treat the result set as strictly read-only in code paths using Presto
Defensive patterns

Strategy: try-catch

When it happens

Trigger: Thrown at presto-jdbc/src/main/java/com/facebook/presto/jdbc/PrestoResultSet.java:1271 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/31f1328376ddecbc. Report an issue: GitHub.