The BETWEEN clause is only supported in Apache Hive 0.9 or higher.