How to check the size of Hive view table?

Question

Hello,

I am unable to know the size of the hive table. Actually it is a view specifically which we wanted to know the size of.

I have tried by running commands such as hdfs dfs -du -s -h /path/to/table, but the view can't be found in the location.

beeline> describe formatted/extended table name; Also does not give the output

I also tried with ANALYZE but no output as well.

Can some one tell me how to know the size of the view table. Since we have created view of the different table in database.

And we want to know the size of the particular table.

tusharkathpal · Accepted Answer

@ateka_18

As mentioned before as well, view is just a query statement in HMS. It's not actually a table. If you want to know the size of the table, below is the best approach.

hdfs dfs -du -s -h /path/to/table

Let's say you have a table named test(/user/hive/warehouse/default.db/test) and have several partitions under it (part1, part2, part3). To get the size of the table.

hdfs dfs -du -s -h /user/hive/warehouse/default.db/test

Let me know if the above helps.

HanzalaShaikh · Answer

Hi Ateka, Can you share what error you are getting. while submitting the command to better understand the issue.

Sign up

Please use your Cloudera account.

Login to the community

Please use your Cloudera account.