Hi Wouter, Wouter Alink wrote:
Well, that can't be the cause then. :) I will file the bug-report regarding the BOM.
ta!
It seems that mclient is confused about what to read first (statement or stdin) and perhaps it is a bug? I think an mclient guru might be able to answer this?
I've now moved to the latest release set, Feb-2009, and still have the same issue in either pipe or stdin from the cli when used in combination with -s ; so its safe to assume the 'issue' persists.
$ (N=4; echo "copy $N records into aap from STDIN;"; head -n $N data.dat) | mclient -lsql -dtest
Various other options seem to work if the copy command goes in with the data via STDIN. Just to be as close to your case as possible : $ time ( echo "copy 632074442 records into sample from STDIN using delimiters '\t','\n','';" ; zcat web_tracker20090420.txt.gz ) | recode iso8859-1..utf-8 | mclient -lsql -ukb -Pkb [ 632074442 ] real 689m22.520s user 165m59.511s sys 313m45.179s
So this could be another workaround? Have you tried this already?
have now :) well, I did manage to get the stream working with the sql going in along with the data :) Thanks for your help on this matter. - KB