"But beware that the python client has been deprecated and you have to jump a few links to find the most recent one."
I've had success with PyHive<https://github.com/dropbox/PyHive> and it is maintained, works with SQL Alchemy / Pandas and all that good stuff. Would it be better to point Python users to that instead? Or at least mention in the wiki? Anyone have any opinions positive or negative? From: Furcy Pin <pin.fu...@gmail.com<mailto:pin.fu...@gmail.com>> Reply-To: "user@hive.apache.org<mailto:user@hive.apache.org>" <user@hive.apache.org<mailto:user@hive.apache.org>> Date: Saturday, November 11, 2017 at 01:25 To: "user@hive.apache.org<mailto:user@hive.apache.org>" <user@hive.apache.org<mailto:user@hive.apache.org>> Subject: Re: Options for connecting to Apache Hive Hi Jacob, Like Elliot and Alan said, cross-language exchanges seem to be handled using Thrift, and there are some ODBC drivers too. I didn't find a C library, even if they are python, ruby and nodeJS libraries. Also, when Googling, beware not to confuse HiveServer1 (sometimes refered to as Thrift Server) and HiverServer2. For instance this page seem to show some Python Clients for HiveServer1 https://cwiki.apache.org/confluence/display/Hive/HiveClient#HiveClient-ThriftC++Client links for Python and Ruby clients are given at the end of this page: https://cwiki.apache.org/confluence/display/Hive/Setting+Up+HiveServer2#SettingUpHiveServer2-PythonClientDriver But beware that the python client has been deprecated and you have to jump a few links to find the most recent one. Anyway, I also wrote some productivity tool for Hive (https://github.com/FurcyPin/flamy), which is only a Command-Line-Interface for now, but I am currently working on making a GUI with Scala Play + ReactJS. I believe it is hard to make a tool which is good for both PostgreSQL and Hive, because despite being SQL-based, they have different use-cases, different behaviors (Hive is generally much slower to respond small queries) and different syntax. If you decide not to spend time on adding Hive integration to your project, perhaps you could redirect the users that made that feature request to me. I would be happy to discuss their need with them, and for now, this is a one man project and I am mostly looking for users, so my work will remain free and open source. Regards, Furcy 2017-11-10 11:28 GMT+01:00 Jakob Egger <ja...@eggerapps.at<mailto:ja...@eggerapps.at>>: Hi! I'm the developer of a database client tool, and I've received a request to add support for querying Apache Hive. (My tool lets the user execute SQL queries, and it allows browsing tables etc.) As a first step of evaluating this suggestion, I'm trying to find out if there is a convenient way to connect to Hive. From reading the documentation, it seems that the preferred way to connect seems to be using the JDBC driver. Since my app is not written in Java, this is probably not the way to go. Apart from that, I didn't find much on this topic in the docs. I have a few questions: 1) What ways are there to connect to Apache Hive? 2) Is there a C client library? 3) Is there any documentation on the wire protocol that Hive uses for client / server communication? I'd appreciate if someone who knows more about the project could point me in the right direction! Best regards, Jakob
