Hi Tobias, thanks for your support! Yes, we tried that select table button right in the begining: I can select the table in the hive metastore, no problem.
Debug level is set: The qhive_load_example.knwf (37.4 KB) uery is executable in hive!
I copy some of the new debug entries here and also upload the critical part of the workflow, maybe one or more precursor nodes are neccessary prior to the db loader?
What about datatypes: We´ve got one date which is defined as double, in the table it is currently ‘int’ since we just tried everything. Could this lead to ‘table does not exist’?
DEBUG ResetAction Resetting 1 node(s)
DEBUG Column Filter 0:969 reset
DEBUG Column Filter 0:969 clean output ports.
DEBUG WorkflowDataRepository Removing handler 466cea11-a5d0-4cf8-b673-7bcc43247b01 (Column Filter 0:969: ) - 15 remaining
DEBUG NodeContainer Column Filter 0:969 has new state: IDLE
DEBUG Column Filter 0:969 Configure succeeded. (Column Filter)
DEBUG NodeContainer Column Filter 0:969 has new state: CONFIGURED
DEBUG DB Loader 0:3983 Acquiring connection.
INFO DB Loader 0:3983 12. The connection has been opened (borrowed): URL=“jdbc:hive2://fe01.bdmp2.telekom.de:10000/db_a02_bbe_iws_pwr;ssl=1”, user=“hestoelt”
INFO DB Loader 0:3983 12. Statement.executeQuery(sql=): SELECT 0 FROM db_a02_bbe_iws_pwr.cl_tmagic_log_runtime_mt WHERE 1 = 0 ;
DEBUG TimeoutExecutionMonitor$TimeoutNodeProgressMonitor Node configuration was aborted after 3 seconds. To change the timeout parameter ‘Retrieve in configure timeout’ go to the ‘Advanced’ tab of the database connector node.
DEBUG JdbcCanceler$StatementCanceler Canceling the executing statement.
DEBUG JdbcCanceler$StatementCanceler The executing statement has been canceled.
INFO DB Loader 0:3983 12. The connection has been closed (relinquished).
DEBUG DB Loader 0:3983 All the statements have already been closed.
DEBUG DB Loader 0:3983 The connection has been relinquished.
DEBUG DB Loader 0:3983 The managed connection has been closed.
DEBUG DB Loader 0:3983 The transaction managing connection has been closed.
WARN DB Loader 0:3983 Table db_a02_bbe_iws_pwr.cl_tmagic_log_runtime_mt does not exist
DEBUG MemoryAlertSystem Tenured gen heap space usage below threshold (84%) after GC, currently 22% (0.45GB/2.00GB)
DEBUG MemoryAlertSystem Tenured gen heap space usage below threshold (64%) after GC, currently 22% (0.45GB/2.00GB)
DEBUG NodeContainerEditPart Column Filter 0:969 (CONFIGURED)
DEBUG NodeContainerEditPart DB Loader 0:3983 (IDLE)