DataWorks:Manage Hive data

Create a table

1. Click the icon on the left side of Hive Data Catalog to find the Table.

2. To the right of Table, click the icon to open the Create Table page.

3. You can generate the basic table information and field information in either of the following ways.

   • Create a table with Copilot:

     1. In the toolbar at the top of the page, click Copilot table creation to open Copilot Chat.

     2. Enter a table creation instruction in natural language, such as Create a user table.

     3. Click Generate and Replace. The system generates a default table name and field information based on your instruction.

     4. If the table name and fields meet your requirements, click Accept.

        Note

        If you need to change some table information, click Accept and then manually edit the generated table information.

   • Create a table manually:

     Create the table based on the parameter descriptions.

     Parameter	Configuration description
     Basic information	Specify the Table Name, Table Description, and other information.
     Field information	Edit the fields and field annotations. Manual editing: Above the field list, click the Insert button. After specifying the number of rows to insert, you can edit the Field Name, Data Type, and other information. Intelligent editing with Copilot:Above the field list, click Generate Field or Generate field descriptions. Based on the table name and description you entered, the system generates related fields and descriptions.

4. Optional: Configure partition information.

   To create a partitioned table, in the Partition Field area specify the number of partition field rows to add (multiple partitions are supported), and click Insert. Then, in the partition field list, configure the partition Field Name, Data Type and other related information.

5. Optional: Configure advanced settings .

   Parameter	Configuration description
   Table type	Only Internal Table.
   Storage location	You can specify the table storage directory, such as /user/hive/warehouse/hive_work .
   Storage format	Supported storage formats are CSV, PARQUET, ORC, AVRO, JSON, and SELE_DEFINE. Based on the selected format, the system automatically defines the data input and output formats and the serialization and deserialization methods. CSV: A comma-delimited text file, suitable for simple data structures. PARQUET: A columnar storage format with a high compression ratio, suitable for big data analytics. ORC: An optimized columnar storage format with strong performance and support for complex data types. AVRO: A binary format that supports schema evolution, suitable for dynamic data structures. JSON: Supports nested structures and is suitable for semi-structured data. SELE_DEFINE: Allows custom serialization and deserialization logic.

6. After configuration, click Publish in the top toolbar to create the table.

Manage tables

After creating a table in Hive Data Catalog, click the icon on the left, then click Table to open the Table page.

1. View tables.

   On the Table page, view the basic information of all tables. You can also click a table name to view its Details, Basic information and DDL information.

2. Delete a table.

   On the Table page, find the table to delete. In the Operation column, click Delete.

   Important

   Deleted tables cannot be recovered. Proceed with caution.