How to mount/proxy a db table in hive

[amit jaiswal]

Hi,

I have a database and am looking for a way to 'mount' the db table in hive in 
such a way that the select query in hive gets translated to sql query for 
database. I saw DBInputFormat and sqoop, but nothing that can create a proxy 
table in hive which internally makes db calls.

I also tried to use custom variant of DBInputFormat as the input format for the 
database table.

create table employee (id int, name string) stored as INPUTFORMAT 
'mycustominputformat' OUTPUTFORMAT 
'org.apache.hadoop.mapred.SequenceFileOutputFormat';

select id from employee;
This fails while running hadoop job because HiveInputFormat only supports 
FileSplits.

HiveInputFormat:
    public long getStart() {
      if (inputSplit instanceof FileSplit) {
        return ((FileSplit)inputSplit).getStart();
      }
      return 0;
    }

Any suggestions as if there are any InputFormat implementation that can be 
used? 

-amit