Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[Enhancement](datalake)(meta) Limit/Where/Orderby doesnt work for SHOW PARITIONS on hive tables #27834

Closed
3 tasks done
Nitin-Kashyap opened this issue Nov 30, 2023 · 0 comments · Fixed by #27835
Closed
3 tasks done

[Enhancement](datalake)(meta) Limit/Where/Orderby doesnt work for SHOW PARITIONS on hive tables #27834

Nitin-Kashyap opened this issue Nov 30, 2023 · 0 comments · Fixed by #27835

Comments

@Nitin-Kashyap
Copy link
Contributor

Search before asking

  • I had searched in the issues and found no similar issues.

Description

Show partitions for HMS catalog doesnt supports Limit / Where / Order by, but also doesnt gives error when specified incorrectly.

Solution

This enhancement shall extend existing logic to include

  1. Limit/Offset
  2. Where [partition name only] [equal operator and like operator]
  3. Order by [partition name only]

Are you willing to submit PR?

  • Yes I am willing to submit a PR!

Code of Conduct
@Nitin-Kashyap Nitin-Kashyap mentioned this issue Nov 30, 2023
Merged
Nitin-Kashyap added a commit to Nitin-Kashyap/doris that referenced this issue Nov 30, 2023
@Nitin-Kashyap
[fix](meta) show partitions with Limit for external HMS tables (27835)
6eab957 
Issue:apache#27834
Nitin-Kashyap added a commit to Nitin-Kashyap/doris that referenced this issue Dec 2, 2023
@Nitin-Kashyap
[fix](meta) show partitions with Limit for external HMS tables (27835)
56e9718 
Issue:apache#27834
Nitin-Kashyap added a commit to Nitin-Kashyap/doris that referenced this issue Dec 2, 2023
@Nitin-Kashyap
[fix](meta) show partitions with Limit for external HMS tables (27835)
dda01ee 
Issue:apache#27834
Nitin-Kashyap added a commit to Nitin-Kashyap/doris that referenced this issue Dec 2, 2023
@Nitin-Kashyap
[fix](meta) show partitions with Limit for external HMS tables (27835)
bb331eb 
Issue:apache#27834
Nitin-Kashyap added a commit to Nitin-Kashyap/doris that referenced this issue Dec 3, 2023
@Nitin-Kashyap
[fix](meta) show partitions with Limit for external HMS tables (27835)
e4be618 
Issue:apache#27834
Nitin-Kashyap added a commit to Nitin-Kashyap/doris that referenced this issue Dec 4, 2023
@Nitin-Kashyap
[fix](meta) show partitions with Limit for external HMS tables (27835)
b16672a 
Issue:apache#27834
Nitin-Kashyap added a commit to Nitin-Kashyap/doris that referenced this issue Dec 4, 2023
@Nitin-Kashyap
[fix](meta) show partitions with Limit for external HMS tables (27835)
2af4085 
Issue:apache#27834
Nitin-Kashyap added a commit to Nitin-Kashyap/doris that referenced this issue Dec 4, 2023
@Nitin-Kashyap
[fix](meta) show partitions with Limit for external HMS tables (27835)
7044135 
Issue:apache#27834
yiguolei pushed a commit that referenced this issue Dec 8, 2023
@Nitin-Kashyap
[fix](meta) show partitions with Limit for external HMS tables (27835) (
0733698 
#27835)

This enhancement shall extend existing logic for SHOW PARTITIONS FROM to include: -

Limit/Offset
Where [partition name only] [equal operator and like operator]
Order by [partition name only]
Issue Number: close #27834
XuJianxu pushed a commit to XuJianxu/doris that referenced this issue Dec 14, 2023
@Nitin-Kashyap
[fix](meta) show partitions with Limit for external HMS tables (27835) (
f8080ab 
apache#27835)

This enhancement shall extend existing logic for SHOW PARTITIONS FROM to include: -

Limit/Offset
Where [partition name only] [equal operator and like operator]
Order by [partition name only]
Issue Number: close apache#27834
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

[fix](meta) show partitions with Limit for external HMS tables (27835) Nitin-Kashyap/doris
1 participant
@Nitin-Kashyap