How to view Tidal Job output in a query?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-18-2014 03:50 PM
I am using a query to extract the standard output of a job:
select jobrun_id, dbms_lob.substr( jobrun_output, 4000, 1 )
from tidal.joboutput
where jobrun_id = 686361;
The query returns output in an XML format:
<TESXOUTPUT><MSG>Job output data is in XML format. To view job output upgrade your Client to latest version.</MSG><OUTPUT COMP="Y" RUN="1">eJzFVltv2zYUftevOBhQpB1CxXZuDQMXkC9...
How can I translate this output into readable text?
Thanks.
- Labels:
-
Application Networking
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-28-2014 02:22 AM
I was running the REST api command to get the job output and received the same result as you. I found a method in the documentation that allows you to get the output in readable form.
Here it is:
JobOutput.getOutputContent/id
where id is the job run id
Hope that helps :)
