Showing results for 
Search instead for 
Did you mean: 
New Contributor II
since ‎08-11-2022

User Stats

  • 1 Posts
  • 0 Solutions
  • 0 Kudos given
  • 1 Kudos received

User Activity

I am using SHOW PARTITIONS <<table_name>> to get all the partitions of a table. I want to use max() on the output of this command to get the latest partition for the table.However, I am not able to use SHOW PARTITIONS <<table_name>> in a CTE/sub-quer...
Kudos from