DataWorks:Hive data management

Create a table

1. Click the icon to the left of the Hive data catalog to expand the tree, and find Table under the database.

2. Click the icon to the right of Table to go to the Create Table page.

3. You can generate the basic table information and field information by using either of the following methods:

   • Create a table by using Copilot:

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

     2. Enter an instruction in natural language, for example, 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 modify some of the table information, you can manually edit the system-generated information after you click Accept.

   • Create a table manually:

     Configure the following parameters as described.

     Parameter	Description
     Basic information	Specify the Table Name, Table Description, and other information.
     Field information	Edit the fields and annotations. Edit manually: Click the Insert button above the field list, specify the number of rows to insert, and then edit the Field Name and Data Type. Edit with Copilot: Click Generate Field or Generate field descriptions above the field list. The system can generate relevant fields and descriptions based on the table name and description you have entered.

4. (Optional) Configure partition information.

   To create a partitioned table, go to the Partition Field section. Set the number of Rows for partition fields and click Insert. Then, configure the partition Field Name and Data Type.

5. (Optional) Configure advanced settings.

   Parameter	Description
   Table type	Only Internal Table is supported.
   Storage location	You can customize the storage directory for the table. Example: /user/hive/warehouse/hive_work.
   Storage format	You can set the storage format to CSV, PARQUET, ORC, AVRO, JSON, or SELF_DEFINE. The selected storage format determines the data input and output formats, and the serialization and deserialization methods. CSV: Comma-separated text files, suitable for simple data structures. PARQUET: A columnar storage format with a high compression ratio, suitable for big data analysis. ORC: An optimized columnar storage format with excellent performance that supports complex data types. AVRO: A binary format that supports schema evolution, suitable for dynamic data structures. JSON: Supports nested structures, suitable for semi-structured data. SELF_DEFINE: Allows you to define custom serialization and deserialization logic.

6. When you are finished, click Publish in the top toolbar to create the table.

Manage tables

After you create a table in the Hive data catalog, click the icon to the left of the Hive data catalog, and then click Table to go to the Table page.

1. View tables.

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

2. Delete a table.

   On the Table page, find the table that you want to delete and click Delete in the Operation column.

   Important

   This action cannot be undone. Proceed with caution.