title: Hive date function to achieve day of week
body: <p>I'm looking for a workaround or hive date functions that gives day of the week ,</p>
  
  <pre><code>Sunday - 1
  Monday - 2
  Tuesday - 3
  Wednesday - 4
  Thursday - 5
  Friday - 6
  Saturday - 7
  </code></pre>
  
  <p>Requirement in detail : I'm looking for a function that takes date string (YYYYMMDD) as input and outputs the day of the week as per the above table.</p>