Hive table , Total data/ number of files .. gives the average file size for a table.Any direct query?

[#1]

Hive table , Total data/ number of files .. gives the average file size for a table.Any direct query?

[#2]

@Stinger

You need to collect the statistics for the table using query 'analyze table', then use describe formatted and describe extended to see the information related to data and number of files.