CREATE EXTERNAL TABLE Account
(
ROWID String,
SYS_NAME String,
TYPE STRING,
INDUSTRY STRING,
ACCOUNTSOURCE STRING
)
STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler'
TBLPROPERTIES (
"hive.sql.database.type" = "MYSQL",
"hive.sql.jdbc.driver" = "com.ddtek.jdbc.sforce.SForceDriver",
"hive.sql.query" = "SELECT ROWID,SYS_NAME,TYPE,INDUSTRY,ACCOUNTSOURCE FROM SFORCE.ACCOUNT",
"hive.sql.column.mapping" = "ROWID=ROWID, SYS_NAME=SYS_NAME, TYPE=TYPE, INDUSTRY=INDUSTRY, ACCOUNTSOURCE=ACCOUNTSOURCE",
"hive.sql.dbcp.maxActive" = "1"
);