Installed files are available within the current working directory of the Stream function. Installed files are stored in subdirectories corresponding to their schemas within the SQLMR execution directory.
In addition, files of schemas in the search_path are placed in the top-level SQLMR execution directory. This lets you refer to files without a schema-qualified name from the query using Stream. If two files with identical names exist in different schemas, only the file with higher priority will exist.
The files' priority is determined by the following rules:
- Files that appear in schemas in the search path have higher priority than those that do not.
- Files that appear in schemas in the search path have priorities ordered by their search path. The earlier the schema appears in the search_path, the higher the priority.
- Files that appear in schemas not in the search path have priorities that correspond to the alphabetical order of the schemas.