I may not have made it obvious that I was using the git version of
parallel in the most recent tests below. Sorry.

On 3/17/20 12:33 PM, Larry Ploetz wrote:
> On 3/17/20 12:21 PM, Larry Ploetz wrote:
>> 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
>>
> I'm pretty sure this should work using sqlite3 instead of CSV
>
>     larryp-MBP:parallel larry$ printf '%s %s\n' {a..d} | gtee >(cat >&2) | 
> src/parallel -C' ' --sqla sqlite3:///%2ftmp%2ffoo/mytable echo /{1}/{2}/
>     a b
>     c d
>     DBD::SQLite::db prepare failed: no such table: mytable [for Statement 
> "SELECT * FROM mytable LIMIT 1;"] at src/parallel line 12445.
>
> Thanks!
> - Larry
>

Attachment: pEpkey.asc
Description: application/pgp-keys

Reply via email to