query to specific partition in synapse?

ash b 1

In oracle, to query the particular partition we use following partition keyword i.e SELECT * FROM employees PARTITION (p1);
is there any similar command in azure synapse, to query the particular partition in partition table? Also how to identify in synapse query explained plan where it's using partition or not?

HarithaMaddi-MSFT 10,136 Reputation points

2021-01-19T12:48:48.24+00:00

Hi @ash b ,

Welcome to Microsoft Q&A Platform. Thanks for posting the query.

I could not find any explicit options to direct query to a specific partition. I will reach to product team on this query and also on details to view partitions used in query plan. I will get back to you as soon as I hear from them.

Appreciate your patience!
HarithaMaddi-MSFT 10,136 Reputation points

2021-01-25T09:19:37.693+00:00

Hi @ash b ,

This is to update that I am still waiting for response from product team. I will keep you posted as soon as I hear from them.

1 answer

HarithaMaddi-MSFT 10,136 Reputation points

2021-01-27T07:06:03.133+00:00
Hi @ash b ,

Thanks for your patience. I got an update from product team that today we do not have provision to check partitions used in the query in Synapse and there is no plan in near future to implement the same. I would recommend you to create an idea in feedback forum which will be closely monitored by Synapse product team and will be considered for implementing in future releases.

Please let us know for further queries and we will be glad to assist.

--

Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.

Want a reminder to come back and check responses? Here is how to subscribe to a notification.
Please sign in to rate this answer.
HarithaMaddi-MSFT 10,136 Reputation points

2021-01-28T05:41:00.707+00:00

Hi @ash b ,

We have not received a response from you. Please suggest if above suggested details are helpful. Otherwise, let us know and we will continue to engage with you on the query.

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members.

HarithaMaddi-MSFT 10,136 Reputation points

2021-01-29T07:02:43.993+00:00

Hi @ash b ,

We still have not heard back from you. Following up to check if above suggested details are helpful. Otherwise, let us know and we will continue to engage with you on the query.

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

query to specific partition in synapse?

1 answer

Your answer