The Read Table component reads data from MaxCompute tables. By default, the component reads the table data of the current project. To read data from tables in other projects, you must prefix the table names with the related project names.
The algorithm components of Machine Learning Designer support the following data types: DOUBLE, BIGINT, STRING, BOOLEAN, and DATETIME. The Read Table component supports all types of data. To prevent errors in other algorithm components, you can connect a data conversion component as the downstream component of the Read Table component.
You can configure the Read Table component only in the Machine Learning Platform for AI console. The following table describes the parameters of this component.
Tab | Parameter | Description |
Select Table | Table Name | The name of the MaxCompute table from which you want to read data. If you want to read data from a MaxCompute table in another project, set this parameter in the Project name.Table name format. Example: tianchi_project.weibo_data. Important If the fields in the MaxCompute table are modified, the modifications cannot be synchronized to Machine Learning Designer. You must manually configure the MaxCompute data source again. |
Partition | If the input table is a partitioned table, you can select the Partition check box and set Parameter to query data by partition. Note If the SQL Script component is the downstream component of the Read Table component, the filter condition does not take effect. You must configure the filter condition in the SQL Script component. | |
Parameter | The partition that you want to filter. This parameter is used to filter data of the partitioned table. Separate multiple partitions with commas (,). If you do not specify this parameter, the full table is used. Examples:
| |
Fields Information | Source Table Columns | After you set the Table Name parameter, the system automatically reads the table schema. |