Join Methods
LogScale supports multiple methods for performing joins or lookups on data:
Method | Left Join | Inner Join | Right Join | Repository Join |
---|---|---|---|---|
defineTable()
| Yes | Yes | Yes | Yes |
readFile()
| No | No | Yes | Indirect |
match()
| Yes | Yes | No | Indirect |
join()
| Yes | Yes | No | Yes |
selfJoin()
| Yes | Yes | No | No |
Using ad-hoc tables with
defineTable()
The
defineTable()
function enables you to create a table based on a query that can then be used with other functions as the primary query or subquery.For more information, see Using Ad-hoc Tables and the
defineTable()
function.Using
readFile()
The
readFile()
function can be used to perform a join by providing the dataset that will be used as the primary key for the query.When using
readFile()
, the data contained within the file acts as the primary query. Data can be joined to the result set using a left or inner join.For more information, see Using the
readFile()
Function and thereadFile()
function.Using
match()
The
match()
function matches data from the primary query with a file that contains static lookup information.For more information, see Using the
match()
Function and thematch()
function.Using the
join()
function single repositoryThe
join()
function performs a left or inner join on two LogScale queries, the primary query and a subquery. The queries can be on the same repository and can be either a left or inner join by setting themode
.For more information, see Using the
join()
Function and thejoin()
function.Using the
join()
across repositoriesThe
join()
function can be used to join data across repositories. When used in this form, the primary query is executed against the current repository and the subquery against the repository specified in therepo
parameter to the function.For more information, see Joining Two Repositories and the
join()
function.Using
selfJoin()
The
selfJoin()
function collates data together within a repository where the data being collated shares the same value.For more information, see Using the
selfJoin()
Function and theselfJoin()
function.