Four Stars 122
Four Stars

Return results from HIVE query (not select statements)

Hello,

 

I'm using the tHiveRow component to execute a simple HIVE query to show the list of tables within a HIVE database. How would I return the query result that I would normally be able to see in the HIVE CLI so I can use it with other component.

 

Thanks

  • Big Data
1 REPLY
Moderator

Re: Return results from HIVE query (not select statements)

Hello,

When you use tHiveRow or t<DB>Row, you'd better create job as follows.

tHiveRow-->tParseRecordSet-->tLogRow

Add a column in tHiveRow and select "Object" data type.
Check Advanced settings-> "Propagate QUERY's recordset" and select the object column.
Retrieve state and name in tParseRecordSet(Set "state" and "name" in Value).

Let us know if it works for you.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.