I attach two files outlining my problems trying to use the foodmart schema
workbench with hive. Any assistance would be appreciated.

In a nutshell, the earlier versions of this application, cannot read the new
FoodMart.xml and throw an exception because the 'hive' is an unrecognizable
dialect, to wit:
15:23:02,639 ERROR [SchemaExplorer] Exception : Schema file parsing
failed.In Schema: In Cube: In Dimension: In Hierarchy: In Level: In
NameExpression: In SQL: Value 'hive' of attribute 'dialect' has illegal
value 'hive'. Legal values: {generic, access, db2, derby, firebird, hsqldb,
mssql, mysql, oracle, postgres, sybase, teradata, ingres, luciddb}

The new code builds pretty much out of the box; but the workbench will not
load because it can not find a class; to wit:
Exception in thread "main" java.lang.NoClassDefFoundError:
Caused by: java.lang.ClassNotFoundException:
at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
Could not find the main class: mondrian.gui.Workbench. Program will exit.

All of this is set forth in more excruciating detail in the attached files.
These files also provide some environmental data.

Mondrian mailing list
Mondrian (AT) pentaho (DOT) org