DB Loader stops working with Hive in 4.3.0
It was working in 4.2.x
Now it shows below error:
ERROR DB Loader 0:7 Execute failed: Error while compiling statement: FAILED: SemanticException Line 1:17 Invalid path ‘’/temp/knime2db69a3a51f85334e75.parquet’’: No files matching path file:/temp/knime2db69a3a51f85334e75.parquet
can you maybe upload the workflow you are using here as well?
can you please give some more detail about the big data environment you are using e.g. Hortonworks, Cloudera or a cloud environment and also the Hive version and HDFS protocol.
The Hive environment is setup using BDE docker images.
The workflow has been attached.
the repository looks very outdated and is no longer actively maintained (last update 2018). I did not get the metastore up and running with the docker-compose-hive file from the repository until switching the version of the hive images to 2.3.2. After that everything seems to work and I can’t reproduce your problem.
Make sure the
/temp directory exists or the create missing folder option is enabled in the DB Loader. If this does not help, try to enable the debug log level in the Preferences > KNIME > KNIME GUI.
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.