danhuawang opened a new issue, #10396:
URL: https://github.com/apache/gravitino/issues/10396

   ### What would you like to be improved?
   
   <img width="823" height="838" alt="Image" 
src="https://github.com/user-attachments/assets/868eb78f-141f-40a3-96f5-789216af6663";
 />
   
   ```
   URL: 
http://127.0.0.1:18090/api/metalakes/clickhouse_test/catalogs/ck_catalog1/schemas/sales/tables
   
   Status code: 200
   
   Content Type: application/json
   
   Request Headers
   Accept=application/vnd.gravitino.v1+json
   Authorization=Basic YW5vbnltb3VzOnRlc3Q=
   Content-Type=application/json
   Content Body
   {
       "name": "multi_sort_table",
       "comment": "ClickHouse table with multiple sort orders",
       "columns": [
           {
               "name": "id",
               "type": "integer",
               "comment": "ID",
               "nullable": false
           },
           {
               "name": "name",
               "type": "string",
               "comment": "Name",
               "nullable": false
           },
           {
               "name": "data",
               "type": "string",
               "comment": "Data",
               "nullable": false
           }
       ],
       "properties": {
           "engine": "MergeTree"
       },
       "sortOrders": [
           {
               "sortTerm": {
                   "type": "field",
                   "fieldName": [
                       "id"
                   ]
               },
               "direction": "asc",
               "nullOrdering": "nulls_first"
           },
           {
               "sortTerm": {
                   "type": "field",
                   "fieldName": [
                       "name"
                   ]
               },
               "direction": "asc",
               "nullOrdering": "nulls_first"
           }
       ]
   }
   Response Headers
   Date: Thu, 12 Mar 2026 03:41:38 GMT
   Content-Type: application/json
   Content-Length: 592
   Server: Jetty(9.4.51.v20230217)
   Response Body
   {
       "code": 0,
       "table": {
           "name": "multi_sort_table",
           "comment": "ClickHouse table with multiple sort orders",
           "columns": [
               {
                   "name": "id",
                   "type": "integer",
                   "comment": "ID",
                   "nullable": false,
                   "autoIncrement": false
               },
               {
                   "name": "name",
                   "type": "string",
                   "comment": "Name",
                   "nullable": false,
                   "autoIncrement": false
               },
               {
                   "name": "data",
                   "type": "string",
                   "comment": "Data",
                   "nullable": false,
                   "autoIncrement": false
               }
           ],
           "properties": {
               "engine": "MergeTree"
           },
           "audit": {
               "creator": "anonymous",
               "createTime": "2026-03-12T03:41:38.602838Z"
           },
           "distribution": {
               "strategy": "none",
               "number": 0,
               "funcArgs": [
                   
               ]
           },
           "sortOrders": [
               
           ],
           "partitioning": [
               
           ],
           "indexes": [
               
           ]
       }
   }
   ```
   
   ### How should we improve?
   
   In the Create ClickHouse Table API response, sortOrders shouldn't be empty, 
it should be what was specified in the request.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to