{"id":3381,"date":"2021-06-02T16:50:14","date_gmt":"2021-06-02T08:50:14","guid":{"rendered":"https:\/\/wyxxt.org.cn\/?p=3381"},"modified":"2023-12-04T14:59:17","modified_gmt":"2023-12-04T06:59:17","slug":"hive%e6%90%ad%e5%bb%ba","status":"publish","type":"post","link":"https:\/\/wyxxt.org.cn\/?p=3381","title":{"rendered":"hive\u642d\u5efa\u2014\u2014\u8fdc\u7a0b\u6570\u636e\u5e93\u6a21\u5f0f"},"content":{"rendered":"

APACHE HIVE TM<\/a><\/p>\n

\u4e0b\u8f7d\u5b89\u88c5\u5305<\/h2>\n
wget https:\/\/mirrors.bfsu.edu.cn\/apache\/hive\/hive-2.3.8\/apache-hive-2.3.8-bin.tar.gz\nwget https:\/\/downloads.mysql.com\/archives\/get\/p\/3\/file\/mysql-connector-java-8.0.24.tar.gz\n<\/code><\/pre>\n
\u914d\u7f6e\u73af\u5883\u53d8\u91cf<\/h2>\n
vi \/etc\/profile\n# \u73af\u5883\u53d8\u91cf\u914d\u7f6e\u751f\u6548\nsource \/etc\/profile\n<\/code><\/pre>\n
export HIVE_HOME=\/bigdata\/apache-hive-2.3.8-bin\n<\/code><\/pre>\n
\u914d\u7f6e<\/h2>\n
mv hive-default.xml.template hive-site.xml\n<\/code><\/pre>\n
hive-site.xml<\/p>\n
<property>\n        <name>hive.metastore.warehouse.dir<\/name>\n        <value>\/user\/hive\/warehouse<\/value>\n<\/property>\n<property>\n        <name>javax.jdo.option.ConnectionURL<\/name>\n        <value>jdbc:mysql:\/\/node04\/hive?createDatabaseIfNotExist=true<\/value>\n<\/property>\n<property>\n        <name>javax.jdo.option.ConnectionDriverName<\/name>\n        <value>com.mysql.jdbc.Driver<\/value>\n<\/property>\n<property>\n        <name>javax.jdo.option.ConnectionUserName<\/name>\n        <value>root<\/value>\n<\/property>\n<property>\n        <name>javax.jdo.option.ConnectionPassword<\/name>\n        <value>123456<\/value>\n<\/property>\n<\/code><\/pre>\n\n\n\n\n\n
Configuration Parameter<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
hive.metastore.warehouse.dir<\/td>\nURI of the default location for native tables<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n\n\n\n\n\n
Config Param<\/th>\nConfig Value<\/th>\nComment<\/th>\n<\/tr>\n<\/thead>\n
javax.jdo.option.ConnectionURL<\/td>\njdbc:mysql:\/\/host name\/database name?createDatabaseIfNotExist=true<\/td>\nmetadata is stored in a MySQL server<\/td>\n<\/tr>\n
javax.jdo.option.ConnectionDriverName<\/td>\ncom.mysql.jdbc.Driver<\/td>\nMySQL JDBC driver class<\/td>\n<\/tr>\n
javax.jdo.option.ConnectionUserName<\/td>\nusername<\/td>\nuser name for connecting to MySQL server<\/td>\n<\/tr>\n
javax.jdo.option.ConnectionPassword<\/td>\npassword<\/td>\npassword for connecting to MySQL server<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
jar\u5305<\/h2>\n
cd lib\/\nmv \/bigdata\/mysql-connector-java-8.0.24\/mysql-connector-java-8.0.24.jar .\/\n<\/code><\/pre>\n
\u521d\u59cb\u5316<\/h2>\n
\u7b2c\u4e00\u6b21\u542f\u52a8<\/p>\n
schematool -dbType db type -initSchema<\/p>\n
schematool -dbType mysql -initSchema\n<\/code><\/pre>\n
\u542f\u52a8<\/h2>\n
hive\n<\/code><\/pre>\n
\u4f7f\u7528<\/h2>\n
\u65b0\u5efa\u8868<\/h3>\n
create table tbl(id int,age int);\n<\/code><\/pre>\n
\"\"<\/p>\n
\"\"<\/p>\n
\u67e5\u770b\u8868\u4fe1\u606f(\u5143\u6570\u636e)<\/h3>\n
desc formatted tbl;\n<\/code><\/pre>\n
\"\"<\/p>\n
\u63d2\u5165\u6570\u636e<\/h3>\n
insert into tbl values(1,1);\n<\/code><\/pre>\n
\"\"<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\u5206\u9694\u7b26<\/h3>\n
\u4e0b\u8f7d\u4e0b\u6765<\/p>\n
hdfs dfs -get \/user\/hive\/warehouse\/tbl\/*\n<\/code><\/pre>\n
\"\"<\/p>\n","protected":false},"excerpt":{"rendered":"
APACHE HIVE TM \u4e0b\u8f7d\u5b89\u88c5\u5305 wget https:\/\/mirrors.bfsu.edu.cn\/a […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[15],"tags":[389],"class_list":["post-3381","post","type-post","status-publish","format-standard","hentry","category-15","tag-389"],"_links":{"self":[{"href":"https:\/\/wyxxt.org.cn\/index.php?rest_route=\/wp\/v2\/posts\/3381","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wyxxt.org.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wyxxt.org.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wyxxt.org.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wyxxt.org.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3381"}],"version-history":[{"count":21,"href":"https:\/\/wyxxt.org.cn\/index.php?rest_route=\/wp\/v2\/posts\/3381\/revisions"}],"predecessor-version":[{"id":3430,"href":"https:\/\/wyxxt.org.cn\/index.php?rest_route=\/wp\/v2\/posts\/3381\/revisions\/3430"}],"wp:attachment":[{"href":"https:\/\/wyxxt.org.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3381"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wyxxt.org.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3381"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wyxxt.org.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3381"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}