查询表信息

前提条件

初始化Tablestore Client

方法说明

func (tableStoreClient *TableStoreClient) DescribeTable(request *DescribeTableRequest) (*DescribeTableResponse, error)

示例代码

以下示例代码用于查询test_table表的详细信息。

func DescribeTableSample(client *tablestore.TableStoreClient) {
    describeTableReq := new(tablestore.DescribeTableRequest)
    describeTableReq.TableName = "test_table"
    response, err := client.DescribeTable(describeTableReq)
    if err != nil {
        fmt.Println("Failed to describe table with error:", err)
    } else {
        // 获取数据表结构信息
        tableMeta := response.TableMeta
        fmt.Printf("* 数据表名称: %s \n", tableMeta.TableName)
        fmt.Println("* 主键信息 (主键类型 1:INTEGER,2:STRING,3:BINARY)")
        for _, schemaEntry := range tableMeta.SchemaEntry {
            fmt.Printf("%s:%v \n", *schemaEntry.Name, *schemaEntry.Type)
        }
        fmt.Println("* 预定义列信息 (预定义列类型 1:INTEGER,2:DOUBLE,3:BOOLEAN,4:STRING,5:BINARY)")
        for _, definedColumn := range tableMeta.DefinedColumns {
            fmt.Printf("%s:%v \n", definedColumn.Name, definedColumn.ColumnType)
        }

        // 获取数据表的配置信息
        tableOption := response.TableOption
        fmt.Println("* 数据表配置信息")
        fmt.Printf("最大版本数: %d \n", tableOption.MaxVersion)
        fmt.Printf("数据生命周期: %d \n", tableOption.TimeToAlive)
        fmt.Printf("有效版本偏差: %d \n", tableOption.DeviationCellVersionInSec)
        fmt.Printf("是否允许更新: %t \n", *tableOption.AllowUpdate)

        // 获取数据表Stream信息
        streamDetails := response.StreamDetails
        fmt.Printf("* 是否开启Steam: %t \n", streamDetails.EnableStream)
        if streamDetails.EnableStream {
            fmt.Printf("Stream过期时间: %d \n", streamDetails.ExpirationTime)
        }

        // 获取数据表加密设置
        sseDetails := response.SSEDetails
        fmt.Printf("* 是否开启数据表加密: %t \n", sseDetails.Enable)
        if sseDetails.Enable {
            fmt.Printf("加密方式: %s \n", sseDetails.KeyType.String())
        }

        // 获取数据表预留读写吞吐量
        reservedThroughput := response.ReservedThroughput
        fmt.Println("* 预留读写吞吐量")
        fmt.Printf("预留读吞吐量: %d \n", reservedThroughput.Readcap)
        fmt.Printf("预留写吞吐量: %d \n", reservedThroughput.Writecap)

        // 获取二级索引信息
        indexMetas := response.IndexMetas
        for _, indexMeta := range indexMetas {
            fmt.Printf("* 二级索引名称: %s \n", indexMeta.IndexName)
            fmt.Printf("主键列表: %v \n", indexMeta.Primarykey)
            fmt.Printf("预定义列列表: %v \n", indexMeta.DefinedColumns)
            fmt.Printf("二级索引类型: %d (0:IT_GLOBAL_INDEX,1:IT_LOCAL_INDEX) \n", indexMeta.IndexType)
        }
    }
}

相关文档

查询时序表信息