Menu
Is there any way that we can check the DB table size and other properties ? I tried COMPUTE STATS but it gives the details of table except the size. any link to find information and other details are much appreciated.
877
Impala performs some optimizations using this metadata on its own, and other optimizations by using a combination of table and column statistics. To check that table statistics are available for a table, and see the details of those statistics, use the statement SHOW TABLE STATS table_name .
Open impala Query editor, select the context as my_db and type the show tables statement in it and click on the execute button as shown in the following screenshot. After executing the query, if you scroll down and select the Results tab, you can see the list of the tables as shown below.
Hive stores data in the table as hdfs file, you can simply use hdfs dfs -du command to identify size of folder and that would be your table size.
The describe command of Impala gives the metadata of a table. It contains the information like columns and their data types. The describe command has desc as a short cut. The drop command is used to remove a construct from Impala, where a construct can be a table, a view, or a database function.
show table stats tablename
Works as I wanted, Thanks alot
61
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With