def test_alter_table_properties(part_schema, table_name):
    stmt = ddl.AlterTable('tbl', {'bar': 2, 'foo': '1'})
    result = stmt.compile()
    expected = """\
ALTER TABLE tbl SET
TBLPROPERTIES (
  'bar'='2',
  'foo'='1'
)"""
    assert result == expected
Beispiel #2
0
    def alter(self, tbl_properties=None):
        """
        Change setting and parameters of the table.

        Parameters
        ----------
        tbl_properties : dict, optional

        Returns
        -------
        None (for now)
        """

        stmt = ddl.AlterTable(self._qualified_name,
                              tbl_properties=tbl_properties)
        return self._execute(stmt.compile())