This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a workflow where I need to read a Hive Table as a lookup and output some results into another Hive table (both already exists).
I don't have issue in the reading (using Input Tool) a Hive Table.
But when it comes to load my result into Hive (using Output Tool), I got a Connection Refused issue.
"Error: Output Data (29): DataWrap2ODBC::SendBatch: [MapR][Hardy] (35) Error from server: error code: '1' error message: 'Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask. Call From node1/<ip> to node1:<port> failed on connection exception: java.net.ConnectException: Connection refused; For more details see: http://wiki.apache.org/hadoop/ConnectionRefused'."
May I ask if what may caused this connection refused issue, which I did not encounter during the reading (Input Tool) a Hive Table?
Do you get the same error if you write to a Hive table with out inputting data from Hive? I would recommend adding a block until done tool before you output to the Hive table so that all of the data is input into Alteryx before trying to push data back into Hive.