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?
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 :)
Hope this helps! :)