查询以查找 Hue 上 impala/hive 中所有表的列数

发布于 2025-01-11 02:59:00 字数 490 浏览 0 评论 0原文

我正在尝试从同一架构的 Impala 中获取单个表/视图列表的总列数。

但是我想扫描该架构中的所有表以捕获单个查询中的列？

我已经在 Oracle Exadata 中进行了类似的练习，但是由于我是 Impala 新手，有没有办法捕获？

Oracle Exadata 查询我使用

select owner, table_name as view_name, count(*) as counts
from dba_tab_cols /*DBA_TABLES_COLUMNS*/
where (owner, table_name) in 
(
select owner, view_name 
from dba_views /*DBA_VIEWS*/
where 1=1 
and owner='DESIRED_SCHEMA_NAME' 
)
group by owner ,table_name
order by counts desc;

Impala

原文

I am trying to fetch a count of total columns for a list of individual tables/views from Impala from the same schema.

however i wanted to scan through all the tables from that schema to capture the columns in a single query ?

i have already performed a similar excercise from Oracle Exadata ,however since i a new to Impala is there a way to capture ?

Oracle Exadata query i used

select owner, table_name as view_name, count(*) as counts
from dba_tab_cols /*DBA_TABLES_COLUMNS*/
where (owner, table_name) in 
(
select owner, view_name 
from dba_views /*DBA_VIEWS*/
where 1=1 
and owner='DESIRED_SCHEMA_NAME' 
)
group by owner ,table_name
order by counts desc;