Normal Distribution Sampling

Draw samples from a normal distribution.

hanaml.normal(
  connection.context,
  m = NULL,
  mean = NULL,
  sd = 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.
mean

numeric, optional
Mean value of the underlying normal distribution.
Defaults to 0.
sd

numeric, optional
Standard deviation of the underlying normal distribution.
Defaults to 1.
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 normal distribution:

> normal <- hanaml.normal(connection.context = conn,
                          mean = 1,
                          sd = 2,
                          m = 20,
                          seed = 1, thread.ratio = 0)

Output:

> normal$collect()
    ID  GENERATED_NUMBER
1   0          0.321078
2   1         -1.327626
3   2          0.798867
4   3         -0.116128
5   4         -0.213519
6   5          0.008566
7   6          0.251733
8   7          0.404510
9   8         -0.534899
10  9         -0.420968