Known issues
Review the known issues in this release of the Cloudera Data Warehouse (CDW) service on Public Cloud.
- DWX-19138: The option to enable Impala query logging is unavailable on the CDW UI
- You do not see the Log Impala queries option while creating or editing a Virtual Warehouse on the CDW UI.
- DWX-19451: Data Visualization restore job can fail with ignorable errors
- After a successful Data Visualization restoration job, the Data
Visualization restore job could be in a failed state with the log displaying ignorable
errors.
pg_restore: error: could not execute query: ERROR: sequence "jobs_joblog_id_seq" does not exist Command was: DROP SEQUENCE public.jobs_joblog_id_seq; pg_restore: error: could not execute query: ERROR: table "jobs_joblog" does not exist Command was: DROP TABLE public.jobs_joblog; pg_restore: error: could not execute query: ERROR: sequence "jobs_jobcontent_id_seq" does not exist Command was: DROP SEQUENCE public.jobs_jobcontent_id_seq; ....... .......
This issue occurs because the restore job issues commands to DROP all the objects that will be restored, and if any of these objects do not exist in the destination database, such ignorable errors are reported.
This has no functional impact on the restored Data Visualization application. It is noticed that all the backed up queries, datasets, connections, and dashboards are restored successfully and Data Visualization is available for new queries.