Enabling all scheduled queries

You can enable a single scheduled query using a SQL command, but to enable multiple scheduled queries you need perform a few steps in Cloudera Manager.

To enable all newly created schedules in Cloudera Private Cloud Base, follow these steps:

1. In Cloudera Manager, click Clusters > Hive on TEZ > Configuration
2. In Search, enter safety.
3. In Hive Service Advanced Configuration Snippet (Safety Valve) for hive-site.xml HIVE_ON_TEZ-1 (Service-Wide), click + and add the following property: hive.scheduled.queries.create.as.enabled
4. Set the value to true.
5. Save and restart Hive on Tez.