Skip to content

james-andrewsmith/HiveJdbcStorageHandler

 
 

Repository files navigation

HiveJdbcStorageHandler

This project is still work in progress intending to submit a patch for HIVE-1555.

BASIC USAGE

hive --auxpath /home/myui/tmp/jdbc-storagehandler.jar;

CREATE EXTERNAL TABLE pg_model_sample90p (
  feature INT, 
  weight DOUBLE
)
STORED BY 'org.apache.hadoop.hive.jdbc.storagehandler.JdbcStorageHandler'
TBLPROPERTIES (
  "mapred.jdbc.driver.class"="org.postgresql.Driver",
  "mapred.jdbc.url"="jdbc:postgresql://host01/kddtrack2",
  "mapred.jdbc.username"="myui",
  "mapred.jdbc.input.table.name"="model_sample90p"
);

select * from pg_model_sample90p limit 10;

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • Java 100.0%