MaxCompute:Manage project data

Browse and update project data

1. In MaxCompute Studio, click Project Explorer in the left navigation pane to view your connected MaxCompute projects.

   Expanding a project reveals three nodes: Tables & Views, Functions, and Resources. Expand Tables & Views to view all tables in the project. You can then expand an individual table to view its column names and data types.

2. Click the drop-down arrow next to the Tables & Views, Functions, or Resources node to view all tables, views, functions, and resources in the project.

   Note

   • DESC TABLE operation requires the permission on the MaxCompute project.

   • MaxCompute Studio displays only tables from the associated project, not public tables.

3. In the toolbar, click the icon to refresh local metadata.

   Note

   MaxCompute Studio caches project metadata locally. If this metadata is updated on the server, you must manually refresh to load the changes.

Table and view details

1. In the Tables & Views tree, expand a table node to quickly view its columns and their data types.

2. Right-click a table name and select Show table detail to view details about the table, such as its owner, size, columns, and schema.

   The Table information section displays metadata such as the creation time, last modified time, and lifecycle. The Table schema section shows properties for each column, such as its data type and whether it is nullable. At the bottom, the Data Preview section lets you preview, import, and export table data.

3. Right-click a table name and select Find usages to find all references to the table in your scripts.

Function details

1. In the Functions tree, click the UserDefined node to view the functions that you created.

   Double-clicking a function under UserDefined, such as GetAddr, displays the decompiled Java source code in the editor pane on the right. For example:

   //
   // Source code recreated from a .class file by IntelliJ IDEA
   // (powered by FernFlower decompiler)
   //
   
   package odps.test;
   
   import ...
   
   public class GetAddr extends UDF {
       public boolean enableFileWatch = false;
       private int offset;
       private int[] index = new int[256];
       private ByteBuffer dataBuffer;
       private ByteBuffer indexBuffer;
       private Long lastModifyTime = 0L;
       private File ipFile;
       private ReentrantLock lock = new ReentrantLock();
   
       public GetAddr() {
       }
       // ...
   }

   Note

   The BuiltIn node in the Functions tree lists system built-in functions by category. Double-click a function to view its usage instructions. For details about built-in functions, see Built-in functions.

2. Double-click a user-defined function to open its code.

Resource details