开发者社区 问答 正文

hash clustering sorted by col_name 只能一列,还是可以多列 ?

hash clustering sorted by col_name 只能一列,还是可以多列 ?

展开
收起
云栖大讲堂 2018-12-19 13:23:47 1970 分享 版权
1 条回答
写回答
取消 提交回答
  • 擅长前端领域,欢迎各位热爱前端的朋友加入我们( 钉钉群号:23351485)关注【前端那些事儿】云栖号,更多好文持续更新中!

    可以多列。
    CREATE [EXTERNAL] TABLE [IF NOT EXISTS] table_name
    [(col_name data_type [COMMENT col_comment], ...)]
    [COMMENT table_comment]
    [PARTITIONED BY (col_name data_type [COMMENT col_comment], ...)]
    [CLUSTERED BY (col_name [, col_name, ...]) [SORTED BY (col_name [ASC | DESC] [, col_name [ASC | DESC] ...])] INTO number_of_buckets BUCKETS] -- 用于创建Hash Clustering表时设置表的Shuffle和Sort属性
    MaxCompute Hash Clustering介绍 https://yq.aliyun.com/articles/665154

    2019-07-17 23:22:56
    赞同 展开评论
问答地址: