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
Celebrating as our community reaches 100,000 members! Thank you!

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

Labels:
avatar
author-rank khadeermhmd
Contributor

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?

2,832 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.

2,352 Views
0 Kudos
Announcements
Product Announcements
[ANNOUNCE] Cloudera on Public Cloud Runtime 7.2.18 is GA!
What's New @ Cloudera
Cloudera Operational Database (COD) supports enhancements to...
Community Announcements
March 2024 Community Highlights
Community Announcements
Celebrating 100,000 Members: A Journey of Growth and Connect...
Product Announcements
[ANNOUNCE] New Cloudera JDBC Connector for Apache Hive 2.6.2...
View More Announcements