Skip to content

Instantly share code, notes, and snippets.

@vithalsamp
Created February 25, 2018 11:12
Show Gist options
  • Select an option

  • Save vithalsamp/94fa3c8c46a20c54539b3c0ce4d77498 to your computer and use it in GitHub Desktop.

Select an option

Save vithalsamp/94fa3c8c46a20c54539b3c0ce4d77498 to your computer and use it in GitHub Desktop.
hive> ANALYZE TABLE stud_dtls COMPUTE STATISTICS;
Query ID = impadmin_20180117141106_5b55d716-b5b3-4fa8-82db-35be9fda85dc
Total jobs = 1
Launching Job 1 out of 1
….
Table ds_tbl_db.stud_dtls stats: [numFiles=9, numRows=9, totalSize=63, rawDataSize=54]
OK
Time taken: 8.248 seconds
hive>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment