(hash-join colname lhs rhs)(hash-join colname
lhs
rhs
{:keys [operation-space] :or {operation-space :int32} :as options})Join by column. For efficiency, lhs should be smaller than rhs. colname - may be a single item or a tuple in which is destructures as: (let [[lhs-colname rhs-colname]] colname] ...) An options map can be passed in with optional arguments: :lhs-missing? Calculate the missing lhs indexes and left outer join table. :rhs-missing? Calculate the missing rhs indexes and right outer join table. :operation-space - either :int32 or :int64. Defaults to :int32. Returns {:join-table - joined-table :lhs-indexes - matched lhs indexes :rhs-indexes - matched rhs indexes ;; -- when rhs-missing? is true -- :rhs-missing - missing indexes of rhs. :rhs-outer-join - rhs outer join table. ;; -- when lhs-missing? is true -- :lhs-missing - missing indexes of lhs. :lhs-outer-join - lhs outer join table. }
Join by column. For efficiency, lhs should be smaller than rhs.
colname - may be a single item or a tuple in which is destructures as:
(let [[lhs-colname rhs-colname]] colname] ...)
An options map can be passed in with optional arguments:
:lhs-missing? Calculate the missing lhs indexes and left outer join table.
:rhs-missing? Calculate the missing rhs indexes and right outer join table.
:operation-space - either :int32 or :int64. Defaults to :int32.
Returns
{:join-table - joined-table
:lhs-indexes - matched lhs indexes
:rhs-indexes - matched rhs indexes
;; -- when rhs-missing? is true --
:rhs-missing - missing indexes of rhs.
:rhs-outer-join - rhs outer join table.
;; -- when lhs-missing? is true --
:lhs-missing - missing indexes of lhs.
:lhs-outer-join - lhs outer join table.
}(inner-join colname lhs rhs)(inner-join colname lhs rhs options)Inner join by column. For efficiency, lhs should be smaller than rhs. colname - may be a single item or a tuple in which is destructures as: (let [[lhs-colname rhs-colname]] colname] ...) An options map can be passed in with optional arguments: :operation-space - either :int32 or :int64. Defaults to :int32. Returns the joined table
Inner join by column. For efficiency, lhs should be smaller than rhs. colname - may be a single item or a tuple in which is destructures as: (let [[lhs-colname rhs-colname]] colname] ...) An options map can be passed in with optional arguments: :operation-space - either :int32 or :int64. Defaults to :int32. Returns the joined table
(left-join colname lhs rhs)(left-join colname lhs rhs options)Left join by column. For efficiency, lhs should be smaller than rhs. colname - may be a single item or a tuple in which is destructures as: (let [[lhs-colname rhs-colname]] colname] ...) An options map can be passed in with optional arguments: :operation-space - either :int32 or :int64. Defaults to :int32. Returns the joined table
Left join by column. For efficiency, lhs should be smaller than rhs. colname - may be a single item or a tuple in which is destructures as: (let [[lhs-colname rhs-colname]] colname] ...) An options map can be passed in with optional arguments: :operation-space - either :int32 or :int64. Defaults to :int32. Returns the joined table
(left-join-asof colname lhs rhs)(left-join-asof colname lhs rhs {:keys [asof-op] :or {asof-op :<=} :as options})Perform a left join asof. Similar to left join except this will join on nearest value. lhs and rhs must be sorted by join-column. join columns must be either datetime columns in which the join happens in millisecond space or they must be numeric - integer or floating point datatypes.
options:
asof-op- may be [:< :<= :nearest :>= :>] - type of join operation. Defaults to
<=.Perform a left join asof. Similar to left join except this will join on nearest value. lhs and rhs must be sorted by join-column. join columns must be either datetime columns in which the join happens in millisecond space or they must be numeric - integer or floating point datatypes. options: - `asof-op`- may be [:< :<= :nearest :>= :>] - type of join operation. Defaults to <=.
(right-join colname lhs rhs)(right-join colname lhs rhs options)Right join by column. For efficiency, lhs should be smaller than rhs. colname - may be a single item or a tuple in which is destructures as: (let [[lhs-colname rhs-colname]] colname] ...) An options map can be passed in with optional arguments: :operation-space - either :int32 or :int64. Defaults to :int32. Returns the joined table
Right join by column. For efficiency, lhs should be smaller than rhs. colname - may be a single item or a tuple in which is destructures as: (let [[lhs-colname rhs-colname]] colname] ...) An options map can be passed in with optional arguments: :operation-space - either :int32 or :int64. Defaults to :int32. Returns the joined table
cljdoc builds & hosts documentation for Clojure/Script libraries
| Ctrl+k | Jump to recent docs |
| ← | Move to previous article |
| → | Move to next article |
| Ctrl+/ | Jump to the search field |