How to subtract or see differences between two DataFrames in Spark?
August 25, 2021How to change the number of replicas of a Kafka topic?
August 30, 2021You are trying to calculate median and you couldn’t find a function to calculate median in Hive. No worries you have come to the right place.
Solution
The 50th percentile is usually the median. Hive has a percentile function which can be used to calculate median.
select percentile(numberical_column, 0.5) from table_name;