oxla_home_files
virtual table lists all files associated with a specific table in the oxla home directory. This approach offers a more reliable way to retrieve data than simply scanning files directly.
Field | Content | Type |
---|---|---|
path | Path relative from the oxla working directory | TEXT |
byte_size | Size of the file in bytes | BIGINT |
start_index | First index in the file, binary data base64 encoded (if applicable) | NULLABLE TEXT |
end_index | Last index in the file, binary data base64 encoded (if applicable) | NULLABLE TEXT |
row_count | Number of rows in the file | BIGINT |
batch_count | Number of batches the file is divided into | BIGINT |
table_id | ID of the related table | BIGINT |
namespace_id | ID of the related namespace | BIGINT |
database_id | ID of the related database | BIGINT |
oxla_home_files
table in an Oxla instance
oxla_home_files
query below:oxla_home_files
table is empty, the query returns an empty result set:oxla_home_files
query: