Fri Dec 03, 2021 1:07 am
Login Register Lost Password? Contact Us


Reading files on THOR using foreign keyword and wildcards.

Comments and questions related to the Enterprise Control Language

Fri Jul 14, 2017 8:35 am Change Time Zone

Hello Team,

The HPCC THOR version I am using is 6.2.16-1.

I am trying to accessing files from a different HPCC machine using the foreign keyword. I am using the following syntax to read those files.

EXPORT ExpDS := DATASET('~foreign::xx.xxx.xx.x::sb::li::r*::c9_*_b*_li_*.txt_w201611??-??????_bd', Dataset_Layout,THOR);

I am able to use the wildcard characters when I accessing the files from the HOST (HPCC server having these files). But I get the following error
"
System error: 0: Read: Logical file name 'foreign::xx.xxx.xx.x::sb::li::r*::c9_*_b*_li_*.txt_w201611??-??????_bd' could not be resolved
"
when trying to access the files using the foreign keyword and wildcards. Also I am able to access a single filename from a different HPCC server using the foreign keyword but the error raises when using both foreign keyword and wildcards.

Please help me in reading files with wildcards from a different HPCC server.

Thanks and regards,
Akhilesh Badhri.
akhileshbadhri
 
Posts: 24
Joined: Thu Sep 22, 2016 12:15 pm

Tue Jul 18, 2017 7:32 pm Change Time Zone

https://track.hpccsystems.com/secure/Dashboard.jspa

Please open an issue in our Issue Tracking System, and a member of our HPCC team will review this.

Thank You,

Bob
bforeman
Community Advisory Board Member
Community Advisory Board Member
 
Posts: 1005
Joined: Wed Jun 29, 2011 7:13 pm


Return to ECL

Who is online

Users browsing this forum: No registered users and 1 guest

cron