PDA

View Full Version : PME 2.0 new field "Relative Size"



davidl
10-13-2008, 09:45 AM
The Pentaho Metada Editor version 2.0.0 RC1 has a new mandatory field, "Formatting ⟶ Relative Size", in the physical-table properties. Does anyone know what it's for, or what a suitable value for it would be?

Also, what's the purpose of the "Table Type" field?

MattCasters
10-13-2008, 10:10 AM
What's a mandatory field?

Anyway, if there are multiple paths to solve the same user-selection, we score the paths using the relative size.
The one with the lowest total score will win.

davidl
10-14-2008, 10:50 AM
I called it a "mandatory field" because I got an error-message when I tried to save a change to a physical table without defining it.

I've gone through and set the "relative size" to an estimate of the row-count of each table; will that cause the query engine to behave sanely?

MattCasters
10-14-2008, 03:44 PM
Yes it would, but it shouldn't give an error when the property is not defined, it's totally optional IMHO.

wgorman
10-19-2008, 01:29 AM
Hey guys,

This issue was introduced in a recent change related to Row Level Security. We've created a bug and have it slated for fixing before 2.0 GA:

http://jira.pentaho.com/browse/PMD-416

Will

dibe0015
11-13-2008, 12:51 PM
Hi,

it there any workaround for this issue or do I have to get the newest version to work with the Metadata Editor? You can't make any changes because of the error messages.

MattCasters
11-13-2008, 02:11 PM
Get the newest version.

dibe0015
11-14-2008, 06:30 AM
You mean I have to get it out of the SVN repository? I used already the newest version from Sourceforge.

Benjamin

dibe0015
11-18-2008, 05:19 AM
Hi,

I downloaded the newest files from the SVN repository, but how do I compile/deploy them with ant? I think I didn't download everything or there are dependencies because ant tells me:

Package org.pentaho.pms.schema.olap does not exist

Can anyone help me with this problem?

Benjamin

wgorman
11-18-2008, 10:29 AM
To build Metadata Editor, check out the latest code from trunk:
svn://source.pentaho.org/svnroot/pentaho-metadata-editor/trunk

And type "ant" in the root folder. This runs the dist ant target, which downloads necessary jars, compiles the code, and builds a distribution.

Will

MattCasters
11-18-2008, 12:58 PM
Not really Will. I can't build trunk either. In my case, it's missing the Kettle jar files in the classpath.

wgorman
11-18-2008, 01:48 PM
Could both of you post the ivy resolve and retrieve portions of your build? It's possible that Ivy isn't downloading the jars correctly. I just tried it on my machine and everything is working.

Will

MattCasters
11-18-2008, 02:00 PM
Will, I don't even know what you're asking. I've been trying to find a wiki to get started, but all I could find was the Eclipse IvyDE setup (and that wasn't working either).

Wat files / logs do you want us to post?

wgorman
11-18-2008, 02:17 PM
Here are instructions for installing IvyDE:
http://wiki.pentaho.com/display/PEOpen/Installing+ivyDE

Sorry Matt, I thought the question was related to building from ant, not Eclipse. I'm requesting the standard out / standard error of the ant process. When running the dist target in the build.xml file, the first thing that should happen is an ivy resolve and retrieve. That step grabs the jar files needed to build. If something went wrong during that step, it should appear in the output of the ant process.

Will

MattCasters
11-18-2008, 02:23 PM
Aaron helped me fix IvyIDE and I updated the wiki page you referenced ('t was a version issue). However the ant problem is still there.

Cheers Will,
Matt

MattCasters
11-18-2008, 02:44 PM
Here is the ant log on stdout:


matt@Hannelore:~/svn/pentaho/PentahoMetaData$ ant clean
Buildfile: build.xml

clean-tests:

cobertura.clean-instrumented-classes:

cobertura.clean-coverage-reports:

clean-cobertura:

clean-javadoc:

clean-dist:
[delete] Deleting directory /home/matt/svn/pentaho/PentahoMetaData/dist

clean:
[delete] Deleting directory /home/matt/svn/pentaho/PentahoMetaData/bin/classes
[delete] Deleting directory /home/matt/svn/pentaho/PentahoMetaData/bin

BUILD SUCCESSFUL
Total time: 0 seconds
matt@Hannelore:~/svn/pentaho/PentahoMetaData$ ant
Buildfile: build.xml

init:
[mkdir] Created dir: /home/matt/svn/pentaho/PentahoMetaData/bin/classes
[mkdir] Created dir: /home/matt/svn/pentaho/PentahoMetaData/dist

compile.pre:

compile.compile:
[javac] Compiling 125 source files to /home/matt/svn/pentaho/PentahoMetaData/bin/classes
[javac] /home/matt/svn/pentaho/PentahoMetaData/src/org/pentaho/pms/automodel/AutoModeler.java:3: package org.pentaho.di.core does not exist
[javac] import org.pentaho.di.core.DBCache;
[javac] ^
[javac] /home/matt/svn/pentaho/PentahoMetaData/src/org/pentaho/pms/automodel/AutoModeler.java:4: package org.pentaho.di.core.database does not exist
[javac] import org.pentaho.di.core.database.Database;
[javac] ^
[javac] /home/matt/svn/pentaho/PentahoMetaData/src/org/pentaho/pms/automodel/AutoModeler.java:5: package org.pentaho.di.core.database does not exist
+ hundred of more of the same errors


Didn't really notice it download anything to be honest.
Is there any other target besides ant clean to reset it all?

Take care,
Matt

wgorman
11-18-2008, 02:57 PM
Hi Matt,

I'm sorry, I thought you were working on the pentaho-metadata-editor. The pentaho-metadata-editor project hasn't been fully converted over to our common-build.xml file yet, so it's default target acts differently than pentaho-metadata project. For the pentaho-metadata project, you'll need to call "ant resolve" before running "ant dist".

The build team chose to remove resolve from the default build path, because it takes so long to run, and only needs running when dependencies change.

Will

MattCasters
11-18-2008, 03:15 PM
Thanks a bunch!

dibe0015
11-18-2008, 05:19 PM
Hi,

I'm using a different machine without ant on it. I'll post you my result tomorrow when I'm back at work.
My company is using a proxy so I downloaded the files manually and changed the paths manually to a local webserver.
The buildfile askes for the ant-"contrib" & ivy, I had them both.

The error "Package org.pentaho.pms.schema.olap does not exist" occured while ant was compiling it. But I'll download it again and come back to you with the results.

Benjamin

PS: By the way I think this morning I downloaded the version tagged as 2.0 GA hoping it would be most recent version ;)

