PERT Distribution Sampling

Draw samples from a PERT distribution.

hanaml.PERT(
  connection.context,
  m = NULL,
  min = NULL,
  mode = NULL,
  max = NULL,
  scale = NULL,
  seed = NULL,
  thread.ratio = NULL
)

Arguments

connection.context	ConnectionContext SAP HANA Database connection object.
m	integer, optional Specifies the number of random data to be generated. Defaults to 100.
min	numeric, optional Minimum value. Defaults to -1
mode	numeric, optional Most likely value. Defaults to 0.
max	numeric, optional Maximum value. Defaults to 1.
scale	double, optional Defaults to 4.
seed	integer, optional Indicates the seed used to initialize the random number generator: 0: Uses the system time. Not 0: Uses the specified seed. Note that when multithreading is enabled, the random number sequences of different runs might be different even if the seed value remains the same. Defaults to 0.
thread.ratio	double, optional Controls the proportion of available threads that can be used by this function. The value range is from 0 to 1, where 0 indicates a single thread, and 1 indicates all available threads. Values between 0 and 1 will use up to that percentage of available threads.Values outside this range are ignored. Defaults to 0.

Value

DataFrame containing the generated random samples, structured as follows:

• ID: type INTEGER, ID column

• GENERATED_NUMBER: type DOUBLE, sample values

Examples

Draw samples from a pert distribution:

> pert <- hanaml.pert(connection.context = conn,
                      m = 20,
                      minimum = 2,
                      mode = 3,
                      maximum = 4,
                      scale =4,
                      seed = 1,
                      thread.ratio = 0)

Output:

 > pert$collect()
    ID  GENERATED_NUMBER
 1   0          0.360781
 2   1         -0.023649
 3   2          0.106465
 4   3          0.307412
 5   4         -0.136838
 6   5         -0.086010
 7   6         -0.504639
 8   7          0.335352
 9   8         -0.287202
 10  9          0.468597