Error: Error while compiling statement: FAILED: SemanticException Line 1:27 Table or database name may not contain dot(.) character 'dw_test.ods_user_user_douyin' (state=42000,code=40000)

ximengyun commented 3 years ago

For better global communication, please give priority to using English description, thx!

Please review https://dolphinscheduler.apache.org/en-us/docs/development/issue.html when describe an issue.

Describe the question A clear and concise description of what the question is. 海豚调度使用sqoop导数据到hive3，因为hive3不支持'库名.表名',character 'dw_test.ods_user_user_douyin'，导致报错，建议生成sqoop脚本的时候，把库名和表明分开

Which version of DolphinScheduler: DolphinScheduler 1.3.2

xingchun-chen commented 3 years ago

who can fix it?

Eights-Li commented 3 years ago

In Hive3， hive-client has been removed. sqoop import hive use beeline. you can use hcatalog param to deal with it. But hcatalog not support all sqoop import param, you can find in this: http://sqoop.apache.org/docs/1.4.7/SqoopUserGuide.html#_unsupported_sqoop_hive_import_options

apache / dolphinscheduler

Error: Error while compiling statement: FAILED: SemanticException Line 1:27 Table or database name may not contain dot(.) character 'dw_test.ods_user_user_douyin' (state=42000,code=40000) #4019