Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Impala/Hive - Query sys.tables objects

Impala/Hive - Query sys.tables objects

Hi experts,

There exists any way to make a query to sys.tables like we do on T-SQL, like:

SELECT *FROM sys.tables

Is this possible in Impala or Hive?

Thanks!

1 REPLY 1

Re: Impala/Hive - Query sys.tables objects

Hey @Pedro Rodgers!
AFAIK, you don't have the same graceful way to query metadata from Hive/Impala as Sql server.
Since they use a DBMS behind the scenes to keep their meta. You'll probably need to access directly the DBMS and run some queries there.
So for instance, let's say that you have a hive/impala with a MySql as its Metastore/Catalog, in this case you'll need to access the mySql to gather info about Hive/Impala.
But.. there's some tools from hive side, that may can be useful for you :)
https://cwiki.apache.org/confluence/display/Hive/Hive+Schema+Tool
https://cwiki.apache.org/confluence/display/Hive/Hive+MetaTool
https://cwiki.apache.org/confluence/display/Hive/HCatalog+CLI

Hope this helps! :)

Don't have an account?
Coming from Hortonworks? Activate your account here