There is a ticket open for a JDBC storage handler. I envision this as a sqoop on demand.
Edward On Tue, May 31, 2011 at 8:31 AM, Guy Doulberg <[email protected]>wrote: > 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… > > > > > > Thanks, > > Guy Doulberg > > >
