[Mondrian] Workbench Trials and Tribulations with foodmart and hive

[Brian Maguire]

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:
org/pentaho/di/core/exception/KettleException
Caused by: java.lang.ClassNotFoundException:
org.pentaho.di.core.exception.KettleException
       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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20110524/152a99c4/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: workbench-perforce.errors
Type: application/octet-stream
Size: 2741 bytes
Desc: not available
Url : http://lists.pentaho.org/pipermail/mondrian/attachments/20110524/152a99c4/attachment.obj 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: workbench-2.3.2.9247.errors
Type: application/octet-stream
Size: 8486 bytes
Desc: not available
Url : http://lists.pentaho.org/pipermail/mondrian/attachments/20110524/152a99c4/attachment-0001.obj