09-04-2018 08:14 AM
I wonder if something strange happened due to having a non-default desktop.db database file/location so this triggered an "upgrade" maneuver by which a database file located in /usr/share/hue/desktop will be backed up and then moved to the location in /var/lib/hue.
If such a thing happen, we should probably see the configuration change in the Hue Configuration "History and rollback".
Cause aside, if you have your Hue database back, then you should be fine now since a start of Hue in CDH triggers db sync and migration routines that will get your database updated for the CDH version you are on.
Note that you really need to migrate away from sqlite as it is single threaded and modern Hue will encounter problems if you are not on a database such as postgres, mysql, Oracle, etc.