Cloudera Community

Support Questions

Find answers, ask questions, and share your expertise
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Advanced Search
Announcements
Now Live: Explore expert insights and technical deep dives on the new Cloudera Community Blogs — Read the Announcement

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

Labels:
avatar
author-rank khadeermhmd
New Member

Created ‎06-07-2017 06:19 PM

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

3,742 Views
0 Kudos
1 REPLY 1

avatar
author-rank ssubhas author-rank
Guru

Created ‎06-14-2017 06:13 AM

@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.

3,262 Views
0 Kudos
Announcements
Community Announcements
Announcing the Launch of Cloudera Community Blogs
Community Announcements
October / November 2025 Community Highlights
What's New @ Cloudera
Announcing Cloudera Streaming Analytics - Kubernetes Operato...
What's New @ Cloudera
Announcing Cloudera Streams Messaging - Kubernetes Operator ...
Community Announcements
Welcome to the Cloudera Community!
View More Announcements