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.
When you use tHiveRow or t<DB>Row, you'd better create job as follows.
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.