<!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"><LINK rel=stylesheet
href="BLOCKQUOTE{margin-Top: 0px; margin-Bottom: 0px; margin-Left: 2em}"></HEAD>
<BODY style="MARGIN: 10px; FONT-FAMILY: verdana; FONT-SIZE: 10pt">
<DIV><FONT color=#000080 size=2 face=Verdana>Hi All,</FONT></DIV>
<DIV><FONT color=#000080 size=2 face=Verdana>I've attached the patch
to</FONT></DIV>
<DIV>
<DIV><FONT color=#000080 face=Verdana><A
href="https://issues.apache.org/jira/browse/HIVE-1922?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12987548#action_12987548"><A
href="https://issues.apache.org/jira/browse/HIVE-1922?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12987548#action_12987548">https://issues.apache.org/jira/browse/HIVE-1922?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12987548#action_12987548</A></A>
</FONT></DIV>
<DIV><FONT color=#000080></FONT> </DIV>
<DIV><FONT color=#000080>It works fine on my machine, Hive0.7.0 and hadoop
0.20.0</FONT></DIV>
<DIV><FONT color=#000080>Please tell me if anything wrong.</FONT></DIV></DIV>
<DIV><FONT color=#000080 size=2 face=Verdana></FONT> </DIV>
<DIV><FONT color=#c0c0c0 size=2 face=Verdana>2011-02-13 </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> Calum Miller </FONT></DIV>
<DIV><FONT size=2 face=Verdana><STRONG>发送时间：</STRONG> 2011-02-12 02:28:47
</FONT></DIV>
<DIV><FONT size=2 face=Verdana><STRONG>收件人：</STRONG> jhyde@pentaho.com; 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>I have time next week to help make necessary Mondrian dialect changes.
Happy to start on Monday if Jira is updated?</DIV>
<DIV><BR></DIV>
<DIV>Calum<BR><BR>Sent from my iPhone</DIV>
<DIV><BR>On 11 Feb 2011, at 17:51, "Julian Hyde" <<A
href="mailto:jhyde@pentaho.com">jhyde@pentaho.com</A>> wrote:<BR><BR></DIV>
<DIV></DIV>
<BLOCKQUOTE type="cite">
<DIV>
<DIV><SPAN class=298333117-11022011><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 class=298333117-11022011><FONT
face=verdana></FONT></SPAN> </DIV>
<DIV><SPAN class=298333117-11022011><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 class=298333117-11022011><FONT
face=verdana></FONT></SPAN> </DIV>
<DIV><SPAN class=298333117-11022011>
<DIV><SPAN class=298333117-11022011><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 class=298333117-11022011><FONT
face=verdana></FONT></SPAN> </DIV></SPAN></DIV>
<DIV><SPAN class=298333117-11022011><FONT
face=verdana>Julian</FONT></SPAN></DIV>
<DIV><SPAN class=298333117-11022011><FONT
face=verdana></FONT></SPAN> </DIV><BR>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"
dir=ltr>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT face=Tahoma><B>From:</B> <A
href="mailto:mondrian-bounces@pentaho.org">mondrian-bounces@pentaho.org</A>
[mailto:mondrian-bounces@pentaho.org] <B>On Behalf Of </B>Fu
Hongwei<BR><B>Sent:</B> Friday, February 11, 2011 3:53 AM<BR><B>To:</B>
'Mondrian developer mailing list'<BR><B>Subject:</B> 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
href="https://issues.apache.org/jira/browse/HIVE-1922?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12987548#action_12987548"><A
href="https://issues.apache.org/jira/browse/HIVE-1922?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12987548#action_12987548">https://issues.apache.org/jira/browse/HIVE-1922?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12987548#action_12987548</A></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 </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> Julian Hyde </FONT></DIV>
<DIV><FONT face=Verdana><STRONG>发送时间：</STRONG> 2011-02-11 00:19:26
</FONT></DIV>
<DIV><FONT face=Verdana><STRONG>收件人：</STRONG> 'Mondrian developer mailing
list' </FONT></DIV>
<DIV><FONT face=Verdana><STRONG>抄送：</STRONG> </FONT></DIV>
<DIV><FONT face=Verdana><STRONG>主题：</STRONG> RE: [Mondrian] Testing a Hive
dialect </FONT></DIV>
<DIV><FONT face=Verdana></FONT></DIV>
<DIV><FONT face=Verdana>
<DIV><SPAN class=038011016-10022011><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 class=038011016-10022011><FONT
face=verdana></FONT></SPAN> </DIV>
<DIV><SPAN class=038011016-10022011>
<DIV><SPAN class=038011016-10022011><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 class=038011016-10022011><FONT
face=verdana></FONT></SPAN> </DIV>
<DIV><SPAN class=038011016-10022011><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 class=038011016-10022011><FONT
face=verdana></FONT></SPAN> </DIV>
<DIV><SPAN class=038011016-10022011><FONT
face=verdana>Julian</FONT></SPAN></DIV></SPAN></DIV><BR>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"
dir=ltr>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT face=Tahoma><B>From:</B> <A
href="mailto:mondrian-bounces@pentaho.org">mondrian-bounces@pentaho.org</A>
[mailto:mondrian-bounces@pentaho.org] <B>On Behalf Of </B>Fu
Hongwei<BR><B>Sent:</B> Thursday, February 10, 2011 1:29 AM<BR><B>To:</B>
mondrian<BR><B>Subject:</B> [Mondrian] Testing a Hive dialect
<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 href="http://jira.pentaho.com/browse/MONDRIAN-789"><A
href="http://jira.pentaho.com/browse/MONDRIAN-789">http://jira.pentaho.com/browse/MONDRIAN-789</A></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="WIDTH: 122px; HEIGHT: 2px" 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></DIV></BLOCKQUOTE>
<BLOCKQUOTE type="cite">
<DIV><SPAN>_______________________________________________</SPAN><BR><SPAN>Mondrian
mailing list</SPAN><BR><SPAN><A
href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</A></SPAN><BR><SPAN><A
href="http://lists.pentaho.org/mailman/listinfo/mondrian">http://lists.pentaho.org/mailman/listinfo/mondrian</A></SPAN><BR></DIV></BLOCKQUOTE></FONT></DIV></BODY></HTML>