LinkedIn wherehows 增加hive数据库

rong224 2017-05-19 10:42:18
INSERT INTO wh_etl_job VALUES (12,'HIVE_DATASET_METADATA_ETL','DATASET','10 11 * * * ?',10,'DB',NULL,1495109470,'hive offline metadata etl','','Y');
INSERT INTO wh_etl_job_property VALUES (120,'HIVE_DATASET_METADATA_ETL',10,'DB','hive.dependency_csv_file','/data2/data/wherehows/tmp/hive_offline/dependency_csv','N',NULL),
(121,'HIVE_DATASET_METADATA_ETL',10,'DB','hive.field_metadata','/data2/data/wherehows/tmp/hive_offline/metadata','N',NULL),
(122,'HIVE_DATASET_METADATA_ETL',10,'DB','hive.schema_csv_file','/data2/data/wherehows/tmp/hive_offline/csv','N',NULL),
(123,'HIVE_DATASET_METADATA_ETL',10,'DB','hive.metastore.username','wherehows','N',NULL),
(124,'HIVE_DATASET_METADATA_ETL',10,'DB','hive.metastore.jdbc.driver','com.mysql.jdbc.Driver','N',NULL),
(125,'HIVE_DATASET_METADATA_ETL',10,'DB','hive.metastore.jdbc.url','jdbc:mysql://metadb-online.c5yzcdreb1xr.us-east-1.rds.amazonaws.com:3306/hive_emr_test?characterEncoding=UTF-8','N',NULL),
(126,'HIVE_DATASET_METADATA_ETL',10,'DB','hive.metastore.password','wherehows','N',NULL),
(127,'HIVE_DATASET_METADATA_ETL',10,'DB','hive.schema_json_file','/data2/data/wherehows/tmp/hive_offline/json','N',NULL),
(128,'HIVE_DATASET_METADATA_ETL',10,'DB','hive.instance_csv_file','/data2/data/wherehows/tmp/hive_offline/instance_csv','N',NULL),
(129,'HIVE_DATASET_METADATA_ETL',10,'DB','wherehows.db.jdbc.url','jdbc:mysql://172.31.25.11/wherehows?characterEncoding=UTF-8','N',NULL),
(130,'HIVE_DATASET_METADATA_ETL',10,'DB','wherehows.db.username','wherehows','N',NULL),
(131,'HIVE_DATASET_METADATA_ETL',10,'DB','wherehows.db.password','wherehows','N',NULL),
(132,'HIVE_DATASET_METADATA_ETL',10,'DB','wherehows.db.driver','com.mysql.jdbc.Driver','N',NULL);


INSERT INTO wh_property VALUES ('wherehows.app_folder','/data2/data/wherehows/tmp','N',NULL),('wherehows.db.driver','com.mysql.jdbc.Driver','N',NULL),('wherehows.db.jdbc.url','jdbc:mysql://172.31.25.11/wherehows','N',NULL),('wherehows.db.password','wherehows','N',NULL),('wherehows.db.username','wherehows','N',NULL),('wherehows.encrypt.master.key.loc','/data2/data/wherehows/tmp/.wherehows/master_key','N',NULL),('wherehows.ui.tree.dataset.file','/data2/data/wherehows/tmp/resource/dataset.json','N',NULL),('wherehows.ui.tree.flow.file','/data2/data/wherehows/tmp/resource/flow.json','N',NULL);

...全文
1773 1 打赏 收藏 转发到动态 举报
写回复
用AI写文章
1 条回复
切换为时间正序
请发表友善的回复…
发表回复
jeetliang 2017-11-01
  • 打赏
  • 举报
回复
有什么错误提示吗

2,497

社区成员

发帖
与我相关
我的任务
社区描述
Delphi 数据库相关
社区管理员
  • 数据库相关社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