hive-bug:create db.tablename as select .....
来源:互联网 发布:云盘 php源码 编辑:程序博客网 时间:2024/06/11 16:10
hive1.1版本执行create tmp.tablename as select .....语句的时候报以下错误:
FAILED: SemanticException 0:0 Error creating temporary folder on: hdfs://***/user/hive/warehouse. Error encountered near token 'TOK_TMP_FILE'
查看 hive jira,有以下问题:
https://issues.apache.org/jira/browse/HIVE-11427
可以看出创建表tmp.tablename的时候当做是default库下的表了,而default库下该用户没有哪个权限出现的问题,临时解决办法如下:
use tmp;
create tablename as select ......,表示先选择相应权限的库再执行create语句;
阅读全文
1 0
- hive-bug:create db.tablename as select .....
- hive orc创建出错create as select
- Create table as select
- create table as select
- Hive SQL 语义分析:select count(*) from tableName
- SELECT INTO 与 Create as
- oracle create table as select
- Oracle Create Table as Select
- 浅谈create table as select
- hive基本的操作语句(实例简单易懂,create table XX as select XX)
- JDBC DB TableName
- show create table ‘tablename’
- MySql create table ... as select * from ..
- Select into from 与 Create Table As
- create table as select性能测试
- sqlserver不能直接create table as select ......
- sqlserver不能直接create table as select ......
- create table as select性能测试
- 201301 JAVA题目0-1级
- IntelliJ IDEA设置自动导入包
- VS2013安装卡住问题
- 实用webpack入门教程
- (一)基础之修改表、字段
- hive-bug:create db.tablename as select .....
- 烟大OJ.求某个范围内的所有素数
- CNTK API文档翻译(2)——逻辑回归
- HTTP协议中POST、GET、HEAD、PUT等请求方法以及一些常见错误
- 理解LIBSVM: A Library for Support Vector Machines
- 浅析Spring 的aop实现原理
- (二)MySql基础之约束
- Vivante GPU简介
- 【LeetCode】38.Combination Sum