On 3/16/20 3:34 PM, Ole Tange wrote: > On Wed, Mar 11, 2020 at 7:53 PM Larry Ploetz <lplo...@gmail.com> wrote: >> On 3/11/20 11:25 AM, Larry Ploetz - lplo...@gmail.com wrote: >> On 3/11/20 9:52 AM, Larry Ploetz - lplo...@gmail.com wrote: >> >> I think this should put a V1 and V2, along with the other joblog columns and >> stdout/stderr, but I'm getting this error. > You have found a bug. > > Try the git version: > > https://git.savannah.gnu.org/cgit/parallel.git/plain/src/parallel > > /Ole
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. at
/opt/local/lib/perl5/site_perl/5.30/darwin-thread-multi-2level/DBI/DBD/SqlEngine.pm
line 1271. 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. at
/opt/local/lib/perl5/site_perl/5.30/darwin-thread-multi-2level/DBI/DBD/SqlEngine.pm
line 1271. larryp-MBP:parallel larry$ rm /tmp/foo.csv
larryp-MBP:parallel larry$ mkdir /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. at
/opt/local/lib/perl5/site_perl/5.30/darwin-thread-multi-2level/DBI/DBD/SqlEngine.pm
line 1271. larryp-MBP:parallel larry$ touch /tmp/foo.csv/bar
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. at
/opt/local/lib/perl5/site_perl/5.30/darwin-thread-multi-2level/DBI/DBD/SqlEngine.pm
line 1271. larryp-MBP:parallel larry$ pwd /Users/larry/git/parallel
larryp-MBP:parallel larry$ touch bar 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: Missing first row due to EOF - End of data
in parsing input stream at
/opt/local/lib/perl5/site_perl/5.30/darwin-thread-multi-2level/DBI/DBD/SqlEngine.pm
line 1480. called from src/parallel at 12448. larryp-MBP:parallel
larry$ ls -l bar -rw-r--r-- 1 larry staff 0 Mar 17 12:07 bar
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, but completely disregards the
directory:
larryp-MBP:parallel larry$ parallel --sqlandworker
csv:///%2FBOGUS%2FBOGUS2/mytable3 seq ::: {1..10}
and just writes mytable3 in the CWD.
Thanks!
- Larry
pEpkey.asc
Description: application/pgp-keys
