Importing from Apache Hadoop Hive DDL, getting error :FATAL [MBCM_F0029] Input model is null
说明
Importing from Apache Hadoop Hive DDL, getting error :FATAL [MBCM_F0029] Input model is null
解决办法
I am using the bridge to import Apache Hadoop HiveQL DDL as SQL DDL and I amgetting the error:
ERROR:Could not find required directory: directory path FATAL:[MBCM_F0029] Input model is null
Please make sure
follow the instruction to generate the DDL (HQL) use the utility provided at '${MODEL_BRIDGE_HOME}/bin/hive_generate_ddl.sh'. Place this utility on the hive cluster (should not matter where). Once there, remotely connect with a bash shell and execute the utility. It will extract the DDL from all the schemas in the cluster into a file name 'tables.hql'.
In the Import Wizard, make sure the file path point to a directory (NOT the file). The directory should only contains tables.hql file
use the utility provided at '${MODEL_BRIDGE_HOME}/bin/hive_generate_ddl.sh'. Place this utility on the hive cluster (should not matter where). Once there, remotely connect with a bash shell and execute the utility. It will extract the DDL from all the schemas in the cluster into a file name 'tables.hql'.