SqlDbx Forum

SqlDbx

You are not logged in.

#1 2016-07-28 16:51:07

ashleym8
Member

Hive Database and Object Explorer

Hi all! I was able to connect to a Hive database using a MapR driver and ODBC connection. The queries work fine, but I can't see any of the tables in the Object Browser. My team usually relies on the Object Browser to...browse objects...so I am trying to find out whether this is something we could potentially fix, or if it's a definite limitation of ODBC. Has anyone had experience with missing tables in object browser using ODBC, especially if you're using Hive?

Offline

#2 2016-07-28 21:42:12

sqldbxhelp
Administrator

Re: Hive Database and Object Explorer

This is definitely something we can look into.
Unfortunately we do not have any experience with MapR ODBC driver or Hive database,
so it's hard to say how long it will take to resolve this issue.

Online

#3 2016-10-31 13:47:19

moccq
Member

Re: Hive Database and Object Explorer

ashleym8:  I have installed v4.17 SqlDbx, MapR driver 3.02 client 32 bit, tests out ok via control panel User DSN entry and have connected to a Hive and can see tables etc.  Seem lacking in meta-data capability.  I have noting set under ODBC advanced options.

Last edited by moccq (2016-10-31 15:26:10)

Offline

#4 2016-11-01 09:27:43

sqldbxhelp
Administrator

Re: Hive Database and Object Explorer

Next release of SqlDbx will have enhanced support for Apache Hive

Online

Board footer

Powered by FluxBB