hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrew Wilson" <>
Subject Re: RDBS and Hive
Date Tue, 31 May 2011 15:21:47 GMT
Yes, here is the ticket:<>

We use it fairly regularly in production and it works well. I will try to get a patch uploaded
On May 31, 2011, at 11:02 AM, Edward Capriolo wrote:

There is a ticket open for a JDBC storage handler. I envision this as a sqoop on demand.


On Tue, May 31, 2011 at 8:31 AM, Guy Doulberg <<>>
Hey friends,

I have been using Hive to explore my HDFS for a while now.

In my organization we have some applicative information in SqlServer that occasionally I need
to join with data I have in the HDFS.

When I need to do such a join, I import the data from the SqlServer using sqoop.

I wanted to know, if there is a way in which hive will import the data on demand, according
to the query, for example, if I am selecting from a table that hive recognizes as a SqlServer
table, it will import that table or(update if already exists) from sqlserver, and later will
run the select…

Guy Doulberg

View raw message