Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.

Error in Inserting Data into Hive table using Output tool, but Hive input is successful

Highlighted
Alteryx Partner

Good day,

 

 

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?

 

Thank 

Highlighted
Alteryx
Alteryx

HI @Reijay

 

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.

Jake Samuels

Technical Product Manager
Alteryx, Inc.
Labels