GBase8a数据库--GBaseUP Hive外部表访问hdfs错误

表现：

gbase> insert into t1_hive select * from t1_8a;

ERROR 1708 (HY000): ::ffff:192.168.154.180:5050Failed to query in gnode:

DETAIL: (GBA-01EX-700) Gbase general error: I/O operation on HDP://[e-mail]:8020/tmp/gbase8up/test_t1_hive_0_141732_3_3_2b3970ac-33b0-43aa-a1be-2a3d18163c9a/test_t1_hive_0_141732_3_3_2b3970ac-33b0-43aa-a1be-2a3d18163c9a_3?token=KAAPZ2Jhc2VAR0hELkdCQVNFBWdiYXNlAIoBZ_LYieuKAWgW5Q3rOi4UBnB3c8SKOeB5nPzGXpPmk0iwPnAVSERGU19ERUxFR0FUSU9OX1RPS0VOGmI2LW5vZGUyLTE3NS5nYmFzZS5jbjo4MDIw failed with error - AccessControlException: F

Trc里面显示：2018-12-28 14:37:16.228 [140100498618112] ExecSQLOnEngineJob::Execute - failed: Error while processing statement: FAILED: Execution Error, return code 3 from org.apache.hadoop.hive.ql.exec.spark.SparkTask. org.apache.hadoop.ipc.RemoteException(java.io.IOException): Delegation Token can be issued only with kerberos or web authentication

登录hive查看

beeline -u "jdbc:hive2://b6-node3-176.gbase.cn:10000/default;principal=hive/[e-mail];keytab=/etc/security/keytabs/hive.service.keytab" -n hive

0: jdbc:hive2://b6-node3-176.gbase.cn:10000/d> set spark.submit.deployMode;

| set |

| spark.submit.deployMode=cluster |

解决方法：

需要将spark的deploymode改成client模式

在ambari页面->HIVE + SPARK->ADVANCED->HIVE 自定义 hive-site里增加属性，增加完参数后重启hive服务。