Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask.

[ergouy]

Commands in scripts:
runcommand "$HIVE -f ddl-tpcds/bin_partitioned/add_constraints.sql --hivevar DB=${DATABASE}"

Error description：
ERROR : FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. InvalidObjectException(message:Parent table not found: customer_address)
Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. InvalidObjectException(message:Parent table not found: customer_address) (state=08S01,code=1)

But I see that the tables in the database exist!

Has anyone ever encountered this problem？

[ExplorerXP]

You can try the following steps：1. Don't use beeline. Edit tpcds-set.sh and define Hive="hive"；2. edit ddl-tpcds/bin_partitioned/add_constraints.sql，and add ‘use ${DB};’ as first line.