1，hive连接的MySQL中创建一个普通用户，并且授权

	CREATE USER 'spark'@'%' IDENTIFIED BY '123456'; GRANT ALL PRIVILEGES ON hivedb.* TO 'spark'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;FLUSH PRIVILEGES;

2，spark安装目录conf下添加hive-site.xml

配置MySQL表空间，配置第一步创建的用户名和密码

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<!--Licensed to the Apache Software Foundation (ASF) under one or morecontributor license agreements.  See the NOTICE file distributed withthis work for additional information regarding copyright ownership.The ASF licenses this file to You under the Apache License, Version 2.0(the "License"); you may not use this file except in compliance withthe License.  You may obtain a copy of the License athttp://www.apache.org/licenses/LICENSE-2.0Unless required by applicable 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 language governing permissions andlimitations under the License.
-->
<configuration><property><name>javax.jdo.option.ConnectionURL</name><value>jdbc:mysql://linux01:3306/hivedb?createDatabaseIfNotExist=true</value><description>JDBC connect string for a JDBC 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>spark</value><description>username to use against metastore database</description></property><property><name>javax.jdo.option.ConnectionPassword</name><value>123456</value><description>password to use against metastore database</description></property><property><name>hive.metastore.schema.verification</name><value>false</value></property><property><name>datanucleus.schema.autoCreateAll</name><value>true</value></property></configuration>

3，启动SparkSQL

./bin/spark-sql --master spark://linux01:7077 --driver-class-path /opt/app/apache-hive-2.3.1/lib/mysql-connector-java-5.1.39.jar

其中需要指定mysql驱动包，此处使用hive安装目录下的驱动包，或者也可以将安装包放入spark的lib目录下

启动成功

4，修改mysql中dbs指定的物理地址

修改后重启，会发现在HDFS上新建了目录

5，beeline模式连接sparkSQL

启动beelline服务端

./sbin/start-thriftserver.sh --master spark://linux01:7077 --executor-memory 1g --total-executor-cores 8 --driver-class-path /opt/app/apache-hive-2.3.1/lib/mysql-connector-java-5.1.39.jar

客户端连接：

./bin/beeline -u jdbc:hive2://linux01:10000

常用参数：

bin/spark-sql \
--master yarn \
--deploy-mode client \
--driver-memory 1g \
--executor-memory 512m \
--num-executors 3 \
--executor-cores 1 \
--driver-class-path /root/mysql-connector-java-5.1.47.jar