Gopal Vijayaraghavan <gop...@apache.org> wrote: > 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.
uh. thanks! very helpful hint. as far as I understand, and please correct me if i'm wrong, the metatool can only be used on the same machine where hive server is running or? is there any chance to use this tool from a machine where the hive server is not running and access them form there? -- Marko Bauhardt Software Engineer www.datameer.com Phone: +49 345 279 5030 Datameer GmbH Magdeburger Str. 23, 06112 Halle (Saale), Germany Amtsgericht Stendal, HRB: 10348, Geschäftsführer: Frank Henze
