Ask Your Question
1

HIVE_METADATA_03 - Failed validation on table name : Invalid character for Hive.

asked 2019-09-27 17:55:29 -0500

Goth gravatar image

updated 2019-09-27 18:09:27 -0500

metadaddy gravatar image

Hello ,

When we are migrating data from SQL server to HDFS , I get this exception -

"com.streamsets.pipeline.stage.lib.hive.exceptions.HiveStageCheckedException: HIVE_METADATA_03 - Failed validation on table name : Invalid character for Hive 'zzz01414328-userright_target'"

Any thoughts ? Table name in source zzz01414328-UserRight

Thanks.

edit retag flag offensive close merge delete

Comments

1 Answer

Sort by ยป oldest newest most voted
0

answered 2019-09-29 15:54:03 -0500

metadaddy gravatar image

Only alphanumeric and underscore characters are allowed in Hive table names. You will need to remove the hyphen, or replace it with an underscore. You can do either of these with the Expression Evaluator, acting on the jdbc.tables record header attribute.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-09-27 17:55:29 -0500

Seen: 161 times

Last updated: Sep 29