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, 肖辉 <[email protected]> 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. > > >
