How to get all the partitions of a table IN HIVE?

Execute the command ‘SHOW PARTITIONS {table_name};’

hive> SHOW PARTITIONS orders;
OK
countrycode=IN
countrycode=JP
countrycode=USA
Time taken: 0.052 seconds, Fetched: 3 row(s)

 

Previous                                                    Next                                                    Home