hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gillespie, Robert (R.J.)" <RGILL...@ford.com>
Subject hive and no systables work around
Date Fri, 13 May 2016 13:32:20 GMT
I hope this is correct place for this ....



HI,

I am glad to have found this site!!!

If this is not the correct location, is there another location that i should be posting this
question ?


I know there are no 'systems' tables available in HUE,   is there any way to re-code this
to get row counts for ALL tables ?
i have 416 tables in my database.

SELECT T.name AS [TABLE NAME],  I.rows AS [ROWCOUNT]
FROM   sys.tables AS T
       INNER JOIN sys.sysindexes AS I
               ON T.object_id = I.id
                  AND I.indid < 2
ORDER  BY I.rows DESC


I thank you in advance for any assistance you can provide.
Bob


Thank you
Bob Gillespie
Attunity data landing team
ITEK - E2F008J



Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message