You can translate the question and the replies:

When use import.sh to run vql, where is the vql output file?

We have linux machine with denodo client installed, we use import.sh to run some vql file like below: $DENODO_HOME/bin/import.sh -f ${vqlFile} -h "${databaseURI}?${uid}@${passwords}&queryTimeout=9" > ${tempFile} 2>&1 The vqlFile we run has some return result, can you let me know where to get result file? we need that result to do some succeeding tasks.
user
10-05-2020 04:25:15 -0400

5 Answers

Hi, I would refer to the value of the linux environment variable ${tempFile} to check the location of the file. Alternatively, for testing purposes, I would redirect the output to any file in the current location from where the import.sh script is executed and then would refer to that file for the output of the script. Hope this helps!
Denodo Team
11-05-2020 04:46:28 -0400
my vql is a seltect query, and it will has some data result returned. I checked my ${tempFile}, which just contained the log file about execution process, no slect result returned in it. Are you sure the data return result will be shown on the ${tempFile}?
user
 Edited on: 08-09-2020 01:28:06 -0400
my command is: $DENODO_HOME/bin/import.sh -f ${vqlFile} -h "${databaseURI}?${user}@${password}&queryTimeout=90" > 1.log 2>&1 ${vqlFile} is test.vql, just include below (view_a has 20 columns, and 20000+ items of data): select * from view_a limit 10 output file 1.log, after it run, content in 1.log: Parsing file 'test.vql' Servers list: //sdc12345.company.com:9999/fin?user1 Begin batch execution Number of jobs: 1 Command #1: select * from view_a limit 10 --------------------------------------------------------------------- [JobStatistics [//sdc12345.company.com:9999/fin?user1] #Runs: 1/1 #Errors: 0 #Warnings: 0] --------------------------------------------------------------------- That means, the out file just contains the running log of vql, but not include the retrun result of vql. Can you let me know how we get the return result of that vql?
user
 Edited on: 08-09-2020 01:28:06 -0400
Any update, I am in so hurry about this case.
user
 Edited on: 08-09-2020 01:28:06 -0400
Hi, If you want to get the return result of vql in a file accesible in your system, you can make use of Denodo's Scheduler to configure a job and export the results to a delimited file. You can refer to a similar [Q&A](https://community.denodo.com/answers/question/details?questionId=9060g0000000AHoAAM&title=How+to+find+the+output+after+executing+import.sh) for steps on how to achieve this using Scheduler. You can also refer to the [Scheduler Administration Guide](https://community.denodo.com/docs/html/browse/7.0/scheduler/administration/index) to get the details of how to configure a job in a Scheduler. Hope this helps!
Denodo Team
24-05-2020 23:24:14 -0400
You must sign in to add an answer. If you do not have an account, you can register here