Hi Robert Please move your question to u...@hive.apache.org
Thanks Dudu -----Original Message----- From: Gillespie, Robert (R.J.) [mailto:rgill...@ford.com] Sent: Friday, May 13, 2016 4:32 PM To: dev@hive.apache.org Subject: hive and no systables work around 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
