Support Questions

Find answers, ask questions, and share your expertise

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
Master Collaborator

Please share the complete error stack-trace. 

With respect to The table doesn't have partitions.

Make sure HDFS and metadata in sync.