dibe0015
11-19-2008, 04:03 AM
Ok,

I just tried it again, like I said, it could have something to do with the proxy.

Benjamin



D:\Pentaho\Metadata>d:/ant/bin/ant
Buildfile: build.xml

antcontrib.download-check:

antcontrib.download:

install-antcontrib:

ivy.download-check:

ivy.download:

install-ivy:
[echo] Installing IVY...
[ivy:settings] :: Ivy 1.3.1 - 20060330160721 :: http://ant.apache.org/ivy/ ::
[ivy:settings] :: loading settings :: url = file:D:/Pentaho/Metadata/ivysettings
.xml

resolve-init:

clean-jars:

resolve-default:
[ivy:resolve] :: resolving dependencies :: pentaho#pentaho-metadata-editor;2.1-S
NAPSHOT
[ivy:resolve] confs: [default]

BUILD FAILED
java.lang.NoClassDefFoundError: org/apache/commons/codec/DecoderException
at org.apache.commons.httpclient.HttpMethodBase.<init>(HttpMethodBase.ja
va:217)
at org.apache.commons.httpclient.methods.HeadMethod.<init>(HeadMethod.ja
va:93)
at org.apache.ivy.util.url.HttpClientHandler.doHead(HttpClientHandler.ja
va:199)
at org.apache.ivy.util.url.HttpClientHandler.getURLInfo(HttpClientHandle
r.java:105)
at org.apache.ivy.util.url.HttpClientHandler.getURLInfo(HttpClientHandle
r.java:99)
at org.apache.ivy.util.url.URLHandlerDispatcher.getURLInfo(URLHandlerDis
patcher.java:65)
at org.apache.ivy.plugins.repository.url.URLResource.init(URLResource.ja
va:65)
at org.apache.ivy.plugins.repository.url.URLResource.exists(URLResource.
java:81)
at org.apache.ivy.plugins.resolver.RepositoryResolver.findResourceUsingP
attern(RepositoryResolver.java:94)
at org.apache.ivy.plugins.resolver.RepositoryResolver.findResourceUsingP
attern(RepositoryResolver.java:79)
at org.apache.ivy.plugins.resolver.AbstractResourceResolver.findResource
UsingPatterns(AbstractResourceResolver.java:97)
at org.apache.ivy.plugins.resolver.AbstractResourceResolver.findIvyFileR
ef(AbstractResourceResolver.java:76)
at org.apache.ivy.plugins.resolver.BasicResolver.getDependency(BasicReso
lver.java:177)
at org.apache.ivy.plugins.resolver.DualResolver.getDependency(DualResolv
er.java:69)
at org.apache.ivy.plugins.resolver.ChainResolver.getDependency(ChainReso
lver.java:124)
at org.apache.ivy.plugins.resolver.ChainResolver.getDependency(ChainReso
lver.java:124)
at org.apache.ivy.core.resolve.IvyNode.loadData(IvyNode.java:225)
at org.apache.ivy.core.resolve.VisitNode.loadData(VisitNode.java:257)
at org.apache.ivy.core.resolve.ResolveEngine.fetchDependencies(ResolveEn
gine.java:599)
at org.apache.ivy.core.resolve.ResolveEngine.doFetchDependencies(Resolve
Engine.java:682)
at org.apache.ivy.core.resolve.ResolveEngine.fetchDependencies(ResolveEn
gine.java:607)
at org.apache.ivy.core.resolve.ResolveEngine.getDependencies(ResolveEngi
ne.java:494)
at org.apache.ivy.core.resolve.ResolveEngine.resolve(ResolveEngine.java:
233)
at org.apache.ivy.core.resolve.ResolveEngine.resolve(ResolveEngine.java:
191)
at org.apache.ivy.Ivy.resolve(Ivy.java:506)
at org.apache.ivy.ant.IvyResolve.doExecute(IvyResolve.java:230)
at org.apache.ivy.ant.IvyTask.execute(IvyTask.java:275)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.jav
a:106)
at org.apache.tools.ant.Task.perform(Task.java:348)
at org.apache.tools.ant.Target.execute(Target.java:357)
at org.apache.tools.ant.Target.performTasks(Target.java:385)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337)
at org.apache.tools.ant.Project.executeTarget(Project.java:1306)
at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExe
cutor.java:41)
at org.apache.tools.ant.Project.executeTargets(Project.java:1189)
at org.apache.tools.ant.Main.runBuild(Main.java:758)
at org.apache.tools.ant.Main.startAnt(Main.java:217)
at org.apache.tools.ant.launch.Launcher.run(Launcher.java:257)
at org.apache.tools.ant.launch.Launcher.main(Launcher.java:104)
Caused by: java.lang.ClassNotFoundException: org.apache.commons.codec.DecoderExc
eption
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
... 43 more

Total time: 3 seconds