Support Questions

Find answers, ask questions, and share your expertise

hive export table semantic exception


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:


Hive 3.1.0


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


Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.