ytsaurus-ui icon indicating copy to clipboard operation
ytsaurus-ui copied to clipboard

[Feature] Implement graphical histogram visualization for query results

Open kaikash opened this issue 1 year ago • 1 comments

Hello,

I'd like to propose an enhancement for visualizing query results more effectively. Currently, when executing a query like the one below, the results are presented in a textual format:

insert into @tmp
SELECT
    Histogram(duration)
FROM `//home/my_table`;
commit;

select * from @tmp;

This query produces a table with two columns: # and column0. Here, column0 contains the histogram data in a textual structure:

(
    "Bins": [
        (
            "Frequency": 14547359,
            "Position": 27.307090759277344
        ),
        ...
    ],
    "Kind": "",
    "Max": 84502923,
    "Min": 0,
    "WeightsSum": 37438458
)

While this text representation provides the necessary data, it is not as immediately intuitive or visually accessible as a graphical representation. In many use cases, especially for data analysis and presentation, a visual histogram is far more effective for quickly understanding and communicating the distribution of data.

In the internal YQL UI, histograms are already visualized graphically, which significantly enhances the ease of data interpretation. Incorporating a similar graphical histogram feature would be immensely beneficial. It would allow users to have a clearer and more immediate understanding of the data distribution, without the need to manually interpret or visualize the text-based histogram data.

kaikash avatar Jan 31 '24 13:01 kaikash