Error creating hive table: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException

Question

I have a multi node hadoop cluster and now I installed hive on the namenode.

Im trying to create some hive tables from files stored in hdfs but Im getting this strange error:

 FAILED: Execution Error, return code 1 from     
org.apache.hadoop.hive.ql.exec.DDLTask. 
MetaException(message:hdfs://namenode-VirtualBox:9000/data/posts
/posts.tbl is not a directory or unable to create one)
    hive>

But, then I tried to create a table from a file stored in hdfs with only 2kb and the table was created with success.

But when I try to create a table from a file stored in hdfs larger like 200mb, and maybe less, I got that error.

Do you know why this error can be happening?

Community · Accepted Answer · 2017-05-23 12:07:43Z

2

I believe somwhere in the code the url: hdfs://namenode-VirtualBox:9000/data/posts /posts.tbl is parsed and the url should not have the file suffix (.tbl) should just be ".../posts"

I refer you to: Unable to Create Table in HIVE reading a CSV from HDFS

edited May 23, 2017 at 12:07

CommunityBot

11 silver badge

answered May 1, 2016 at 22:12

Luís Pedro Gonçalves

1412 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

codin Over a year ago

Thank you. Your solution fix the issue. Its just strange because for tables with small size works with ".tbl".

Collectives™ on Stack Overflow

Error creating hive table: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related