LinkedIn wherehows 增加hive数据库
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);