Try doing sqlline -? to get the help. I didn't see anything for reading from a piped stdin, but you can read from and write to a file:
-f <file> script file to execute (same as --run) -log <file> file to write output - Paul On Tue, May 19, 2020 at 8:15 AM Charles Givre <cgi...@gmail.com> wrote: > Hi there, > You might first want to take a look at the docs for sqlline: > http://sqlline.sourceforge.net/#introduction < > http://sqlline.sourceforge.net/#introduction> > I don't really think it is meant to be used in that manner. I'd suggest > writing a simple python script using PyDrill that accepts a query as input > and outputs the result in the format that you need. > Best, > -- C > > > > On May 19, 2020, at 3:39 AM, 肖辉 <xiaohui1295371...@163.com> wrote: > > > > Hi, when i use drill, i can inquire successfully in the drill shell. > However, now i want to inquire data in the format of the script, it failed. > > when i transfer command to dirll through the pipe, it failed and quit > immediately like the following picture: > > > > my script is a simple sentence like > > > > but when i remove the pipe, it can access into drill successfully. How > can i use script to inquire and export data successfully in drill? Thanks > and waiting for your advice sincerely. > > > > > > > >