×

ADDING A PARTITION TO AN EXISTING TABLE STORED ON A DISTRIBUTED FILE SYSTEM

  • US 20190236169A1
  • Filed: 01/31/2018
  • Published: 08/01/2019
  • Est. Priority Date: 01/31/2018
  • Status: Active Grant
First Claim
Patent Images

1. A method comprising:

  • receiving, by a database system, a request to add a new column to a first table stored within a distributed file system, the first table having an associated name;

    creating, by the database system, in response to the request, a second table that includes all fields of the first table, the new column, and a new partition including data from the new column, the second table having an associated name;

    causing, by the database system, any new data sent for the first table to be included in the second table;

    causing, by the database system, in response to the request, the first table to be renamed, the renaming comprising changing a pointer of the distributed file system to refer to the renamed first table, the renaming being performed using an atomic operation;

    creating, by the database system, a view pointing to data in each of the second table and the renamed first table, the view being a virtual table created on the distributed file system;

    causing, by the database system, all data from the renamed first table to be transferred to the second table by adding pointers to the data to the second table; and

    causing, by the database system, the second table to be renamed to the name of the first table when the transfer of the data from the renamed first table to the second table is complete, the renaming comprising changing the pointer of the distributed file system to refer to the renamed second table, being performed using an atomic operation, and causing any data received after renaming the second table to be included in the renamed second table.

View all claims
  • 3 Assignments
Timeline View
Assignment View
    ×
    ×