title: How does the percentile function work in Hive?
body: <p>Imagine the following column calledd <code>id</code>:</p>
  
  <p>68
  69
  43
  54
  56
  61
  69
  70
  71
  72
  77
  78
  79
  85
  87
  88
  89
  93
  95
  96
  98
  99
  99
  62
  66</p>
  
  <p>If I do the following: <code>percentile(id, 0.9)</code>, the output is 97.2. What is going on?</p>