Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

hive export table semantic exception

avatar

Hi.

We want to export hive table using the export table command (export table table_name to 'hdfs_path';) in Beeline, Hue, or hive CLI but we get an error (in dev cluster):

Error: Error while compiling statement: FAILED: SemanticException Error when getting current notification event ID (state=42000,code=40000)

The table doesn't have partitions.

In the yarn top command, I see that job starts for this task but it is killed automatically after a few seconds.

DEV cluster:

HDP-3.1.4.0

Hive 3.1.0

 

In our other cluster (production), this problem does not exist.

 

1 REPLY 1

avatar
Expert Contributor

Please share the complete error stack-trace. 

With respect to The table doesn't have partitions.

Make sure HDFS and metadata in sync.