Skip to content

About sort field of non-aggregation table sql statement #15

New issue
New issue
Closed
Closed
About sort field of non-aggregation table sql statement#15
Labels
question

Description

@interma
interma
opened on Aug 16, 2017

In https://github.com/baidu/palo/blob/master/README.md:

In non-aggregation type of table, columns are not distinguished between dimensions and metrics, but should specify the sort columns in order to sort all rows. Palo will sort the table data according to the sort columns without any aggregation. The following figure gives an example of creating non-aggregation table.

-- Create non-aggregation table --
CREATE TABLE example_tbl (
    `date`      DATE,
    id          BIGINT,
    country     VARCHAR(32),
    click       BIGINT,
    cost        BIGINT
) DUPLICATE KEY(`date`, id, country)
DISTRIBUTED BY HASH(id) BUCKETS 32;

should specify the sort columns in order to sort all rows

Question:
where is the sort column in sql statement? I assumed it should be like:
date DATE Sort,
right? Is there something missing?

Activity

  1. imay commented on Aug 16, 2017

    @imay
    imay
    on Aug 16, 2017
    Contributor

    DUBPLICATE KEY is sort key, so data will sorted by (date, id, country)

  2. interma commented on Aug 16, 2017

    @interma
    interma
    on Aug 16, 2017
    MemberAuthor

    @imay thanks, clearly.

    PS:
    As we talked in wechat group, you can give a question label to this issue.

  3. imay
    added
    question
    on Aug 16, 2017

  4. imay commented on Aug 16, 2017

    @imay
    imay
    on Aug 16, 2017
    Contributor

    thanks for advise

  5. imay
    closed this as completedon Aug 16, 2017
  6. stdpain
    added a commit that references this issue on Jul 5, 2021

    support multi-tablet group by agg (apache#15)

    7138f6b
  7. HappenLee
    added a commit that references this issue on Jul 15, 2021

    support multi-tablet group by agg (apache#15)

    c8ab31b
  8. HappenLee
    added a commit that references this issue on Sep 7, 2021

    support multi-tablet group by agg (apache#15)

    ed7f585
  9. morningman
    added a commit that references this issue on May 4, 2022

    [fix](ut) fix a potential memory leak in BE ut

    cbd8383
  10. platoneko
    added 5 commits that reference this issue on Jun 20, 2022

    Squashed commit of the following:

    22c838b

    Squashed commit of the following: (#1)

    1886ba2

    Squashed commit of the following: (#2)

    c7cfe01

    Co-authored-by: Luwei <814383175@qq.com>

    9dbdde5

    Squashed commit of the following:

    4491627
  11. platoneko
    added a commit that references this issue on Jul 6, 2022

    Squashed commit of the following(beyond FE):

    d2da08b

  12. 166 remaining items

  13. morningman
    added 2 commits that reference this issue on Jul 29, 2026

    [fix](catalog) catalog-SPI abstraction-mismatch review: paimon time-t…

    35f7397

    [fix](catalog) catalog-SPI abstraction-mismatch review: paimon time-t…

    0a4a20c
  14. yiguolei
    added a commit that references this issue on Jul 31, 2026

    [fix](be) Avoid scan executor shutdown use after free (#65220)

    cc1bd58
  15. seawinde
    added 6 commits that reference this issue on Jul 31, 2026

    [fix](fe) Mark IVM binlog broken on metadata data changes (apache#15)

    ef6b0a3

    [fix](fe) Derive IVM binlog broken from DDL (apache#17)

    1e626b1

    [fix](fe) Mark IVM binlog broken on metadata data changes (apache#15)

    d93ceac

    [fix](fe) Derive IVM binlog broken from DDL (apache#17)

    75fe2bb

    [fix](fe) Mark IVM binlog broken on metadata data changes (apache#15)

    1aa9652

    [fix](fe) Derive IVM binlog broken from DDL (apache#17)

    79fbe1c
  16. seawinde
    added 2 commits that reference this issue on Aug 17, 2026

    [fix](fe) Mark IVM binlog broken on metadata data changes (apache#15)

    573652c

    [fix](fe) Derive IVM binlog broken from DDL (apache#17)

    d6af723
  17. seawinde
    added 2 commits that reference this issue on Aug 28, 2026

    [fix](fe) Mark IVM binlog broken on metadata data changes (apache#15)

    5bbb156

    [fix](fe) Derive IVM binlog broken from DDL (apache#17)

    1dfe2e1
  18. gavinchou
    added a commit that references this issue on Oct 16, 2026

    [fix](rle) Fix infinite loop when a repeated run reaches 2^30 values (#…

    76bd6f0
  19. github-actions
    added a commit that references this issue on Oct 16, 2026

    [fix](rle) Fix infinite loop when a repeated run reaches 2^30 values (#…

    7c1e882
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    question

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions