Oracle Cloud Infrastructure Documentation

Installing Jupyter for ODH

To set up Jupyter notebooks on ODH, you must install both PySpark and Jupyter.

Troubleshooting

Set up the Hive configuration in Apache Ambari to avoid Hive exception errors.

If you get the following exception message, when you create a Hive table:

AnalysisException: org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(message:Table odh.emp failed strict managed table checks due to the following reason: Table is marked as a managed table but is not transactional.);

Then follow these steps:

  1. Go through Apache Ambari prerequisites.
  2. Accessing Apache Ambari.
  3. In the list of Services, click Hive.
  4. Click the Advanced tab.
  5. In the Advanced hive-interactive-site and the Advanced hive-site sections, set the following field to false:
    hive.strict.managed.tablesA screenshot of the Advanced settings of Apache Ambari dashboard's Hive page. In the Advanced hive-interactive-site and the Advanced hive-site sections, the hive.strict.managed.tables field is set to false.