title: how to create a view in hive which always points to the latest partition
body: <p>I have a requirement where I need to create a view in Hive to always point to the latest partition. 
  partition column in main table is created like partition_date=000020170606
  does anyone know how this can be done?</p>