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()
enables you to create a table based on a query that can then be used with other functions as the primary or sub query.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()
performs a left or inner join on two LogScale queries, the primary query and a sub-query. 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()
can be used to join data across repositories. When used in this form, the primary query is executed against the current repository and the sub-query 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()
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.