Ashutosh Bapat <ashutosh.bapat....@gmail.com> wrote: > There are multiple ways > 1. Query the HiveMetaStore directly.
do you mean via thrift client? or directly native jdbc? But i think this is in an enterprise env not possible, when i'm not on the same machine where hive server is running. i believe the mysql or postgres service will not be exposed. > 2. Use sys.* tables or better even information_schema to get the same. ok. as far as I understand this is available since hive 3 or as part of hive (e.g. beeline)? https://issues.apache.org/jira/browse/HIVE-1010 so no chance to do it in hive < 3 or? thanks for your hints, very helpful. marko
