Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP TABLE HiveTable;
- CREATE EXTERNAL TABLE HiveTable(
- id INT,
- id_double DOUBLE,
- names STRING,
- test INT
- )
- STORED BY 'org.apache.hadoop.hive.jdbc.storagehandler.JdbcStorageHandler'
- TBLPROPERTIES (
- "mapred.jdbc.driver.class"="com.mysql.jdbc.Driver",
- "mapred.jdbc.url"="jdbc:mysql://localhost:3306/rstore",
- "mapred.jdbc.username"="root",
- "mapred.jdbc.input.table.name"="JDBCTable",
- "mapred.jdbc.output.table.name"="JDBCTable",
- "mapred.jdbc.password"="",
- "mapred.jdbc.hive.lazy.split"= "false"
- );
Add Comment
Please, Sign In to add comment