Hi, I've been trying to figure out how to run a series of commands/queries from a file, and I have not had any luck finding the right way to specify the file path. I'm running embedded on Windows.
I've tried both the "!run" command from within the Drill shell, and the sqllline method of specifying a file to run with the "-run" option. In all cases, no matter how I specify the file path, I get "file not found" errors. What is expected for a file path? What it is relative to, or how do you specify the absolute path? To make the question specific, suppose I have a directory c:\tmp\queries which contains my query.sql file that I'd like to run. >From the Drill shell command line, I want to execute the "!run" command and >supply the path to this query.sql file. How should this argument be formatted? Alternatively, if I want to start up Drill, execute the query.sql file, and then exit by using the sqlline method (./sqlline -u 'jdbc:drill:drillbit=local' -run=/path/to/file), how exactly should that look in order to execute my query.sql file? I've tried every variation of paths I can think of and nothing works. Thanks for your help, -Kendra
