User Tools

Site Tools


Sidebar

**HPL/SQL is included to Apache Hive since version 2.0** * [[home|Home]]\\ * [[why|Why HPL/SQL]]\\ * [[features|Key Features]]\\ * [[start|Get Started]]\\ * [[doc|HPL/SQL Reference]]\\ * [[download|Download]]\\ * [[new|What's New]]\\ * [[about|About]]

summary

This is an old revision of the document!


A PCRE internal error occured. This might be caused by a faulty plugin

====== SUMMARY Statement ======= The SUMMARY statement outputs the summary statistics for a table or result set. For each column it includes the data type, number of distinct values, non-NULL rows, mean, median, standard deviation, 5%, 25%, 75% and 95% percentiles, min and max values. The statement helps you perform quick and easy exploratory data analysis. Syntax: <code language=sql> SUMMARY [TOP num] FOR table_name [WHERE condition] [LIMIT num] | select_statement; </code> **Version:** HPL/SQL 0.3.31