Hi, > I have a question about how to get the location for a bunch of partitions. ... > But in an enterprise environment I'm pretty sure this approach would not be > the best because the RDS (mysql or derby) is maybe not reachable or > I don't have the permission to it.
That was the reason Hive shipped with metatool, though it remains fairly obscure outside of the devs. hive --service metatool -executeJDOQL "select database.name + '.' + tableName from org.apache.hadoop.hive.metastore.model.MTable" You need to join MPartition -> MStorageDescriptor on sd to get the locations out. Cheers, Gopal
