Mixed storage system and mixed storage method for supporting Hive DML (data manipulation language) enhancement

The invention discloses a mixed storage system and a mixed storage method for supporting Hive DML (data manipulation language) enhancement. The storage system is established on the basis of a Dual Table and comprises a Dual Table establishing module and a Dual Table actuating module, wherein the Dual Table establishing module is used for establishing the Dual Table which comprises a main table and a secondary table, maintains unique ID (identification) of each row of data and provides a specific operation set for the external on the basis of a cost model; and the Dual Table actuating module is used for reading and querying data in the Dual Table on the basis of the main table and the secondary table of the Dual Table, changing data in the Dual Table on the basis of the secondary table of the Dual Table, implementing the operation set provided by the Dual Table on the basis of the cost model, and combining the main table and the secondary table when data are read on the basis of the unique ID of each row of ordered data.