Sessionize
Description
td_sessionize_sqle()
function maps each click in a session to a unique session identifier.
Usage
td_sessionize_sqle (
data = NULL,
time.column = NULL,
time.out = NULL,
click.lag = NULL,
emit.null = FALSE,
...
)
Arguments
data |
Required Argument. |
time.column |
Required Argument. |
time.out |
Required Argument. |
click.lag |
Optional Argument. |
emit.null |
Optional Argument. |
... |
Specifies the generic keyword arguments SQLE functions accept. volatile: Function allows the user to partition, hash, order or local order the input data. These generic arguments are available for each argument that accepts tbl_teradata as input and can be accessed as:
Note: |
Value
Function returns an object of class "td_sessionize_sqle"
which is a named list containing object of class "tbl_teradata".
Named list member(s) can be referenced directly with the "$" operator
using the name(s):result
Examples
# Get the current context/connection.
con <- td_get_context()$connection
# Load the example data.
loadExampleData("sessionize_example", "sessionize_table")
# Create tbl_teradata object.
sessionize_data <- tbl(con, "sessionize_table")
# Check the list of available analytic functions.
display_analytic_functions()
# Example 1: Mapping each click in a session to a unique session identifier.
# by partition column 'partition_id' and order column 'clicktime'.
obj <- td_sessionize_sqle(data=sessionize_data,
data.partition.column='partition_id',
data.order.column='clicktime',
time.column='clicktime',
time.out=60.0,
click.lag=0.2)
# Print the result.
print(obj$result)