This content has been marked as final. Show 3 replies
I am using teiid 9.1.3 and wildfly 10.0.0
I am trying to access files from local machine directory. for a single file it works fine, but how I can execute such query on multiple files at a same time?
select_par_sql = "SELECT count(SampleSourceFile.StratDesc) from (call department.getTextFiles('*.txt')) f, "+
"TEXTTABLE(f.file COLUMNS InvAssetType string, InvType string,InvAssetTypeUserDef string, StratDesc string DELIMITER '|' HEADER) SampleSourceFile where InvAssetType IN('CSH', 'CASHEQ', 'EQYNLT') AND InvType = 'NONTRADEEXP' AND InvAssetTypeUserDef != 'nonOTC';";
In above query SampleSourceFile.txt is the file name.