杨校老师课题之Hive数据仓库搭建1:https://developer.aliyun.com/article/1543265
- 上传MySQL驱动包到 lib目录内
利用rz命令实现上传操作
[root@hadoop1 apache-hive-1.2.2-bin]# ll 总用量 84 drwxr-xr-x. 4 root root 156 4月 23 15:15 bin drwxr-xr-x. 2 root root 252 4月 23 17:36 conf -rw-r--r--. 1 root root 21108 4月 23 15:20 derby.log drwxr-xr-x. 4 root root 34 4月 23 15:14 examples drwxr-xr-x. 7 root root 68 4月 23 15:14 hcatalog drwxr-xr-x. 4 root root 8192 4月 23 15:14 lib -rw-r--r--. 1 root root 24754 3月 31 2017 LICENSE drwxr-xr-x. 5 root root 133 4月 23 15:20 metastore_db -rw-r--r--. 1 root root 397 3月 31 2017 NOTICE -rw-r--r--. 1 root root 4374 4月 1 2017 README.txt -rw-r--r--. 1 root root 4255 4月 1 2017 RELEASE_NOTES.txt drwxr-xr-x. 3 root root 23 4月 23 15:14 scripts [root@hadoop1 apache-hive-1.2.2-bin]# cd lib/ [root@hadoop1 lib]# ll 总用量 93528 -rw-r--r--. 1 root root 4368200 3月 18 2017 accumulo-core-1.6.0.jar -rw-r--r--. 1 root root 102069 3月 18 2017 accumulo-fate-1.6.0.jar -rw-r--r--. 1 root root 57420 3月 18 2017 accumulo-start-1.6.0.jar -rw-r--r--. 1 root root 117409 3月 18 2017 accumulo-trace-1.6.0.jar -rw-r--r--. 1 root root 62983 3月 18 2017 activation-1.1.jar -rw-r--r--. 1 root root 1997485 3月 18 2017 ant-1.9.1.jar -rw-r--r--. 1 root root 18336 3月 18 2017 ant-launcher-1.9.1.jar -rw-r--r--. 1 root root 445288 3月 18 2017 antlr-2.7.7.jar -rw-r--r--. 1 root root 164368 3月 18 2017 antlr-runtime-3.4.jar -rw-r--r--. 1 root root 30359 3月 18 2017 apache-curator-2.6.0.pom -rw-r--r--. 1 root root 448794 3月 18 2017 apache-log4j-extras-1.2.17.jar -rw-r--r--. 1 root root 32693 3月 18 2017 asm-commons-3.1.jar -rw-r--r--. 1 root root 21879 3月 18 2017 asm-tree-3.1.jar -rw-r--r--. 1 root root 400680 3月 18 2017 avro-1.7.5.jar -rw-r--r--. 1 root root 110600 3月 18 2017 bonecp-0.8.0.RELEASE.jar -rw-r--r--. 1 root root 258370 3月 18 2017 calcite-avatica-1.2.0-incubating.jar -rw-r--r--. 1 root root 3519262 3月 18 2017 calcite-core-1.2.0-incubating.jar -rw-r--r--. 1 root root 442406 3月 18 2017 calcite-linq4j-1.2.0-incubating.jar -rw-r--r--. 1 root root 188671 3月 18 2017 commons-beanutils-1.7.0.jar -rw-r--r--. 1 root root 206035 3月 18 2017 commons-beanutils-core-1.8.0.jar -rw-r--r--. 1 root root 41123 3月 18 2017 commons-cli-1.2.jar -rw-r--r--. 1 root root 58160 3月 18 2017 commons-codec-1.4.jar -rw-r--r--. 1 root root 588337 3月 18 2017 commons-collections-3.2.2.jar -rw-r--r--. 1 root root 30595 3月 18 2017 commons-compiler-2.7.6.jar -rw-r--r--. 1 root root 241367 3月 18 2017 commons-compress-1.4.1.jar -rw-r--r--. 1 root root 298829 3月 18 2017 commons-configuration-1.6.jar -rw-r--r--. 1 root root 160519 3月 18 2017 commons-dbcp-1.4.jar -rw-r--r--. 1 root root 143602 3月 18 2017 commons-digester-1.8.jar -rw-r--r--. 1 root root 279781 3月 18 2017 commons-httpclient-3.0.1.jar -rw-r--r--. 1 root root 185140 3月 18 2017 commons-io-2.4.jar -rw-r--r--. 1 root root 284220 3月 18 2017 commons-lang-2.6.jar -rw-r--r--. 1 root root 62050 3月 18 2017 commons-logging-1.1.3.jar -rw-r--r--. 1 root root 832410 3月 18 2017 commons-math-2.1.jar -rw-r--r--. 1 root root 96221 3月 18 2017 commons-pool-1.5.4.jar -rw-r--r--. 1 root root 415578 3月 18 2017 commons-vfs2-2.0.jar -rw-r--r--. 1 root root 68866 3月 18 2017 curator-client-2.6.0.jar -rw-r--r--. 1 root root 185245 3月 18 2017 curator-framework-2.6.0.jar -rw-r--r--. 1 root root 248171 3月 18 2017 curator-recipes-2.6.0.jar -rw-r--r--. 1 root root 339666 3月 18 2017 datanucleus-api-jdo-3.2.6.jar -rw-r--r--. 1 root root 1890075 3月 18 2017 datanucleus-core-3.2.10.jar -rw-r--r--. 1 root root 1809447 3月 18 2017 datanucleus-rdbms-3.2.9.jar -rw-r--r--. 1 root root 2838580 3月 18 2017 derby-10.10.2.0.jar -rw-r--r--. 1 root root 18482 3月 18 2017 eigenbase-properties-1.1.5.jar -rw-r--r--. 1 root root 12452 3月 18 2017 geronimo-annotation_1.0_spec-1.1.1.jar -rw-r--r--. 1 root root 30548 3月 18 2017 geronimo-jaspic_1.0_spec-1.0.jar -rw-r--r--. 1 root root 16030 3月 18 2017 geronimo-jta_1.1_spec-1.1.1.jar -rw-r--r--. 1 root root 6377448 3月 18 2017 groovy-all-2.1.6.jar -rw-r--r--. 1 root root 2189117 3月 18 2017 guava-14.0.1.jar -rw-r--r--. 1 root root 76643 3月 18 2017 hamcrest-core-1.1.jar -rw-r--r--. 1 root root 121082 4月 3 2017 hive-accumulo-handler-1.2.2.jar -rw-r--r--. 1 root root 47764 4月 3 2017 hive-ant-1.2.2.jar -rw-r--r--. 1 root root 138274 4月 3 2017 hive-beeline-1.2.2.jar -rw-r--r--. 1 root root 38367 4月 3 2017 hive-cli-1.2.2.jar -rw-r--r--. 1 root root 290835 4月 3 2017 hive-common-1.2.2.jar -rw-r--r--. 1 root root 120561 4月 3 2017 hive-contrib-1.2.2.jar -rw-r--r--. 1 root root 20608029 4月 3 2017 hive-exec-1.2.2.jar -rw-r--r--. 1 root root 114730 4月 3 2017 hive-hbase-handler-1.2.2.jar -rw-r--r--. 1 root root 27390 4月 3 2017 hive-hwi-1.2.2.jar -rw-r--r--. 1 root root 100417 4月 3 2017 hive-jdbc-1.2.2.jar -rw-r--r--. 1 root root 15594358 4月 3 2017 hive-jdbc-1.2.2-standalone.jar -rw-r--r--. 1 root root 5470775 4月 3 2017 hive-metastore-1.2.2.jar -rw-r--r--. 1 root root 916566 4月 3 2017 hive-serde-1.2.2.jar -rw-r--r--. 1 root root 1865061 4月 3 2017 hive-service-1.2.2.jar -rw-r--r--. 1 root root 32242 4月 3 2017 hive-shims-0.20S-1.2.2.jar -rw-r--r--. 1 root root 59903 4月 3 2017 hive-shims-0.23-1.2.2.jar -rw-r--r--. 1 root root 8966 4月 3 2017 hive-shims-1.2.2.jar -rw-r--r--. 1 root root 109178 4月 3 2017 hive-shims-common-1.2.2.jar -rw-r--r--. 1 root root 13084 4月 3 2017 hive-shims-scheduler-1.2.2.jar -rw-r--r--. 1 root root 14524 4月 3 2017 hive-testutils-1.2.2.jar -rw-r--r--. 1 root root 719304 3月 18 2017 httpclient-4.4.jar -rw-r--r--. 1 root root 321639 3月 18 2017 httpcore-4.4.jar -rw-r--r--. 1 root root 1282424 3月 18 2017 ivy-2.4.0.jar -rw-r--r--. 1 root root 611863 3月 18 2017 janino-2.7.6.jar -rw-r--r--. 1 root root 60527 3月 18 2017 jcommander-1.32.jar -rw-r--r--. 1 root root 201124 3月 18 2017 jdo-api-3.0.1.jar -rw-r--r--. 1 root root 1681148 3月 18 2017 jetty-all-7.6.0.v20120127.jar -rw-r--r--. 1 root root 1683027 3月 18 2017 jetty-all-server-7.6.0.v20120127.jar -rw-r--r--. 1 root root 213854 3月 18 2017 jline-2.12.jar -rw-r--r--. 1 root root 588001 3月 18 2017 joda-time-2.5.jar -rw-r--r--. 1 root root 12131 3月 18 2017 jpam-1.1.jar -rw-r--r--. 1 root root 45944 3月 18 2017 json-20090211.jar -rw-r--r--. 1 root root 33031 3月 18 2017 jsr305-3.0.0.jar -rw-r--r--. 1 root root 15071 3月 18 2017 jta-1.1.jar -rw-r--r--. 1 root root 245039 3月 18 2017 junit-4.11.jar -rw-r--r--. 1 root root 313686 3月 18 2017 libfb303-0.9.2.jar -rw-r--r--. 1 root root 227712 3月 18 2017 libthrift-0.9.2.jar -rw-r--r--. 1 root root 481535 3月 18 2017 log4j-1.2.16.jar -rw-r--r--. 1 root root 447676 3月 18 2017 mail-1.4.1.jar -rw-r--r--. 1 root root 94421 3月 18 2017 maven-scm-api-1.4.jar -rw-r--r--. 1 root root 40066 3月 18 2017 maven-scm-provider-svn-commons-1.4.jar -rw-r--r--. 1 root root 69858 3月 18 2017 maven-scm-provider-svnexe-1.4.jar -rw-r--r--. 1 root root 1208356 3月 18 2017 netty-3.7.0.Final.jar -rw-r--r--. 1 root root 19827 3月 18 2017 opencsv-2.3.jar -rw-r--r--. 1 root root 65261 3月 18 2017 oro-2.0.8.jar -rw-r--r--. 1 root root 29555 3月 18 2017 paranamer-2.3.jar -rw-r--r--. 1 root root 2796935 3月 18 2017 parquet-hadoop-bundle-1.6.0.jar -rw-r--r--. 1 root root 48557 3月 18 2017 pentaho-aggdesigner-algorithm-5.1.5-jhyde.jar drwxr-xr-x. 6 root root 104 4月 23 15:14 php -rw-r--r--. 1 root root 250546 3月 18 2017 plexus-utils-1.5.6.jar drwxr-xr-x. 10 root root 150 4月 23 15:14 py -rw-r--r--. 1 root root 25429 3月 18 2017 regexp-1.3.jar -rw-r--r--. 1 root root 105112 3月 18 2017 servlet-api-2.5.jar -rw-r--r--. 1 root root 1251514 3月 18 2017 snappy-java-1.0.5.jar -rw-r--r--. 1 root root 236660 3月 18 2017 ST4-4.0.4.jar -rw-r--r--. 1 root root 26514 3月 18 2017 stax-api-1.0.1.jar -rw-r--r--. 1 root root 148627 3月 18 2017 stringtemplate-3.2.1.jar -rw-r--r--. 1 root root 93210 3月 18 2017 super-csv-2.2.0.jar -rw-r--r--. 1 root root 55953 3月 18 2017 tempus-fugit-1.1.jar -rw-r--r--. 1 root root 392124 3月 18 2017 velocity-1.5.jar -rw-r--r--. 1 root root 94672 3月 18 2017 xz-1.0.jar -rw-r--r--. 1 root root 792964 3月 18 2017 zookeeper-3.4.6.jar [root@hadoop1 lib]# rz -E rz waiting to receive. [root@hadoop1 lib]# ll 总用量 94512 -rw-r--r--. 1 root root 4368200 3月 18 2017 accumulo-core-1.6.0.jar -rw-r--r--. 1 root root 102069 3月 18 2017 accumulo-fate-1.6.0.jar -rw-r--r--. 1 root root 57420 3月 18 2017 accumulo-start-1.6.0.jar -rw-r--r--. 1 root root 117409 3月 18 2017 accumulo-trace-1.6.0.jar -rw-r--r--. 1 root root 62983 3月 18 2017 activation-1.1.jar -rw-r--r--. 1 root root 1997485 3月 18 2017 ant-1.9.1.jar -rw-r--r--. 1 root root 18336 3月 18 2017 ant-launcher-1.9.1.jar -rw-r--r--. 1 root root 445288 3月 18 2017 antlr-2.7.7.jar -rw-r--r--. 1 root root 164368 3月 18 2017 antlr-runtime-3.4.jar -rw-r--r--. 1 root root 30359 3月 18 2017 apache-curator-2.6.0.pom -rw-r--r--. 1 root root 448794 3月 18 2017 apache-log4j-extras-1.2.17.jar -rw-r--r--. 1 root root 32693 3月 18 2017 asm-commons-3.1.jar -rw-r--r--. 1 root root 21879 3月 18 2017 asm-tree-3.1.jar -rw-r--r--. 1 root root 400680 3月 18 2017 avro-1.7.5.jar -rw-r--r--. 1 root root 110600 3月 18 2017 bonecp-0.8.0.RELEASE.jar -rw-r--r--. 1 root root 258370 3月 18 2017 calcite-avatica-1.2.0-incubating.jar -rw-r--r--. 1 root root 3519262 3月 18 2017 calcite-core-1.2.0-incubating.jar -rw-r--r--. 1 root root 442406 3月 18 2017 calcite-linq4j-1.2.0-incubating.jar -rw-r--r--. 1 root root 188671 3月 18 2017 commons-beanutils-1.7.0.jar -rw-r--r--. 1 root root 206035 3月 18 2017 commons-beanutils-core-1.8.0.jar -rw-r--r--. 1 root root 41123 3月 18 2017 commons-cli-1.2.jar -rw-r--r--. 1 root root 58160 3月 18 2017 commons-codec-1.4.jar -rw-r--r--. 1 root root 588337 3月 18 2017 commons-collections-3.2.2.jar -rw-r--r--. 1 root root 30595 3月 18 2017 commons-compiler-2.7.6.jar -rw-r--r--. 1 root root 241367 3月 18 2017 commons-compress-1.4.1.jar -rw-r--r--. 1 root root 298829 3月 18 2017 commons-configuration-1.6.jar -rw-r--r--. 1 root root 160519 3月 18 2017 commons-dbcp-1.4.jar -rw-r--r--. 1 root root 143602 3月 18 2017 commons-digester-1.8.jar -rw-r--r--. 1 root root 279781 3月 18 2017 commons-httpclient-3.0.1.jar -rw-r--r--. 1 root root 185140 3月 18 2017 commons-io-2.4.jar -rw-r--r--. 1 root root 284220 3月 18 2017 commons-lang-2.6.jar -rw-r--r--. 1 root root 62050 3月 18 2017 commons-logging-1.1.3.jar -rw-r--r--. 1 root root 832410 3月 18 2017 commons-math-2.1.jar -rw-r--r--. 1 root root 96221 3月 18 2017 commons-pool-1.5.4.jar -rw-r--r--. 1 root root 415578 3月 18 2017 commons-vfs2-2.0.jar -rw-r--r--. 1 root root 68866 3月 18 2017 curator-client-2.6.0.jar -rw-r--r--. 1 root root 185245 3月 18 2017 curator-framework-2.6.0.jar -rw-r--r--. 1 root root 248171 3月 18 2017 curator-recipes-2.6.0.jar -rw-r--r--. 1 root root 339666 3月 18 2017 datanucleus-api-jdo-3.2.6.jar -rw-r--r--. 1 root root 1890075 3月 18 2017 datanucleus-core-3.2.10.jar -rw-r--r--. 1 root root 1809447 3月 18 2017 datanucleus-rdbms-3.2.9.jar -rw-r--r--. 1 root root 2838580 3月 18 2017 derby-10.10.2.0.jar -rw-r--r--. 1 root root 18482 3月 18 2017 eigenbase-properties-1.1.5.jar -rw-r--r--. 1 root root 12452 3月 18 2017 geronimo-annotation_1.0_spec-1.1.1.jar -rw-r--r--. 1 root root 30548 3月 18 2017 geronimo-jaspic_1.0_spec-1.0.jar -rw-r--r--. 1 root root 16030 3月 18 2017 geronimo-jta_1.1_spec-1.1.1.jar -rw-r--r--. 1 root root 6377448 3月 18 2017 groovy-all-2.1.6.jar -rw-r--r--. 1 root root 2189117 3月 18 2017 guava-14.0.1.jar -rw-r--r--. 1 root root 76643 3月 18 2017 hamcrest-core-1.1.jar -rw-r--r--. 1 root root 121082 4月 3 2017 hive-accumulo-handler-1.2.2.jar -rw-r--r--. 1 root root 47764 4月 3 2017 hive-ant-1.2.2.jar -rw-r--r--. 1 root root 138274 4月 3 2017 hive-beeline-1.2.2.jar -rw-r--r--. 1 root root 38367 4月 3 2017 hive-cli-1.2.2.jar -rw-r--r--. 1 root root 290835 4月 3 2017 hive-common-1.2.2.jar -rw-r--r--. 1 root root 120561 4月 3 2017 hive-contrib-1.2.2.jar -rw-r--r--. 1 root root 20608029 4月 3 2017 hive-exec-1.2.2.jar -rw-r--r--. 1 root root 114730 4月 3 2017 hive-hbase-handler-1.2.2.jar -rw-r--r--. 1 root root 27390 4月 3 2017 hive-hwi-1.2.2.jar -rw-r--r--. 1 root root 100417 4月 3 2017 hive-jdbc-1.2.2.jar -rw-r--r--. 1 root root 15594358 4月 3 2017 hive-jdbc-1.2.2-standalone.jar -rw-r--r--. 1 root root 5470775 4月 3 2017 hive-metastore-1.2.2.jar -rw-r--r--. 1 root root 916566 4月 3 2017 hive-serde-1.2.2.jar -rw-r--r--. 1 root root 1865061 4月 3 2017 hive-service-1.2.2.jar -rw-r--r--. 1 root root 32242 4月 3 2017 hive-shims-0.20S-1.2.2.jar -rw-r--r--. 1 root root 59903 4月 3 2017 hive-shims-0.23-1.2.2.jar -rw-r--r--. 1 root root 8966 4月 3 2017 hive-shims-1.2.2.jar -rw-r--r--. 1 root root 109178 4月 3 2017 hive-shims-common-1.2.2.jar -rw-r--r--. 1 root root 13084 4月 3 2017 hive-shims-scheduler-1.2.2.jar -rw-r--r--. 1 root root 14524 4月 3 2017 hive-testutils-1.2.2.jar -rw-r--r--. 1 root root 719304 3月 18 2017 httpclient-4.4.jar -rw-r--r--. 1 root root 321639 3月 18 2017 httpcore-4.4.jar -rw-r--r--. 1 root root 1282424 3月 18 2017 ivy-2.4.0.jar -rw-r--r--. 1 root root 611863 3月 18 2017 janino-2.7.6.jar -rw-r--r--. 1 root root 60527 3月 18 2017 jcommander-1.32.jar -rw-r--r--. 1 root root 201124 3月 18 2017 jdo-api-3.0.1.jar -rw-r--r--. 1 root root 1681148 3月 18 2017 jetty-all-7.6.0.v20120127.jar -rw-r--r--. 1 root root 1683027 3月 18 2017 jetty-all-server-7.6.0.v20120127.jar -rw-r--r--. 1 root root 213854 3月 18 2017 jline-2.12.jar -rw-r--r--. 1 root root 588001 3月 18 2017 joda-time-2.5.jar -rw-r--r--. 1 root root 12131 3月 18 2017 jpam-1.1.jar -rw-r--r--. 1 root root 45944 3月 18 2017 json-20090211.jar -rw-r--r--. 1 root root 33031 3月 18 2017 jsr305-3.0.0.jar -rw-r--r--. 1 root root 15071 3月 18 2017 jta-1.1.jar -rw-r--r--. 1 root root 245039 3月 18 2017 junit-4.11.jar -rw-r--r--. 1 root root 313686 3月 18 2017 libfb303-0.9.2.jar -rw-r--r--. 1 root root 227712 3月 18 2017 libthrift-0.9.2.jar -rw-r--r--. 1 root root 481535 3月 18 2017 log4j-1.2.16.jar -rw-r--r--. 1 root root 447676 3月 18 2017 mail-1.4.1.jar -rw-r--r--. 1 root root 94421 3月 18 2017 maven-scm-api-1.4.jar -rw-r--r--. 1 root root 40066 3月 18 2017 maven-scm-provider-svn-commons-1.4.jar -rw-r--r--. 1 root root 69858 3月 18 2017 maven-scm-provider-svnexe-1.4.jar -rw-r--r--. 1 root root 1006904 4月 23 09:04 mysql-connector-java-5.1.49.jar -rw-r--r--. 1 root root 1208356 3月 18 2017 netty-3.7.0.Final.jar -rw-r--r--. 1 root root 19827 3月 18 2017 opencsv-2.3.jar -rw-r--r--. 1 root root 65261 3月 18 2017 oro-2.0.8.jar -rw-r--r--. 1 root root 29555 3月 18 2017 paranamer-2.3.jar -rw-r--r--. 1 root root 2796935 3月 18 2017 parquet-hadoop-bundle-1.6.0.jar -rw-r--r--. 1 root root 48557 3月 18 2017 pentaho-aggdesigner-algorithm-5.1.5-jhyde.jar drwxr-xr-x. 6 root root 104 4月 23 15:14 php -rw-r--r--. 1 root root 250546 3月 18 2017 plexus-utils-1.5.6.jar drwxr-xr-x. 10 root root 150 4月 23 15:14 py -rw-r--r--. 1 root root 25429 3月 18 2017 regexp-1.3.jar -rw-r--r--. 1 root root 105112 3月 18 2017 servlet-api-2.5.jar -rw-r--r--. 1 root root 1251514 3月 18 2017 snappy-java-1.0.5.jar -rw-r--r--. 1 root root 236660 3月 18 2017 ST4-4.0.4.jar -rw-r--r--. 1 root root 26514 3月 18 2017 stax-api-1.0.1.jar -rw-r--r--. 1 root root 148627 3月 18 2017 stringtemplate-3.2.1.jar -rw-r--r--. 1 root root 93210 3月 18 2017 super-csv-2.2.0.jar -rw-r--r--. 1 root root 55953 3月 18 2017 tempus-fugit-1.1.jar -rw-r--r--. 1 root root 392124 3月 18 2017 velocity-1.5.jar -rw-r--r--. 1 root root 94672 3月 18 2017 xz-1.0.jar -rw-r--r--. 1 root root 792964 3月 18 2017 zookeeper-3.4.6.jar
- 完成，运行！
# 是在/usr/local/hive/apache-hive-1.2.2-bin/bin 下执行的hive开启 [root@hadoop1 bin]# ./hive Logging initialized using configuration in jar:file:/usr/local/hive/apache-hive-1.2.2-bin/lib/hive-common-1.2.2.jar!/hive-log4j.properties Sat Apr 23 17:43:48 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. Sat Apr 23 17:43:48 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. Sat Apr 23 17:43:48 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. Sat Apr 23 17:43:48 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. Sat Apr 23 17:43:49 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. Sat Apr 23 17:43:49 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. Sat Apr 23 17:43:49 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. Sat Apr 23 17:43:49 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. hive> show databases; OK default Time taken: 0.65 seconds, Fetched: 1 row(s) hive> create database hive_book; OK Time taken: 0.199 seconds hive> show databases; OK default hive_book Time taken: 0.01 seconds, Fetched: 2 row(s) hive>
[root@hadoop1 ~]# cd /usr/local/hive/apache-hive-1.2.2-bin/ # 是在/usr/local/hive/apache-hive-1.2.2-bin/ 下执行的hive开启 [root@hadoop1 apache-hive-1.2.2-bin]# bin/hive Logging initialized using configuration in jar:file:/usr/local/hive/apache-hive-1.2.2-bin/lib/hive-common-1.2.2.jar!/hive-log4j.properties Sat Apr 23 17:44:48 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. Sat Apr 23 17:44:48 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. Sat Apr 23 17:44:48 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. Sat Apr 23 17:44:48 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. Sat Apr 23 17:44:48 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. Sat Apr 23 17:44:48 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. Sat Apr 23 17:44:48 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. Sat Apr 23 17:44:48 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. hive> show databases; OK default hive_book Time taken: 0.63 seconds, Fetched: 2 row(s) hive>
总结说明：
Hive利用MySQL进行存储元数据【MetaStore】
内置函数查询
hive> show functions; OK ! != % & * + - / < <= <=> <> = == > >= ^ abs acos add_months and array array_contains ascii asin assert_true atan avg base64 between bin case cbrt ceil ceiling coalesce collect_list collect_set compute_stats concat concat_ws context_ngrams conv corr cos count covar_pop covar_samp create_union cume_dist current_database current_date current_timestamp current_user date_add date_format date_sub datediff day dayofmonth decode degrees dense_rank div e elt encode ewah_bitmap ewah_bitmap_and ewah_bitmap_empty ewah_bitmap_or exp explode factorial field find_in_set first_value floor format_number from_unixtime from_utc_timestamp get_json_object greatest hash hex histogram_numeric hour if in in_file index initcap inline instr isnotnull isnull java_method json_tuple lag last_day last_value lcase lead least length levenshtein like ln locate log log10 log2 lower lpad ltrim map map_keys map_values matchpath max min minute month months_between named_struct negative next_day ngrams noop noopstreaming noopwithmap noopwithmapstreaming not ntile nvl or parse_url parse_url_tuple percent_rank percentile percentile_approx pi pmod posexplode positive pow power printf radians rand rank reflect reflect2 regexp regexp_extract regexp_replace repeat reverse rlike round row_number rpad rtrim second sentences shiftleft shiftright shiftrightunsigned sign sin size sort_array soundex space split sqrt stack std stddev stddev_pop stddev_samp str_to_map struct substr substring sum tan to_date to_unix_timestamp to_utc_timestamp translate trim trunc ucase unbase64 unhex unix_timestamp upper var_pop var_samp variance weekofyear when windowingtablefunction xpath xpath_boolean xpath_double xpath_float xpath_int xpath_long xpath_number xpath_short xpath_string year | ~ Time taken: 0.018 seconds, Fetched: 216 row(s)
