Home -> Usenet -> c.d.o.server -> External table and preprocessor

External table and preprocessor

From: Mauro V <bandieragialla_at_gmail.com>
Date: Mon, 12 May 2014 07:37:10 -0700 (PDT)
Message-ID: <bf904c47-7241-4355-bbd7-655be28bbe48_at_googlegroups.com> 





Hi,



I have an external table where  I MUST  use PREPROCESSOR
PREPROCESSOR exec_dir: 'myPrecocessor.sh'



Where myPreprocessor.sh is:


#!/bi/sh


cat `cat $1`



The files in the external table doesn't contain the data but the file name with the data. 



To read data we use a select with parallel, but parallel no used.
Perhaps optimizer doesn't see the size of dat files, there is a way to pass to optinizer the size? Doi I hav eto substitute cat with co to /dev/stdout?



Thanks 

 
Received on Mon May 12 2014 - 16:37:10 CEST












Original text of this message