<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=GB2312" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.19019">
<STYLE>@font-face {
font-family: 宋体;
}
@font-face {
font-family: Verdana;
}
@font-face {
font-family: @宋体;
}
@page Section1 {size: 595.3pt 841.9pt; margin: 72.0pt 90.0pt 72.0pt 90.0pt; layout-grid: 15.6pt; }
P.MsoNormal {
TEXT-JUSTIFY: inter-ideograph; TEXT-ALIGN: justify; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; FONT-SIZE: 10.5pt
}
LI.MsoNormal {
TEXT-JUSTIFY: inter-ideograph; TEXT-ALIGN: justify; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; FONT-SIZE: 10.5pt
}
DIV.MsoNormal {
TEXT-JUSTIFY: inter-ideograph; TEXT-ALIGN: justify; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; FONT-SIZE: 10.5pt
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.EmailStyle17 {
FONT-STYLE: normal; FONT-FAMILY: Verdana; COLOR: windowtext; FONT-WEIGHT: normal; TEXT-DECORATION: none; mso-style-type: personal-compose
}
DIV.Section1 {
page: Section1
}
UNKNOWN {
FONT-SIZE: 10pt
}
BLOCKQUOTE {
MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 2em
}
OL {
MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px
}
UL {
MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px
}
</STYLE>
</HEAD>
<BODY style="MARGIN: 10px; FONT-FAMILY: verdana; FONT-SIZE: 10pt">
<DIV><FONT color=#000080 size=2 face=Verdana>Hi Calum, John,</FONT></DIV>
<DIV><FONT color=#000080>Thanks for the suggestions.</FONT></DIV>
<DIV><FONT color=#000080>A part of the latency problem is Mondrian do a lot of
query on small tables that contains information for dimensions etc. In
stead of integrating with HBase, I'm thinking maybe Hive can integrate with
relational databases. Since hadoop already supports DBInputFormat and
DBOutputFormat, and Hive is using relational database for metastore. This
shouldn't be too challenging. I'm still doing some experients.</FONT></DIV>
<DIV><FONT color=#000080></FONT> </DIV>
<DIV><FONT color=#000080>The HIVE-1922 patch 1 is just for people to run the
foodmart test now. It's not finished yet. I'm still having problems with the
having clauses. I will update it when finished.</FONT></DIV>
<DIV><FONT color=#000080 size=2 face=Verdana></FONT> </DIV>
<DIV><FONT color=#000080>Another plan I have with Hive is more support of
ANSI SQL. Before that, I'm thinking of refatoring the SemanticAnalyzer. I know
refactoring RowResolver with better OO is on the to do list. You know, all
those genXXXPlan methods. I think they are pretty good indicators to use a
factory pattern. </FONT></DIV>
<DIV><FONT color=#c0c0c0 size=2 face=Verdana>2011-02-15 </FONT></DIV><FONT
color=#000080 size=2 face=Verdana>
<HR style="WIDTH: 100px" align=left color=#b5c4df SIZE=1>
</FONT>
<DIV><FONT color=#c0c0c0 size=2 face=Verdana><SPAN>fuhongwei141</SPAN>
</FONT></DIV>
<HR color=#b5c4df SIZE=1>
<DIV><FONT size=2 face=Verdana><STRONG>发件人：</STRONG> John Sichi </FONT></DIV>
<DIV><FONT size=2 face=Verdana><STRONG>发送时间：</STRONG> 2011-02-15 05:59:58
</FONT></DIV>
<DIV><FONT size=2 face=Verdana><STRONG>收件人：</STRONG> Mondrian developer mailing
list </FONT></DIV>
<DIV><FONT size=2 face=Verdana><STRONG>抄送：</STRONG> </FONT></DIV>
<DIV><FONT size=2 face=Verdana><STRONG>主题：</STRONG> Re: [Mondrian] Testing a
Hive dialect </FONT></DIV>
<DIV><FONT size=2 face=Verdana></FONT> </DIV>
<DIV><FONT size=2 face=Verdana>
<DIV>Speaking as the Hive committer who worked on that HBase integration, I can
tell you that it will only increase the latency since going through HBase adds
quite a bit of query execution overhead. The intention of the integration
is to decrease the latency on the write side (so that you can fire in row-level
updates instead of only batch loads), but it comes at a price on the read side.
And all of the rest of the query execution overhead (map/reduce) remains
the same.</DIV>
<DIV><BR></DIV>
<DIV>On the bright side, we do have some people working on Hive indexing
improvements, including GROUP BY rewrites and a bitmap index
implementation.</DIV>
<DIV><BR></DIV>
<DIV>Regarding HIVE-1922, I reviewed it and it needs some more work.</DIV>
<DIV><BR></DIV>JVS<BR><BR>
<DIV class=gmail_quote>2011/2/14 Calum Miller <SPAN dir=ltr><<A
href="mailto:calum@millersoft.ltd.uk">calum@millersoft.ltd.uk</A>></SPAN><BR>
<BLOCKQUOTE
style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>
<DIV style="WORD-WRAP: break-word">Hi Fu,
<DIV><BR></DIV>
<DIV>I discovered this link <A
href="http://wiki.apache.org/hadoop/Hive/HBaseIntegration"
target=_blank>http://wiki.apache.org/hadoop/Hive/HBaseIntegration</A> on Hive
and HBase integration and wondered if this is something you had reviewed? I'm
thinking this integration may reduce the latency issues with Hive and improve
Mondrian responsiveness.</DIV>
<DIV><BR></DIV>
<DIV>Calum<BR>
<DIV>
<DIV>
<DIV></DIV>
<DIV class=h5>
<DIV>On 14 Feb 2011, at 15:23, Fu Hongwei wrote:</DIV><BR></DIV></DIV>
<BLOCKQUOTE type="cite"><SPAN
style="TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; LETTER-SPACING: normal; WORD-SPACING: 0px">
<DIV style="MARGIN: 10px; FONT-FAMILY: verdana; FONT-SIZE: 10pt">
<DIV>
<DIV></DIV>
<DIV class=h5>
<DIV><FONT color=#000080 size=2 face=Verdana>
<DIV><FONT color=#000080 size=2 face=Verdana>Hi,</FONT></DIV>
<DIV><FONT color=#000080 size=2 face=Verdana>Thanks.</FONT></DIV>
<DIV><FONT color=#000080 size=2 face=Verdana>There are still some failures.
I will submit other changes when the test suite pass. Also, the HIVE patch
seemed to be broken. I will try to fix that
too.</FONT></DIV></FONT></DIV>
<DIV><FONT color=#000080 size=2 face=Verdana></FONT> </DIV>
<DIV><FONT color=#000080 size=2 face=Verdana></FONT> </DIV>
<DIV><FONT color=#c0c0c0 size=2 face=Verdana>2011-02-14</FONT></DIV><FONT
color=#000080 size=2 face=Verdana>
<HR style="WIDTH: 100px" align=left color=#b5c4df SIZE=1>
</FONT>
<DIV><FONT color=#c0c0c0 size=2 face=Verdana><SPAN>Fu
Hongwei</SPAN></FONT></DIV>
<HR color=#b5c4df SIZE=1>
<DIV><FONT size=2
face=Verdana><STRONG>发件人：</STRONG><SPAN> </SPAN>Julian
Hyde</FONT></DIV>
<DIV><FONT size=2
face=Verdana><STRONG>发送时间：</STRONG><SPAN> </SPAN>2011-02-14
10:45:26</FONT></DIV>
<DIV><FONT size=2 face=Verdana><STRONG>收件人：</STRONG><SPAN> </SPAN>'Fu
Hongwei'</FONT></DIV>
<DIV><FONT size=2
face=Verdana><STRONG>抄送：</STRONG><SPAN> </SPAN>'Mondrian developer
mailing list'</FONT></DIV>
<DIV><FONT size=2 face=Verdana><STRONG>主题：</STRONG><SPAN> </SPAN>RE:
RE: RE: [Mondrian] Testing a Hive dialect</FONT></DIV>
<DIV><FONT size=2 face=Verdana></FONT></DIV>
<DIV><FONT size=2 face=Verdana>
<DIV>
<DIV><SPAN>I have checked in your patch as change 14118. Thank you for the
contribution.</SPAN></DIV>
<DIV><SPAN></SPAN> </DIV>
<DIV><SPAN>I did some cleanup first (mainly to make the code comply with our
coding conventions). Let me know if I broke anything.</SPAN></DIV>
<DIV><SPAN></SPAN> </DIV>
<DIV><SPAN>I'm doing some further cleanup to move the Hive-specific stuff
(e.g. checking that the 'on' clause only contains 'x.a = y.b' or 'upper(x.a)
= upper(y.b)') into the Hive dialect. My goal
is <SPAN>to<SPAN> </SPAN></SPAN>enable FROM-JOIN-ON syntax for
other dialects such as Oracle<SPAN>.</SPAN></SPAN></DIV>
<DIV><SPAN><SPAN></SPAN></SPAN> </DIV>
<DIV><SPAN><SPAN><FONT face=verdana>I do not have a Hive instance to test
against, so my apologies in advance if I break anything in this upcoming
change. I hope that change 14118 will give others such as Calum enough to
test and work against.</FONT></SPAN></SPAN></DIV>
<DIV><SPAN><FONT face=verdana></FONT></SPAN> </DIV>
<DIV><SPAN><SPAN>Generally I like to have a few more contributions before I
give newcomers committer access. For now, the best way to send patches is
using the packChange utility (available in //open/util/bin in the eigenbase
perforce repository). But I will also accept tar files or patch files as
long as each file has a '$Id: $' header somewhere so that I can identify the
version that you modified. Next time can you also run the
//open/mondrian/bin/checkFile.sh script on your changes, so check for
compliance with our coding guidelines.</SPAN></SPAN></DIV>
<DIV><SPAN></SPAN> </DIV>
<DIV><SPAN>Julian</SPAN><BR></DIV></DIV><BR>
<BLOCKQUOTE
style="BORDER-LEFT: rgb(0,0,0) 2px solid; MARGIN: 0px 0px 0px 5px; PADDING-LEFT: 5px"
dir=ltr>
<DIV dir=ltr lang=en-us align=left>
<HR>
<FONT face=Tahoma><B>From:</B><SPAN> </SPAN>Fu Hongwei [mailto:<A
href="mailto:fuhongwei2006@163.com"
target=_blank>fuhongwei2006@163.com</A>]<SPAN> </SPAN><BR><B>Sent:</B><SPAN> </SPAN>Sunday,
February 13, 2011 7:15
AM<BR><B>To:</B><SPAN> </SPAN>jhyde<BR><B>Cc:</B><SPAN> </SPAN>'Mondrian
developer mailing list'<BR><B>Subject:</B><SPAN> </SPAN>Re: RE: RE:
[Mondrian] Testing a Hive dialect<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><FONT color=#000080 face=Verdana>Thanks, please commit the files for
me. Hive-1922 contains some stuff I consider easier to fix on the Hive
side, but, yes, I think it's better if we have a non hive patch
version.</FONT></DIV>
<DIV><FONT color=#000080></FONT> </DIV>
<DIV><FONT color=#000080>The failures are caused by some small problems.
It's running beautifully now.</FONT></DIV>
<DIV><FONT color=#000080></FONT> </DIV>
<DIV><FONT color=#000080 face=Verdana>I've fixed the join issue. You would
also want to add a VM parameter when running the tests or it will report
some errors.</FONT></DIV>
<DIV>-javax.xml.parsers.DocumentBuilderFactory=com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderFactoryImpl</DIV>
<DIV> </DIV>
<DIV><FONT color=#000080 face=Verdana>Can I have some kind of commit
right? It looks like I have a lot of files to submit.</FONT></DIV>
<DIV><FONT color=#000080></FONT> </DIV>
<DIV><FONT color=#000080>BTW, could somebody tell me how to make a patch
in perforce like in svn? Thanks.</FONT></DIV>
<DIV><FONT color=#c0c0c0 face=Verdana>2011-02-13</FONT></DIV><FONT
color=#000080 face=Verdana>
<HR style="WIDTH: 100px" align=left color=#b5c4df SIZE=1>
</FONT>
<DIV><FONT color=#c0c0c0 face=Verdana><SPAN>Fu Hongwei</SPAN></FONT></DIV>
<HR color=#b5c4df SIZE=1>
<DIV><FONT face=Verdana><STRONG>发件人：</STRONG><SPAN> </SPAN>Julian
Hyde</FONT></DIV>
<DIV><FONT
face=Verdana><STRONG>发送时间：</STRONG><SPAN> </SPAN>2011-02-12
01:59:33</FONT></DIV>
<DIV><FONT face=Verdana><STRONG>收件人：</STRONG><SPAN> </SPAN>'Mondrian
developer mailing list'</FONT></DIV>
<DIV><FONT face=Verdana><STRONG>抄送：</STRONG></FONT></DIV>
<DIV><FONT face=Verdana><STRONG>主题：</STRONG><SPAN> </SPAN>RE: RE:
[Mondrian] Testing a Hive dialect</FONT></DIV>
<DIV><FONT face=Verdana></FONT></DIV>
<DIV><FONT face=Verdana>
<DIV><SPAN><FONT face=verdana>If it is difficult to fix HIVE-1922, we
could possibly workaround issue by changing Dialect.generateOrderItem.
(Every dialect tends to have different rules for how to generate an ORDER
BY clause -- order by column name, order by ordinal, order by
expression, order by ordinal only when applied to a set operation such as
union, etc. -- so there's no harm having yet another
behavior.)</FONT></SPAN></DIV>
<DIV><SPAN><FONT face=verdana></FONT></SPAN> </DIV>
<DIV><SPAN><FONT face=verdana>Someone also mentioned that Hive only
supports ANSI join syntax 'FROM t1 JOIN t2 ON t1.x = t2.y', whereas
mondrian only generates 'FROM t1, t2 WHERE t1.x = t2.y'. Is this still an
issue? We would need to fix either Hive or Mondrian's dialect. Mondrian's
dialect it probably easier.</FONT></SPAN></DIV>
<DIV><SPAN><FONT face=verdana></FONT></SPAN> </DIV>
<DIV><SPAN>
<DIV><SPAN><FONT face=verdana>Since other people have expressed an
interest in a Hive dialect, it would be useful if you check in what you
have right now, even though there are many failures. Send me the files and
I will check them in.</FONT></SPAN></DIV>
<DIV><SPAN><FONT face=verdana></FONT></SPAN> </DIV></SPAN></DIV>
<DIV><SPAN><FONT face=verdana>Julian</FONT></SPAN></DIV>
<DIV><SPAN><FONT face=verdana></FONT></SPAN> </DIV><BR>
<BLOCKQUOTE
style="BORDER-LEFT: rgb(0,0,0) 2px solid; MARGIN: 0px 0px 0px 5px; PADDING-LEFT: 5px"
dir=ltr>
<DIV dir=ltr lang=en-us align=left>
<HR>
<FONT face=Tahoma><B>From:</B><SPAN> </SPAN><A
style="COLOR: blue; TEXT-DECORATION: underline"
href="mailto:mondrian-bounces@pentaho.org"
target=_blank>mondrian-bounces@pentaho.org</A><SPAN> </SPAN>[mailto:<A
href="mailto:mondrian-bounces@pentaho.org"
target=_blank>mondrian-bounces@pentaho.org</A>]<SPAN> </SPAN><B>On
Behalf Of<SPAN> </SPAN></B>Fu
Hongwei<BR><B>Sent:</B><SPAN> </SPAN>Friday, February 11, 2011 3:53
AM<BR><B>To:</B><SPAN> </SPAN>'Mondrian developer mailing
list'<BR><B>Subject:</B><SPAN> </SPAN>Re: RE: [Mondrian] Testing a
Hive dialect<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><FONT color=#000080 face=Verdana>Hi Julian,</FONT></DIV>
<DIV><FONT color=#000080 face=Verdana>Thanks for the prompt
reply.</FONT></DIV>
<DIV><FONT color=#000080>The test is running on Hive 0.7.0, but a patch
will be needed. I've started a jira on Hive and will submit it soon
too.</FONT></DIV>
<DIV><FONT color=#000080 face=Verdana><A
style="COLOR: blue; TEXT-DECORATION: underline"
href="https://issues.apache.org/jira/browse/HIVE-1922?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12987548#action_12987548"
target=_blank>https://issues.apache.org/jira/browse/HIVE-1922?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12987548#action_12987548</A></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#000080 face=Verdana>There are too many
failures in the test suite. I'm still working on
it, but<SPAN> </SPAN></FONT><FONT color=#000080 face=Verdana>I will
submit the DialectTest.java and HiveDialect.java, so people interested
can work on it together.</FONT></DIV>
<DIV><FONT color=#000080 face=Verdana>I think the point is first to make
it running then speed it up.</FONT></DIV>
<DIV><FONT color=#c0c0c0 face=Verdana>2011-02-11</FONT></DIV><FONT
color=#000080 face=Verdana>
<HR style="WIDTH: 100px" align=left color=#b5c4df SIZE=1>
</FONT>
<DIV><FONT color=#c0c0c0 face=Verdana><SPAN>Fu
Hongwei</SPAN></FONT></DIV>
<HR color=#b5c4df SIZE=1>
<DIV><FONT face=Verdana><STRONG>发件人：</STRONG><SPAN> </SPAN>Julian
Hyde</FONT></DIV>
<DIV><FONT
face=Verdana><STRONG>发送时间：</STRONG><SPAN> </SPAN>2011-02-11
00:19:26</FONT></DIV>
<DIV><FONT
face=Verdana><STRONG>收件人：</STRONG><SPAN> </SPAN>'Mondrian developer
mailing list'</FONT></DIV>
<DIV><FONT face=Verdana><STRONG>抄送：</STRONG></FONT></DIV>
<DIV><FONT face=Verdana><STRONG>主题：</STRONG><SPAN> </SPAN>RE:
[Mondrian] Testing a Hive dialect</FONT></DIV>
<DIV><FONT face=Verdana></FONT></DIV>
<DIV><FONT face=Verdana>
<DIV><SPAN><FONT face=verdana>I am well aware of the compromises with
Hive. There is certainly an impedance mismatch between hadoop and the
real-time analysis, and that is reflected in query response time. It is
still useful to have a Hive dialect, because as you say, Hive is
improving all the time. And Pentaho is thinking about ways to bridge the
impedance mismatch.</FONT></SPAN></DIV>
<DIV><SPAN><FONT face=verdana></FONT></SPAN> </DIV>
<DIV><SPAN>
<DIV><SPAN><FONT face=verdana>Can please you attach your code to the
jira case as a patch? I will submit it.</FONT></SPAN></DIV>
<DIV><SPAN><FONT face=verdana></FONT></SPAN> </DIV>
<DIV><SPAN><FONT face=verdana>Also please attach the output of the test
suite, and describe the version of Hive you are running against. That
will be a reference point for others who are working on
Hive.</FONT></SPAN></DIV>
<DIV><SPAN><FONT face=verdana></FONT></SPAN> </DIV>
<DIV><SPAN><FONT
face=verdana>Julian</FONT></SPAN></DIV></SPAN></DIV><BR>
<BLOCKQUOTE
style="BORDER-LEFT: rgb(0,0,0) 2px solid; MARGIN: 0px 0px 0px 5px; PADDING-LEFT: 5px"
dir=ltr>
<DIV dir=ltr lang=en-us align=left>
<HR>
<FONT face=Tahoma><B>From:</B><SPAN> </SPAN><A
style="COLOR: blue; TEXT-DECORATION: underline"
href="mailto:mondrian-bounces@pentaho.org"
target=_blank>mondrian-bounces@pentaho.org</A><SPAN> </SPAN>[mailto:<A
href="mailto:mondrian-bounces@pentaho.org"
target=_blank>mondrian-bounces@pentaho.org</A>]<SPAN> </SPAN><B>On
Behalf Of<SPAN> </SPAN></B>Fu
Hongwei<BR><B>Sent:</B><SPAN> </SPAN>Thursday, February 10, 2011
1:29
AM<BR><B>To:</B><SPAN> </SPAN>mondrian<BR><B>Subject:</B><SPAN> </SPAN>[Mondrian]
Testing a Hive dialect<SPAN> </SPAN><BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><FONT face=Verdana>Hi,</FONT></DIV>
<DIV>I'm new to the community. I don't know who to ask this for.</DIV>
<DIV>I've written a Hive dialect for mondrian and been
testing it.</DIV>
<DIV>The DialectTest is passed, but it's still failing other
tests.</DIV>
<DIV> </DIV>
<DIV>From what I can see it's still a long way to make an
integration</DIV>
<DIV>of Hive and Mondrian practical.</DIV>
<DIV>1. It's really slow. It takes 1 or 2 days to run through all the
tests,</DIV>
<DIV>a low end estimation. The latency is too big for most
applications.</DIV>
<DIV>It might take some major architectural change on the Hive
side to solve</DIV>
<DIV>this problem.</DIV>
<DIV>2. Hive ql is still at a rather immature stage, partly
because it's not</DIV>
<DIV>really intended to be a full featured relational database. There
are some</DIV>
<DIV> bugs too, like the join behavior is incorrect at the
current trunk.</DIV>
<DIV> </DIV>
<DIV>I know there is already a jira about it.</DIV>
<DIV><A style="COLOR: blue; TEXT-DECORATION: underline"
href="http://jira.pentaho.com/browse/MONDRIAN-789"
target=_blank>http://jira.pentaho.com/browse/MONDRIAN-789</A> </DIV>
<DIV>How can I submit the code? Thanks</DIV>
<DIV align=left><FONT color=#c0c0c0
face=Verdana>2011-02-10</FONT></DIV><FONT face=Verdana>
<HR style="MIN-HEIGHT: 2px; WIDTH: 122px" align=left SIZE=2>
<DIV><FONT color=#c0c0c0 face=Verdana><SPAN>Fu
Hongwei</SPAN></FONT></DIV></FONT></BLOCKQUOTE><FONT
face=Verdana></FONT></FONT></DIV></BLOCKQUOTE></FONT></DIV></BLOCKQUOTE></FONT></DIV></DIV></DIV>_______________________________________________
<DIV class=im><BR>Mondrian mailing list<BR><A
style="COLOR: blue; TEXT-DECORATION: underline"
href="mailto:Mondrian@pentaho.org"
target=_blank>Mondrian@pentaho.org</A><BR><A
style="COLOR: blue; TEXT-DECORATION: underline"
href="http://lists.pentaho.org/mailman/listinfo/mondrian"
target=_blank>http://lists.pentaho.org/mailman/listinfo/mondrian</A><BR></DIV></DIV></SPAN></BLOCKQUOTE></DIV><BR>
<DIV><SPAN
style="TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px"><SPAN
style="TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px"><SPAN
style="TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px"><SPAN
style="TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px"><SPAN
style="TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px"><SPAN
style="TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px"><SPAN
style="TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px"><SPAN
style="TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px"><SPAN
style="TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px"><SPAN
style="TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px"><SPAN
style="TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px"><SPAN
style="TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px"><SPAN
style="TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px"><SPAN
style="TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px"><SPAN
style="TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px"><SPAN
style="TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px">
<DIV style="WORD-WRAP: break-word">
<DIV>Calum Miller</DIV>
<DIV>Business Intelligence Specialist</DIV>
<DIV><A href="mailto:calum@millersoft.ltd.uk"
target=_blank>calum@millersoft.ltd.uk</A></DIV>
<DIV>
<DIV><A href="http://www.millersoft.ltd.uk"
target=_blank>http://www.millersoft.ltd.uk</A></DIV>
<DIV>Address: Stuart House, Eskmills, Station Road, Musselburgh, East Lothian,
Scotland, EH21 7PB </DIV>
<DIV>Location: <A href="http://www.eskmills.com"
target=_blank>http://www.eskmills.com</A></DIV></DIV>
<DIV>Telephone: +44 (0) 131 208 0202</DIV>
<DIV>Fax: +44 (0) 131 608 0037</DIV>
<DIV>Mobile: +44 (0) 7973 249 621</DIV>
<DIV>Skype: calummiller</DIV><BR><SPAN><IMG src="cid:__0@Foxmail.net"
width=400 height=145></SPAN>
</DIV></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></DIV><BR></DIV></DIV><BR>_______________________________________________<BR>Mondrian
mailing list<BR><A
href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</A><BR><A
href="http://lists.pentaho.org/mailman/listinfo/mondrian"
target=_blank>http://lists.pentaho.org/mailman/listinfo/mondrian</A><BR><BR></BLOCKQUOTE></DIV><BR></FONT></DIV></BODY></HTML>