On Tue, Mar 17, 2020 at 8:22 PM Larry Ploetz <lplo...@gmail.com> wrote:
> Well, I tried some things with CSV and got different errors:
>
> larryp-MBP:parallel larry$ printf '%s %s\n' {a..d} | gtee >(cat >&2) |
> src/parallel -C' ' --sqla csv:///%2ftmp%2ffoo.csv/bar echo /{1}/{2}/
> a b
> c d
> parallel: Error:
> Execution ERROR: Cannot open /Users/larry/git/parallel/bar: No such file or
> directory (2) at
> /opt/local/lib/perl5/site_perl/5.30/darwin-thread-multi-2level/DBI/DBD/SqlEngine.pm
> line 1624.
> called from src/parallel at 12446.
I can reproduce your error when using the unsupported `--sqla`. But it
is not a supported option. This works for me:
printf '%s %s\n' {a..d} | tee >(cat >&2) | parallel -C' '
--sqlandworker csv:///%2ftmp%2ffoo.csv/bar echo /{1}/{2}/
I am not going to spend time on figuring out why --sqla does not work.
If others find the reasons, I am cool with that.
> larryp-MBP:parallel larry$ touch /tmp/foo.csv
> larryp-MBP:parallel larry$ printf '%s %s\n' {a..d} | gtee >(cat >&2) |
> src/parallel -C' ' --sqla csv:///%2ftmp%2ffoo.csv/bar echo /{1}/{2}/
> a b
> c d
> parallel: Error:
> Execution ERROR: Cannot open /Users/larry/git/parallel/bar: No such file or
> directory (2) at
> /opt/local/lib/perl5/site_perl/5.30/darwin-thread-multi-2level/DBI/DBD/SqlEngine.pm
> line 1624.
> called from src/parallel at 12446.
The same here: --sqla does not work, but this works for me:
printf '%s %s\n' {a..d} | gtee >(cat >&2) | parallel -C' '
--sqlandworker csv:///%2ftmp%2ffoo.csv/bar echo /{1}/{2}/
> I'm assuming it's OK to use the full DBTABLEURL (variable from the example)
> value on the command line.
>
> However, with 1 variable this works,
No. It works because you are writing --sqlandworker instead of --sqla.
> but completely disregards the directory:
> larryp-MBP:parallel larry$ parallel --sqlandworker
> csv:///%2FBOGUS%2FBOGUS2/mytable3 seq ::: {1..10}
That looks like a bug in DBI. Thanks.
/Ole
