Apache Hive--安装部署-mysql 版安装| 学习笔记

开发者学堂课程【大数据 Hive 教程精讲Apache Hive--安装部署-mysql 版安装】学习笔记,与课程紧密联系,让用户快速学习知识。

课程地址https://developer.aliyun.com/learning/course/90/detail/1364


Apache Hive--安装部署-mysql 版安装

 

内容介绍:

Hive 安装部署

一、Hive 安装部署

 Mysql的安装方式:

Apache Hive--安装部署-mysql 版安装| 学习笔记

Yuma 安装 mysql:

yum install mysql mysql-server mysql-devel

完成后,用/etc/init.d/mysqld start启动 mysql

启动 mysql 控制台:

mysql

mysql>; USE mysql;

mysql>;UPDATE user SET Password=PASSWORD ( 'newpassword') WHERE user='root' ;mysql>; FLUSH PRIVILEGES;

允许远程登录

mysql -u root -p

Enter Password:

mysql>GCRANT ALI PRIVILEGES ON*.* TO '用户名'@'云’IDENTIFIED BY'密码’WITH GRANT OPTION;

完成后就能远程管理 mysql 了。

mysql服务名字service mysqld start

GRANT ALT PRIVILEGES ON *.* To 'root'@ '​​号’工DENTIFIED BY'密码’WITH GRANT OPTION;

Node-1

updating for dependencies :

e2fsprogs       x86_64   1.41.12-23.el6     base     554 k

e2fsprogs-7ibs   x86_64   1.41.12-23.ei6    base     121 k

krb5-7ibs        x86_64    1.10.3-65.e16     base    675 k

krb5-workstation  x86_64 1.10.3-65.ei6     base      814 k

7ibcom_err     x86_64   1.41.12-23.e16     base       38 k

7ibselinux    x86_64     2.0.94-7.e16       base

109 k

7ibse7inux-uti1s   x86_64 2.0.94-7.ei6     base       82 k

1ibss        x86_64    1.4i.12-23.e16      base       42 k

mysq1-7ibs   x86_64    5.1.73-8.e16_8     base       1.2 M

openss1    x86_64     1.0.1e-57.ei6      base       1.5 M

Transaction summary

Instaii       12 Package(s)

Upgrade     10Package(s)

Tota7 down 1oad size: 17M

Is this ok [y/N]: y

Licensed to the Apache software Foundation (ASF) under oneor more contributor 1icense _agreements. see the NOTICE filedistributed with this work for additional information

regarding copyright ownership. The ASF 1icenses this fileto you under the Apache License​​,Version 2.0 (the

"License"); you may not use this file except in compliancewith the License. "You may obtain a copy of

the License at

http : //www.apache.org/licenses/LICENSE-2.0

Un1ess required by app1icab1e law or agreed to in writing​​,softwaredistributed under the License is distributed on an "AS IS" BASIS,

WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND​​,either express or implied.see the License for the specific 1anguage governing permissions and

7imitations under the License.

set Hive and Hadoop environment variables here.These variab1es can be usedto contro1 the execution of Hive. It should be used by admins to configurehive-env.sh" 54L​​,2378c

<configuration>

<property>

<name>javax.jdo.option. ConnectionURL</name>

<value>jdbc:mysal://localhost:3306/hivg2createDatabaseIfNotExist=true</value><description>JDBC connect string for aDBc metastore</description>

</property>

<property>

<name>javax.jdo.option.ConnectionDriverName</ name><value>com.mysql.jdbc.Driver</value>

<description>Driver class name for a JDBc metastore</description></property>

<property>

<name>javax.jdo.option.ConnectionUserName</ name><value>root</value>

<description>username to use against metastore database</description></property>

<property>

<name>javax.jdo.option.connectionPassword</ name><value>root</value>

<description>password to use against metastore database</description></property>

</ configuration>

at org.apache.hadoop.hive.c1i.c1iDriver.executeDriver(C11Driver.java:736)at org.apache.hadoop.hive.c1i.cliDriver.run(c1iDriver.java:681)

at org.apache.hadoop.hive.c1i.cliDriver.main(cliDriver.java:6

21)at sun.ref1ect.NativeMethodAccessorImp1.invokeo(Native Method)

at sun.reflect.NativeMethodAccessorImp1.invoke(NativeMethodAccessorImp1.ja

at sun.reflect.DelegatingMethodAccessorImp1.invoke(DelegatingMethodAccesso

r​​工mp1.java:43)

at java.1ang.ref1ect.Method.invoke(Method.java:497)at org.apache.hadoop.uti1.RunJar.run (RunJar.java:221)at org.apache.hadoop.uti7.RunJar.main(Runar.java:136)

FAILED:ParseException line 1:5 cannot recognize input near 'show' 'itcast​​’'<EOF>' in ddTstatement

hive> show databases ;oK

defau1titcast

ime taken: 0.286 seconds ,Fetched: 2 row(s)hive>

上一篇:Apache Hive--join 操作| 学习笔记


下一篇:GroupingComparator 分组(辅助排序)| 学习笔记