How to get the partitions details in Dremio like:
SHOW PARTITION DB.SALES
Dremio does not currently expose this information in the same way Hive, for example, does. For file system source, partition columns will be labeled dir0, dir1, dir2 etc.
If I don’t have the access to HDFS path then is there any way or any query which I can execute in Dremio to get the partitions details?