Examples with NewerTableAlreadyExistsException org.apache.phoenix.schema.NewerTableAlreadyExistsException used on opensource projects

Example 6 with NewerTableAlreadyExistsException

use of org.apache.phoenix.schema.NewerTableAlreadyExistsException in project phoenix by apache.

the class ConnectionQueryServicesImpl method removeNotNullConstraint.

private PhoenixConnection removeNotNullConstraint(PhoenixConnection oldMetaConnection, String schemaName, String tableName, long timestamp, String columnName) throws SQLException {
    Properties props = PropertiesUtil.deepCopy(oldMetaConnection.getClientInfo());
    props.setProperty(PhoenixRuntime.CURRENT_SCN_ATTRIB, Long.toString(timestamp));
    // Cannot go through DriverManager or you end up in an infinite loop because it'll call init again
    PhoenixConnection metaConnection = new PhoenixConnection(oldMetaConnection, this, props);
    SQLException sqlE = null;
    try {
        String dml = "UPSERT INTO " + SYSTEM_CATALOG_NAME + " (" + PhoenixDatabaseMetaData.TENANT_ID + "," + PhoenixDatabaseMetaData.TABLE_SCHEM + "," + PhoenixDatabaseMetaData.TABLE_NAME + "," + PhoenixDatabaseMetaData.COLUMN_NAME + "," + PhoenixDatabaseMetaData.NULLABLE + ") VALUES (null, ?, ?, ?, ?)";
        PreparedStatement stmt = metaConnection.prepareStatement(dml);
        stmt.setString(1, schemaName);
        stmt.setString(2, tableName);
        stmt.setString(3, columnName);
        stmt.setInt(4, ResultSetMetaData.columnNullable);
        stmt.executeUpdate();
        metaConnection.commit();
    } catch (NewerTableAlreadyExistsException e) {
        logger.warn("Table already modified at this timestamp, so assuming column already nullable: " + columnName);
    } catch (SQLException e) {
        logger.warn("Add column failed due to:" + e);
        sqlE = e;
    } finally {
        try {
            oldMetaConnection.close();
        } catch (SQLException e) {
            if (sqlE != null) {
                sqlE.setNextException(e);
            } else {
                sqlE = e;
            }
        }
        if (sqlE != null) {
            throw sqlE;
        }
    }
    return metaConnection;
}

Example 7 with NewerTableAlreadyExistsException

use of org.apache.phoenix.schema.NewerTableAlreadyExistsException in project phoenix by apache.

the class ConnectionQueryServicesImpl method addColumn.

/**
     * This closes the passed connection.
     */
private PhoenixConnection addColumn(PhoenixConnection oldMetaConnection, String tableName, long timestamp, String columns, boolean addIfNotExists) throws SQLException {
    Properties props = PropertiesUtil.deepCopy(oldMetaConnection.getClientInfo());
    props.setProperty(PhoenixRuntime.CURRENT_SCN_ATTRIB, Long.toString(timestamp));
    // Cannot go through DriverManager or you end up in an infinite loop because it'll call init again
    PhoenixConnection metaConnection = new PhoenixConnection(oldMetaConnection, this, props);
    SQLException sqlE = null;
    try {
        metaConnection.createStatement().executeUpdate("ALTER TABLE " + tableName + " ADD " + (addIfNotExists ? " IF NOT EXISTS " : "") + columns);
    } catch (NewerTableAlreadyExistsException e) {
        logger.warn("Table already modified at this timestamp, so assuming add of these columns already done: " + columns);
    } catch (SQLException e) {
        logger.warn("Add column failed due to:" + e);
        sqlE = e;
    } finally {
        try {
            oldMetaConnection.close();
        } catch (SQLException e) {
            if (sqlE != null) {
                sqlE.setNextException(e);
            } else {
                sqlE = e;
            }
        }
        if (sqlE != null) {
            throw sqlE;
        }
    }
    return metaConnection;
}