HIVE创建表sematicException 0:0 [英] HIVE CREATE TABLE sematicException 0:0

问题描述

大家好:
我是蜂巢的新手，使用"select from"语法创建表时出现此错误，
我的输入如下:

all :
i am newbie at hive, i got this error when i was creating a table using "select from " syntax,
my input is as following:

`hive>create table longyuan_web.tmp_recent_week_data_cookies as 
 select u from longyuan_web.ods_mbw_user_pv where dt>='2018-07-19' 
 and dt<='2018-07-25'and  platform='31' 
 and u is not null and length(u)>=32
 and os='ios' group by u`

我收到此错误:
FAILED: SemanticException 0:0 Error creating temporary folder on: hdfs://hadoop-bd-ns01/hive/warehouse/longyuan_web.db. Error encountered near token 'TOK_TMP_FILE'

我非常确定我在正确的集群上，并且原始表也在此集群上
这是什么"TOK_TMP_FILE"?
非常感谢！

i am pretty sure i am on the right cluster and the original table is also on this cluster
what this 'TOK_TMP_FILE'?
thank you so much!!

推荐答案

是的.

(我想您的选择查询可以独立运行)

(I assume Your select query runs good as stand-alone)

您在longyuan_web db中具有读取权限.但是没有写权限.

You have read access in longyuan_web db. But not write access.

解决方法是... 尝试在其他具有写入权限的数据库中创建表，例如....

Work around is... Try to create the table in some other db where you have write access, like....

 `hive>create table **xxx_web**.tmp_recent_week_data_cookies as select u from longyuan_web.ods_mbw_user_pv where dt>='2018-07-19' and dt<='2018-07-25'and platform='31' and u is not null and length(u)>=32 and os='ios' group by u` as select u from longyuan_web.ods_mbw_user_pv where dt>='2018-07-19' and dt<='2018-07-25'and platform='31' and u is not null and length(u)>=32 and os='ios' group by u`

其中xxx_web是您具有写访问权的Db.

Where xxx_web is the Db where you have write access.

这篇关于HIVE创建表sematicException 0:0的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！