How to check the file size in Hive?

In Hive, you can use HDFS commands to view the size of files. You can use the following command to view the file size in a Hive table:

DESCRIBE FORMATTED table_name;

This will display detailed information about the table, including the file size of each partition. You can view the total size of the table and the size of each partition.

If you want to check the size of a specific file in a Hive table, you can use the following HDFS command:

hdfs dfs -ls /path/to/file

This will display detailed information about the specified file, including its size. You can use this command to check the size of a single file.

Leave a Reply 0

Your email address will not be published. Required fields are marked *