You can translate the question and the replies:

import.sh run vql, which vql contained parameter, how to make it?

We have linux machine with denodo client installed, we use import.sh to run some vql file, I have a question, if my vql file wants to have a parameter such as where filters contain some parameter, can import.sh run that vql with parameter contained in my vql file? Thanks. eg. below works well for my vql contains no parameter $DENODO_HOME/bin/import.sh -f ${vqlFile} -h “${databaseURI}?${uid}@${passwords}&queryTimeout=9” now, if my ${vqlFile} has a parameter about date range, how to run above command on linux server.
import.sh vql vql parameter
user
15-05-2020 07:02:10 -0400
code

3 Answers

Hi, The import.sh script is used to import metadata into the Virtual DataPort Server. It accepts parameters for server names, file names, single user mode, and credentials. It does not have an option for specifying a date range. More information about the [Import script](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/cluster_architectures_server_backup/using_the_import_export_scripts_for_backup_and_or_replication/import_script#import-script) can be seen in the Virtual DataPort Server Administration Guide. Hope this helps!
Denodo Team
18-05-2020 18:06:24 -0400
code
Can I understand, not only date range, should be all parameters contained in vql query, import.sh script is not supported to execute it? for example my vql query is: select col_A, col_b from view_a where location = $loc_a and name = $name, it can also not exexcute by below kind of command: $DENODO_HOME/bin/import.sh -f ${vqlFile} -h “${databaseURI}?${uid}@${passwords}&queryTimeout=9”
user
 Edited on: 08-09-2020 01:28:06 -0400
Hi, The import.sh script is used to import metadata. If you are specifying a WHERE clause in your view definition, you will be able to import the VQL with a date range WHERE clause, using the import.sh script. So the filter will need to be defined within the view itself. WHERE clause parameters such as a date range cannot be passed into the import.sh script. Hope this helps.
Denodo Team
26-05-2020 17:41:43 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here