2021-07-14

useradd -m hadoop -s /bin/bash

tail -f /var/log/cron

systemctl status crond.service
systemctl start crond.service
systemctl stop crond.service
systemctl restart crond.service
systemctl reload crond.service

systemctl enable crond.service
systemctl is-enabled crond.service

cat /etc/redhat-release
CentOS Linux release 8.2.2004 (Core)

wget https://mirrors.tuna.tsinghua.edu.cn/apache/hive/hive-3.1.2/apache-hive-3.1.2-bin.tar.gz --no-check-certificate

wget https://mirrors.tuna.tsinghua.edu.cn/apache/hadoop/common/hadoop-2.10.1/hadoop-2.10.1.tar.gz --no-check-certificate

/root>find cosdata/ep_updated | grep orc | awk -F/ ‘{ printf “LOAD DATA LOCAL INPATH /root/cosdata/%s/%s/%s INTO TABLE %s\n”, $2, $3, $4, $3}’
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_patents_relations/part-00000-600de01a-2588-41e8-9639-e766c46d0210-c000.zlib.orc INTO TABLE t_patents_relations
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_admin_division_code/part-00000-04ba30ec-ddce-49e6-9085-4405eee63999-c000.zlib.orc INTO TABLE t_admin_division_code
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_trademarks/part-00000-622fbebe-3c1d-4f4a-9d0e-6e01a652110a-c000.zlib.orc INTO TABLE t_trademarks
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_judicial_freezes/part-00000-e3e073c8-4748-4499-ae32-c4204a7d0cfd-c000.zlib.orc INTO TABLE t_judicial_freezes
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_employees/part-00000-ceca5ecd-01aa-4c15-ae35-8769a1db7392-c000.zlib.orc INTO TABLE t_employees
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_change_records/part-00000-75171bba-cddb-4d02-9c63-225884d1ff4d-c000.zlib.orc INTO TABLE t_change_records
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_checkups/part-00000-a7560649-5864-4ec3-9b36-e63daa2b7df2-c000.zlib.orc INTO TABLE t_checkups
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_pay_taxes/part-00000-fb05baca-eb5e-479d-92f3-d33ecd3f6a1f-c000.zlib.orc INTO TABLE t_pay_taxes
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_branches/part-00000-b962a83e-72fb-4c5b-8c61-190f7304ac6f-c000.zlib.orc INTO TABLE t_branches
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_last_industry/part-00000-ed18b44d-a2b7-46fc-b10c-0c725ed4cac8-c000.zlib.orc INTO TABLE t_last_industry
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_investments/part-00000-9e0555a4-3709-48cd-97cf-9b1948a66660-c000.zlib.orc INTO TABLE t_investments
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_executions/part-00000-c0369a32-46f9-46dd-b949-a0019efdf90b-c000.zlib.orc INTO TABLE t_executions
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_equityquality/part-00000-ab5697be-1f16-4ff7-b485-7f09c5b4657a-c000.zlib.orc INTO TABLE t_equityquality
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_administrative_punishment/part-00000-bf75b753-307b-4849-9113-e060a5096d13-c000.zlib.orc INTO TABLE t_administrative_punishment
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_kaitinggonggaos_relations/part-00000-63fe6940-2058-459f-9c40-fa5dfd8e0fbb-c000.zlib.orc INTO TABLE t_kaitinggonggaos_relations
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_clear_account/part-00000-bceb7186-ed6b-4be1-b475-775306514cd5-c000.zlib.orc INTO TABLE t_clear_account
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_ent_brief/part-00000-bb4b7c57-e3b8-4108-9315-666b478e80fe-c000.zlib.orc INTO TABLE t_ent_brief
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_other_infomation/part-00000-ec571924-fa20-4994-ab07-73b245be4871-c000.zlib.orc INTO TABLE t_other_infomation
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_abnormal/part-00000-5668026b-13c5-4ae5-86f6-83c83102a36c-c000.zlib.orc INTO TABLE t_abnormal
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_best_stockholder_percentage/part-00000-4ab1a881-dbf7-4454-9f48-aba57cfbe3a6-c000.zlib.orc INTO TABLE t_best_stockholder_percentage
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_currency_code/part-00000-5dfd8c43-a97f-4206-8509-84b19f1e7d8d-c000.zlib.orc INTO TABLE t_currency_code
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_lawsuits_relations/part-00000-b00de81e-2abb-4fde-9145-49bcab751adf-c000.zlib.orc INTO TABLE t_lawsuits_relations
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_notices_relations/part-00000-458c4e8f-10e0-4082-944f-8f0578b6c0b2-c000.zlib.orc INTO TABLE t_notices_relations
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_project_finances/part-00000-e124a4d3-5fb9-4f1e-830e-b6f3424e9828-c000.zlib.orc INTO TABLE t_project_finances
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_copyrights_relations/part-00000-8a0abf1c-4bcb-44b9-af8d-c089f049f0d1-c000.zlib.orc INTO TABLE t_copyrights_relations
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_mortgages/part-00000-055e9aef-2caf-45a1-a6e6-e73672122cba-c000.zlib.orc INTO TABLE t_mortgages
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_industry_code/part-00000-77e1797d-73e4-485b-af8f-e3ef8c61068b-c000.zlib.orc INTO TABLE t_industry_code
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_auctions_relations/part-00000-f8b765e1-eb17-4660-ae2d-fc493ca410a3-c000.zlib.orc INTO TABLE t_auctions_relations
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_enterprise/part-00000-4dcec644-6a2d-44a1-a86f-110329ad3162-c000.zlib.orc INTO TABLE t_enterprise
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_serious_illegal/part-00000-77294f35-215f-4666-8ab2-cc4b2224f8f8-c000.zlib.orc INTO TABLE t_serious_illegal
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_job_title_code/part-00000-21d9d094-0f46-4907-a38d-d20994c3100a-c000.zlib.orc INTO TABLE t_job_title_code
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_biddingsall_cache/part-00000-4cf51434-309c-4e87-aecf-7782c3182f27-c000.zlib.orc INTO TABLE t_biddingsall_cache
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_overduetaxs/part-00000-20f90b85-d56a-43bd-b5b5-ae8876efeb99-c000.zlib.orc INTO TABLE t_overduetaxs
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_address/part-00001-ac0674d0-3777-4369-9718-a7a297d75771-c000.zlib.orc INTO TABLE t_address
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_address/part-00000-ac0674d0-3777-4369-9718-a7a297d75771-c000.zlib.orc INTO TABLE t_address
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_creditimportexport_data/part-00000-d24aa6b2-885d-43f2-89d7-2289067cf479-c000.zlib.orc INTO TABLE t_creditimportexport_data
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_license_info/part-00000-ba8b2af8-80a4-4946-a7f3-3da0fd7751a1-c000.zlib.orc INTO TABLE t_license_info
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_partners/part-00000-8b35e54f-a271-45bb-81b0-2c05c5a2fe8f-c000.zlib.orc INTO TABLE t_partners
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_certificates/part-00000-63bea119-6f17-4cb0-8d92-36f42e8664b6-c000.zlib.orc INTO TABLE t_certificates
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_domains/part-00000-484151ba-e4c3-4ea4-99e2-2edfd6f0bab6-c000.zlib.orc INTO TABLE t_domains
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_executedpersons/part-00000-bff1bebb-5eda-4b3a-b2cd-14afac039ae0-c000.zlib.orc INTO TABLE t_executedpersons
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_quoted_companies/part-00000-4d7a51c2-7d33-4799-9329-82263d23508a-c000.zlib.orc INTO TABLE t_quoted_companies
LOAD DATA LOCAL INPATH /root/cosdata/ep_updated/t_new_jobs/part-00000-cfbc01e6-a7ba-4ace-bf02-c04827e876ae-c000.zlib.orc INTO TABLE t_new_jobs
/root>