A table is the data storage unit in MaxCompute. A table is a two-dimensional data structure composed of rows and columns. Each row represents a record, and each column represents a field with the same data type. One record can contain one or more columns. The column name and data type comprise the schema of a table.
- For internal tables, all data is stored in MaxCompute tables, and the columns in the table can be any of the data types supported by MaxComputeData types.
- For external tables, data is not stored in MaxCompute. Instead, table data can be stored in OSS or OTS. MaxCompute only records meta information of the table. You can use MaxCompute’s external table to process unstructured data on OSS or Table Store, such as video, audio, genetics, meteorological, and geographic information.