hive ddl updates for sensor table