Reply
Explorer
Posts: 14
Registered: ‎03-03-2017

Not able to retrieve value from "show table stats <table_name>"

Dear Team,

 

No command for retrieving value from show table stats t2;

From Below command ,I am able to see the values

show table stats t2;

But, How to get each column values.For example. How do I get the Total value from column #Rows

 

Please do the needful.

 

Thanks and Regards,

Naveen Srikanth D

Posts: 487
Topics: 14
Kudos: 82
Solutions: 43
Registered: ‎09-02-2016

Re: Not able to retrieve value from "show table stats <table_name>"

@GokuNaveen

 

Pls try compute status before show, it may help you

 

compute stats <table name>;
show table stats <table name>;
show column stats <table name>;

 

Highlighted
Explorer
Posts: 14
Registered: ‎03-03-2017

Re: Not able to retrieve value from "show table stats <table_name>"

Thanks for the response saranvisa .

 

Reiterating my requirement , and is below .

I fire below statement

show table stats tblname;

My output will look like below:

Partition_Name, Rows, Files,Ingesteddate...etc

val1

val2

                      Total Rows

 

Now my problem statement is how do I query this table alone, For example out of all the partition values I should get total rows out . How can I do it ?

Announcements