<div>BTW, I'm working on Hive these days, so I'm available to help move things through as needed there.</div><div><br></div>JVS<br><br><div class="gmail_quote">On Mon, Aug 23, 2010 at 8:30 AM, Jordan Ganoff <span dir="ltr"><<a href="mailto:jganoff@pentaho.com">jganoff@pentaho.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div>
Calum,<br>
<br>
The PDI team recently did some research for using Apache's Hive database with Mondrian. You tweeted "Thinking of adding Hive dialect to Mondrian, too slow for add-hoc queries but would enable mdx reports against hadoop" on 11:21 AM Aug 22nd. This is an effort to give you a bit of heads up to some of the issues you'll encounter and the JIRA case with patches to Mondrian to get Hive working at a remedial level. Research done by James Dixon, Sean Flatley and myself found the following issues when integrating Hive with Mondrian 3.1.6.13364. We used our custom built Hive JDBC Driver[1] for testing:<br>
<br>
- Prepared Statements are mostly unimplemented in the JDBC driver from Apache in versions 0.5.0 and trunk (0.7.0). We are working on implementing more functionality as needed to get Report Designer and Metadata Editor working well. Our changes are being contributed back to the official Hive project but until they are accepted we're building our own version[1][2].<br>
<br>
- Join syntax generated by Mondrian is not compatible with Hive. In short, Hive does not support multiple items in the from clause.[2]<br>
<br>
See the related JIRA case with attached patches to get Mondrian 3.1.6.13364 to work with Hive and associated test results: <a href="http://jira.pentaho.com/browse/PDI-4355" target="_blank">http://jira.pentaho.com/browse/PDI-4355</a><br>
<br>
[1]: <a href="http://ci.pentaho.com/view/Data%20Integration/job/apache-hive-0.5.0/" target="_blank">http://ci.pentaho.com/view/Data%20Integration/job/apache-hive-0.5.0/</a><br>
[2]: <a href="http://forums.pentaho.com/showthread.php?77826-Hive-amp-Hadoop" target="_blank">http://forums.pentaho.com/showthread.php?77826-Hive-amp-Hadoop</a><br>
[3]: <a href="http://wiki.apache.org/hadoop/Hive/LanguageManual/Joins" target="_blank">http://wiki.apache.org/hadoop/Hive/LanguageManual/Joins</a><br>
<br>
Hope this helps,<br>
<br>
<table cellspacing="0" cellpadding="0" width="100%">
<tbody><tr>
<td>
Jordan Ganoff<br>
Software Engineer<br>
<img src="cid:1282575342.1957.0.camel@4rzjbd1" align="bottom" border="0"><br>
<b>Pentaho: The Commercial Open Source Alternative for Business Intelligence</b><br>
5950 Hazeltine National Drive, Suite 340 • Orlando, FL 32822, USA<br>
+1 407 812-OPEN (6736) • 407 517-6206 • 321 848-8207<br>
Get your free download today at <a href="http://www.pentaho.com/download" target="_blank">http://www.pentaho.com</a>.
</td>
</tr>
</tbody></table>
</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>