->We are dealing with Flat files and facing relative table is open issue for given below scenario.
->For scenario, when we define more than one table schema in one schema file then query is not giving any result initially it used to give Table is relatively open issue.
->Our application makes use of the driver for concurrent reads with different driver class instances. So , there are basically two read access requests at the same time.
->The issue will be reoccurred only when two separate instances of driver are set to read same table at same time (concurrently).
->To replicate the issue fire query simultaneously on files having schema define d inone single schema file.
->Some of the combinations of special characters for the filename are not working for both FTP & SFTP.
->Given below is the combinations of special character for filename along with the file type and protocol.
Tar.%# - Txt Header True for both FTP & SFTP
Source.&%# - CSV Header True for SFTP
DEL.#% - CSV Header True for FTP
Tar.%# - Txt Header False for FTP
S.% - for both FTP & SFTP
>Tar.%# - Txt Header True for both FTP & SFTP
>Source.&%# - CSV Header True for SFTP
>DEL.#% - CSV Header True for FTP
>Tar.%# - Txt Header False for FTP
>S.% - for both FTP & SFTP
Tested again. No issue. % has been supported since March 9th, but disable % as escape character feature.
>To replicate the issue fire query simultaneously on files having schema define
> d inone single schema file.
Tested again with 100~200 concurrent threads. No issue for March 11th version. Your will receive a test sample.
I have mailed you the test files to replicate Realtive open Table issue.
Supported. Because @ is a special character too, and % can not disable fully as escape character feature.