TEE FILE

[chenziliang]

Use case

As proton client user, I would like my query result to be able to dump a file in interactive Proton console but still keep the interactive console printing its own output. I would like the file to be on client side and I can specify the location of the file if necessary. By default, if a file is not having absolute path, dump it to home directory.

Describe the solution you'd like

Case 1: my_file will be located in $HOME directory.

SELET * FROM my_stream TEE my_file;

Case 2: my_file will be located in /tmp directory.

SELET * FROM my_stream TEE /tmp/my_file;

Describe alternatives you've considered

Additional context

[chenziliang]

If the file is too big eventually, we may need split it into multiple parts like my_file.1, my_file.2, but it is nice to have for now.