Update... I eventually succeed in making the ODBC/JDBC bridge from Easysoft to work..... So I made simple reports on top of hive.... So far so good
From: Guy Doulberg [mailto:guy.doulb...@conduit.com] Sent: Monday, July 18, 2011 2:31 PM To: user@hive.apache.org Subject: RE: ODBC/JDBC Bridge If I wasn't oblige to try and make the hive cluster interact with MS reporting service, I would try to use BIRT, following this lead.... http://www.eclipse.org/birt/phoenix/project/notable3.7.php It seems it can provide BI/data mining/query on top of hive. Of course if you want simple query I guess Cloudera's Beeswax is also a suitable ui. From: Liam Friel [mailto:liam.fr...@gmail.com] Sent: Monday, July 18, 2011 11:37 AM To: user@hive.apache.org Subject: Re: ODBC/JDBC Bridge I don't, but I'd also be very interested in an answer for this issue. A search of the various fora and mailing lists did not show a definite answer, and there is an open Jira item (which I see you found :-) ) on this topic. In general what client-side BI/data mining/query tools are people using to allow a degree of user friendly querying of your Hive warehouses and display of the results? Especially from Windows client platforms. Do you roll your own, or use off the shelf/open source/commercial products? We're building a small cluster for some research and scaling experiments, Linux based of course. That all works fine, however I'm wondering how to plumb it into non-Linux client populations and I'd rather not set out to make new widgets myself if that's avoidable. On Mon, Jul 18, 2011 at 8:50 AM, Guy Doulberg <guy.doulb...@conduit.com<mailto:guy.doulb...@conduit.com>> wrote: Hi, I am trying to enable my clients to use MS Reporting Service (That is their demand), I tried to configure this ODBC/JDBC bridge: http://www.easysoft.com/products/data_access/odbc_jdbc_gateway/index.html With no success of obtaining license key (seems like this company has vanished from earth(their emails are rerturning). Has someone have any experience with this bridge or another bridge? Has someone ever succeed with connecting ODBC to Hive with any other method? Is someone working on this task and needs help? I am willing to assist such a open-source project Thanks, Guy Doulberg
