Posted by
akashrn5 on
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/Improving-show-segment-info-tp91874p91878.html
Hi likun,
Thanks for proposing this
+1, its a good way and its better to provide user more info about segment.
I have following doubts and suggestions.
1. You have mentioned DDL as Show segments On table, but currently it is
show segments for table, i suggest not to change the current one,we can add
more optional fields for more segment info.
1. Incase of multiple partiton columns,the partition info can be huge, in
that case what is the format you are trying to show in sow segment with
partition.
Can we ask user to give partition column also as optional field in command?
So that if there are multiple partition columns, we can reduce the info in
output to make the info more clean.
When the optional field of partiton column is not given, then we should have
a better formatting to show the huge information.
DDL should be something like
SHOW SEGMENTS ON table1 PARTITION (workgroupcategory)
SHOW SEGMENTS ON table1 PARTITION (workgroupcategory, empname,
designation)
2. You have shown the comand which filter out the partition, i think its
better if we can filter out the partition columns also as mentioned in above
case, what do you say?
3. already show segments have 9 columns as output and for show history its
10 columns, now to these basic info event time and load speed is getting
added, if i am not wrong.
in the sample output its shown that there is a spent column, i think its not
required as we have throughput column.
One suggestion is, why cant we merge loadstart and endtime, event time min
and max, data and index size as single columns with proper formatted data?
With this we can
reduce the size of output in cnsole size and include more columns in basic
output.
Thanks,
Regards,
Akash R Nilugal
--
Sent from:
http://apache-carbondata-dev-mailing-list-archive.1130556.n5.nabble.com/