插入覆盖：由于垃圾包含垃圾，因此无法将其移至垃圾箱 [英] Insert Overwrite: Cannot move ... to the trash, as it contains the trash

问题描述

  INSERT OVERWRITE TABLE testtable1 select * from testtable0 $ b我试图通过从另一个表中插入来插入表： $ b  

错误：

 将数据移动到：wasb：// {container} @ {storage} .blob.core.windows.net / hive / scratch / hive_2015-06-01_15-05-14_062_6478651325775395196-1 / -ext-10000 
将数据加载到表格default.testtable1 
 rmr：DEPRECATED：请使用'rm -r'代替。 
 rmr：无法将wasb：// {container} @ {storage} .blob.core.windows.net /移动到垃圾箱中，因为它包含垃圾。考虑使用-skipTrash选项
失败，出现异常null 
  

-r建议和 - skipTrash选项添加到蜂巢查询？该语法应该是什么，或者是否有更好的方法来做这个查询？ 解决方案

你能分享你指向的位置吗到何时创建testtable1？

您的测试表似乎指向WASB存储帐户中的根容器。 Hive在文件夹级别而不是文件级别上工作。由于您未提供要存储的表数据的子目录，因此它会尝试删除容器中包含垃圾文件夹的全部数据。

只需在创建测试表时添加一个子文件夹，即可解决问题。

I am attempting to insert into a table by selecting from another:

INSERT OVERWRITE TABLE testtable1 select * from testtable0

The error:

Moving data to: wasb://{container}@{storage}.blob.core.windows.net/hive/scratch/hive_2015-06-01_15-05-14_062_6478651325775395196-1/-ext-10000
Loading data to table default.testtable1
rmr: DEPRECATED: Please use 'rm -r' instead.
rmr: Cannot move "wasb://{container}@{storage}.blob.core.windows.net/" to the trash, as it contains the trash. Consider using -skipTrash option
Failed with exception null

Is the -r suggestion and the -skipTrash option to be added to the hive query? What should the syntax be, or is there a better way to do this query?

解决方案

Can you share the location you are pointing to when you create testtable1?

It seems like your testtable is pointing to the root container in your WASB storage account. Hive works on a folder level and not a file level. Since you do not provide a sub-directory for the table data to be stored in, it tries to delete the entire data in your container which contains the trash folder.

Simply add a sub-folder when you are creating your testtable and that should fix the problem.

这篇关于插入覆盖：由于垃圾包含垃圾，因此无法将其移至垃圾箱的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！