> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# gpudb::InsertRecordsRandomRequest

> gpudb::InsertRecordsRandomRequest — Kinetica C++ API

<div className="kinetica-doxygen">
  <div className="contents">
    <p>A set of parameters for <a className="el" href="/content/api/cpp/classgpudb_1_1GPUdb#a5609aacb2f2c2a35c82db9f69747404a">GPUdb::insertRecordsRandom</a>. <a href="#details">More...</a></p>
    <p><code>#include \<<a className="el" href="/content/api/cpp/insert__records__random_8h_source">gpudb/protocol/insert\_records\_random.h</a>></code></p>

    <table className="memberdecls">
      <tr className="heading">
        <td colSpan="2">
          <h2 className="groupheader"> Public Member Functions</h2>
        </td>
      </tr>

      <tr className="memitem:a16d96d174376ee33c1ad438ff5e26cde" id="r_a16d96d174376ee33c1ad438ff5e26cde">
        <td className="memItemLeft" align="right" valign="top"> </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a16d96d174376ee33c1ad438ff5e26cde">InsertRecordsRandomRequest</a> ()</td>
      </tr>

      <tr className="memdesc:a16d96d174376ee33c1ad438ff5e26cde">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Constructs an <a className="el" href="/content/api/cpp/structgpudb_1_1InsertRecordsRandomRequest" title="A set of parameters for GPUdb::insertRecordsRandom.">InsertRecordsRandomRequest</a> object with default parameters. <br /></td>
      </tr>

      <tr className="separator:a16d96d174376ee33c1ad438ff5e26cde">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:ac50340f77ae7b5dcf9f7aad8d82be3ad" id="r_ac50340f77ae7b5dcf9f7aad8d82be3ad">
        <td className="memItemLeft" align="right" valign="top"> </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#ac50340f77ae7b5dcf9f7aad8d82be3ad">InsertRecordsRandomRequest</a> (const std::string \&tableName\_, const int64\_t count\_, const std::map\< std::string, std::map\< std::string, double > > \&options\_)</td>
      </tr>

      <tr className="memdesc:ac50340f77ae7b5dcf9f7aad8d82be3ad">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Constructs an <a className="el" href="/content/api/cpp/structgpudb_1_1InsertRecordsRandomRequest" title="A set of parameters for GPUdb::insertRecordsRandom.">InsertRecordsRandomRequest</a> object with the specified parameters. <br /></td>
      </tr>

      <tr className="separator:ac50340f77ae7b5dcf9f7aad8d82be3ad">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>
    </table>

    <table className="memberdecls">
      <tr className="heading">
        <td colSpan="2">
          <h2 className="groupheader"> Public Attributes</h2>
        </td>
      </tr>

      <tr className="memitem:a944167345735a2cad3ecfbbb91adc756" id="r_a944167345735a2cad3ecfbbb91adc756">
        <td className="memItemLeft" align="right" valign="top">std::string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a944167345735a2cad3ecfbbb91adc756">tableName</a></td>
      </tr>

      <tr className="memdesc:a944167345735a2cad3ecfbbb91adc756">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Table to which random records will be added, in \[ schema\_name. <br /></td>
      </tr>

      <tr className="separator:a944167345735a2cad3ecfbbb91adc756">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a6d9974782aec402964836e1a517296cc" id="r_a6d9974782aec402964836e1a517296cc">
        <td className="memItemLeft" align="right" valign="top">int64\_t </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a6d9974782aec402964836e1a517296cc">count</a></td>
      </tr>

      <tr className="memdesc:a6d9974782aec402964836e1a517296cc">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Number of records to generate. <br /></td>
      </tr>

      <tr className="separator:a6d9974782aec402964836e1a517296cc">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a36bbeaf2b31a82007b4e747c0843e40f" id="r_a36bbeaf2b31a82007b4e747c0843e40f">
        <td className="memItemLeft" align="right" valign="top">std::map\< std::string, std::map\< std::string, double > > </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a36bbeaf2b31a82007b4e747c0843e40f">options</a></td>
      </tr>

      <tr className="memdesc:a36bbeaf2b31a82007b4e747c0843e40f">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Optional parameter to pass in specifications for the randomness of the values. <br /></td>
      </tr>

      <tr className="separator:a36bbeaf2b31a82007b4e747c0843e40f">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>
    </table>

    <h2 className="groupheader">Detailed Description</h2>

    <div className="textblock">
      <p>A set of parameters for <a className="el" href="/content/api/cpp/classgpudb_1_1GPUdb#a5609aacb2f2c2a35c82db9f69747404a">GPUdb::insertRecordsRandom</a>. </p>
      <p>Generates a specified number of random records and adds them to the given table. There is an optional parameter that allows the user to customize the ranges of the column values. It also allows the user to specify linear profiles for some or all columns in which case linear values are generated rather than random ones. Only individual tables are supported for this operation.</p>
      <p>This operation is synchronous, meaning that a response will not be returned until all random records are fully available. </p>
      <p className="definition">Definition at line <a className="el" href="/content/api/cpp/insert__records__random_8h_source#l00026">26</a> of file <a className="el" href="/content/api/cpp/insert__records__random_8h_source">insert\_records\_random.h</a>.</p>
    </div>

    <h2 className="groupheader">Constructor & Destructor Documentation</h2>
    <h2 className="memtitle"><span className="permalink"><a href="#a16d96d174376ee33c1ad438ff5e26cde">◆ </a></span>InsertRecordsRandomRequest() <span className="overload">\[1/2]</span></h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">gpudb::InsertRecordsRandomRequest::InsertRecordsRandomRequest </td>
                  <td>(</td>

                  <td className="paramname">
                    <span className="paramname">
                      <span className="em" />
                    </span>
                  </td>

                  <td>)</td>

                  <td />
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel inline">inline</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>Constructs an <a className="el" href="/content/api/cpp/structgpudb_1_1InsertRecordsRandomRequest" title="A set of parameters for GPUdb::insertRecordsRandom.">InsertRecordsRandomRequest</a> object with default parameters. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cpp/insert__records__random_8h_source#l00032">32</a> of file <a className="el" href="/content/api/cpp/insert__records__random_8h_source">insert\_records\_random.h</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#ac50340f77ae7b5dcf9f7aad8d82be3ad">◆ </a></span>InsertRecordsRandomRequest() <span className="overload">\[2/2]</span></h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">gpudb::InsertRecordsRandomRequest::InsertRecordsRandomRequest </td>
                  <td>(</td>
                  <td className="paramtype">const std::string &</td>
                  <td className="paramname"><span className="paramname"><span className="em">tableName\_</span></span>, </td>
                </tr>

                <tr>
                  <td className="paramkey" />

                  <td />

                  <td className="paramtype">const int64\_t</td>
                  <td className="paramname"><span className="paramname"><span className="em">count\_</span></span>, </td>
                </tr>

                <tr>
                  <td className="paramkey" />

                  <td />

                  <td className="paramtype">const std::map\< std::string, std::map\< std::string, double > > &</td>
                  <td className="paramname"><span className="paramname"><span className="em">options\_</span></span> )</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel inline">inline</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>Constructs an <a className="el" href="/content/api/cpp/structgpudb_1_1InsertRecordsRandomRequest" title="A set of parameters for GPUdb::insertRecordsRandom.">InsertRecordsRandomRequest</a> object with the specified parameters. </p>

        <div className="dl params">
          <div className="dt">Parameters</div>

          <div className="dd">
            <table className="params">
              <tr>
                <td className="paramdir">\[in]</td>
                <td className="paramname">tableName\_</td>
                <td>Table to which random records will be added, in \[schema\_name.]table\_name format, using standard <a href="/content/concepts/tables/#table-name-resolution" target="_top">name resolution rules</a>. Must be an existing table, not a view. </td>
              </tr>

              <tr>
                <td className="paramdir">\[in]</td>
                <td className="paramname">count\_</td>
                <td>Number of records to generate. </td>
              </tr>

              <tr>
                <td className="paramdir">\[in]</td>
                <td className="paramname">options\_</td>

                <td>
                  Optional parameter to pass in specifications for the randomness of the values. This map is different from the <span className="em">options</span> parameter of most other endpoints in that it is a map of string to map of string to doubles, while most others are maps of string to string. In this map, the top level keys represent which column's parameters are being specified, while the internal keys represents which parameter is being specified. These parameters take on different meanings depending on the type of the column.

                  <ul>
                    <li>
                      <a className="el" href="/content/api/cpp/namespacegpudb#a3a47eb3c9717d32bdf6246b09d314b5e">insert\_records\_random\_seed</a>: If provided, the internal random number generator will be initialized with the given value. The minimum is 0. This allows for the same set of random numbers to be generated across invocation of this endpoint in case the user wants to repeat the test. Since <span className="em arg">options\_</span>, is a map of maps, we need an internal map to provide the seed value. For example, to pass 100 as the seed value through this parameter, you need something equivalent to: 'options' = {"{"}'seed': {"{"} 'value': 100 {"}"} {"}"}.

                      <ul>
                        <li> <a className="el" href="/content/api/cpp/namespacegpudb#a14f89f731b7bebf0b3b4b0eb663d1aff">insert\_records\_random\_value</a>: The seed value to use. </li>
                      </ul>
                    </li>

                    <li>
                      <a className="el" href="/content/api/cpp/namespacegpudb#a61dab5043197b18dc5aa502b03a488ae">insert\_records\_random\_all</a>: This key indicates that the specifications relayed in the internal map are to be applied to all columns of the records.

                      <ul>
                        <li> <a className="el" href="/content/api/cpp/namespacegpudb#a7212fd8f4d59b0a3e48df5a5e11af914">insert\_records\_random\_min</a>: For numerical columns, the minimum of the generated values is set to this value. Default is -99999. For point, shape, and track columns, min for numeric 'x' and 'y' columns needs to be within \[-180, 180] and \[-90, 90], respectively. The default minimum possible values for these columns in such cases are -180.0 and -90.0. For the 'TIMESTAMP' column, the default minimum corresponds to Jan 1, 2010. For string columns, the minimum length of the randomly generated strings is set to this value (default is 0). If both minimum and maximum are provided, minimum must be less than or equal to max. If the min is outside the accepted ranges for strings columns and 'x' and 'y' columns for point/shape/track, then those parameters will not be set; however, an error will not be thrown in such a case. It is the responsibility of the user to use the <a className="el" href="/content/api/cpp/namespacegpudb#a61dab5043197b18dc5aa502b03a488ae">all</a> parameter judiciously. </li>
                        <li> <a className="el" href="/content/api/cpp/namespacegpudb#aa014ca0414df10ca93297b0356c99a3b">insert\_records\_random\_max</a>: For numerical columns, the maximum of the generated values is set to this value. Default is 99999. For point, shape, and track columns, max for numeric 'x' and 'y' columns needs to be within \[-180, 180] and \[-90, 90], respectively. The default minimum possible values for these columns in such cases are 180.0 and 90.0. For string columns, the maximum length of the randomly generated strings. If both minimum and maximum are provided, <span className="em">max</span> must be greater than or equal to <span className="em">min</span>. If the <span className="em">max</span> is outside the accepted ranges for strings columns and 'x' and 'y' columns for point/shape/track, then those parameters will not be set; however, an error will not be thrown in such a case. It is the responsibility of the user to use the <a className="el" href="/content/api/cpp/namespacegpudb#a61dab5043197b18dc5aa502b03a488ae">all</a> parameter judiciously. </li>
                        <li> <a className="el" href="/content/api/cpp/namespacegpudb#a573bb4a6db42fe84c90d6783ec3ce584">insert\_records\_random\_interval</a>: If specified, generate values for all columns evenly spaced with the given interval value. If a max value is specified for a given column the data is randomly generated between min and max and decimated down to the interval. If no max is provided the data is linearly generated starting at the minimum value (instead of generating random data). For non-decimated string-type columns the interval value is ignored. Instead the values are generated following the pattern: 'attrname\_creationIndex#', i.e. the column name suffixed with an underscore and a running counter (starting at 0). For string types with limited size (e.g. char4) the prefix is dropped. No nulls will be generated for nullable columns. </li>
                        <li> <a className="el" href="/content/api/cpp/namespacegpudb#adc4e1a54ee77b5a6d4707127aca1e92d">insert\_records\_random\_null\_percentage</a>: If specified, then generate the given percentage of the count as nulls for all nullable columns. This option will be ignored for non-nullable columns. The value must be within the range \[0, 1.0]. The default value is 5% (0.05). </li>
                        <li> <a className="el" href="/content/api/cpp/namespacegpudb#a49bcb2ef666ae4f8179ddfbf603817ce">insert\_records\_random\_cardinality</a>: If specified, limit the randomly generated values to a fixed set. Not allowed on a column with interval specified, and is not applicable to WKT or Track-specific columns. The value must be greater than 0. This option is disabled by default. </li>
                      </ul>
                    </li>

                    <li>
                      <a className="el" href="/content/api/cpp/namespacegpudb#a5078ef6cf8caab1135d620e1373eb288">insert\_records\_random\_attr\_name</a>: Use the desired column name in place of <a className="el" href="/content/api/cpp/namespacegpudb#a5078ef6cf8caab1135d620e1373eb288">attr\_name</a>, and set the following parameters for the column specified. This overrides any parameter set by <a className="el" href="/content/api/cpp/namespacegpudb#a61dab5043197b18dc5aa502b03a488ae">all</a>.

                      <ul>
                        <li> <a className="el" href="/content/api/cpp/namespacegpudb#a7212fd8f4d59b0a3e48df5a5e11af914">insert\_records\_random\_min</a>: For numerical columns, the minimum of the generated values is set to this value. Default is -99999. For point, shape, and track columns, min for numeric 'x' and 'y' columns needs to be within \[-180, 180] and \[-90, 90], respectively. The default minimum possible values for these columns in such cases are -180.0 and -90.0. For the 'TIMESTAMP' column, the default minimum corresponds to Jan 1, 2010. For string columns, the minimum length of the randomly generated strings is set to this value (default is 0). If both minimum and maximum are provided, minimum must be less than or equal to max. If the min is outside the accepted ranges for strings columns and 'x' and 'y' columns for point/shape/track, then those parameters will not be set; however, an error will not be thrown in such a case. It is the responsibility of the user to use the <a className="el" href="/content/api/cpp/namespacegpudb#a61dab5043197b18dc5aa502b03a488ae">all</a> parameter judiciously. </li>
                        <li> <a className="el" href="/content/api/cpp/namespacegpudb#aa014ca0414df10ca93297b0356c99a3b">insert\_records\_random\_max</a>: For numerical columns, the maximum of the generated values is set to this value. Default is 99999. For point, shape, and track columns, max for numeric 'x' and 'y' columns needs to be within \[-180, 180] and \[-90, 90], respectively. The default minimum possible values for these columns in such cases are 180.0 and 90.0. For string columns, the maximum length of the randomly generated strings. If both minimum and maximum are provided, <span className="em">max</span> must be greater than or equal to <span className="em">min</span>. If the <span className="em">max</span> is outside the accepted ranges for strings columns and 'x' and 'y' columns for point/shape/track, then those parameters will not be set; however, an error will not be thrown in such a case. It is the responsibility of the user to use the <a className="el" href="/content/api/cpp/namespacegpudb#a61dab5043197b18dc5aa502b03a488ae">all</a> parameter judiciously. </li>
                        <li> <a className="el" href="/content/api/cpp/namespacegpudb#a573bb4a6db42fe84c90d6783ec3ce584">insert\_records\_random\_interval</a>: If specified, generate values for all columns evenly spaced with the given interval value. If a max value is specified for a given column the data is randomly generated between min and max and decimated down to the interval. If no max is provided the data is linearly generated starting at the minimum value (instead of generating random data). For non-decimated string-type columns the interval value is ignored. Instead the values are generated following the pattern: 'attrname\_creationIndex#', i.e. the column name suffixed with an underscore and a running counter (starting at 0). For string types with limited size (e.g. char4) the prefix is dropped. No nulls will be generated for nullable columns. </li>
                        <li> <a className="el" href="/content/api/cpp/namespacegpudb#adc4e1a54ee77b5a6d4707127aca1e92d">insert\_records\_random\_null\_percentage</a>: If specified and if this column is nullable, then generate the given percentage of the count as nulls. This option will result in an error if the column is not nullable. The value must be within the range \[0, 1.0]. The default value is 5% (0.05). </li>
                        <li> <a className="el" href="/content/api/cpp/namespacegpudb#a49bcb2ef666ae4f8179ddfbf603817ce">insert\_records\_random\_cardinality</a>: If specified, limit the randomly generated values to a fixed set. Not allowed on a column with interval specified, and is not applicable to WKT or Track-specific columns. The value must be greater than 0. This option is disabled by default. </li>
                      </ul>
                    </li>

                    <li>
                      <a className="el" href="/content/api/cpp/namespacegpudb#a33761bebd725c71887ad15f1064d9cdd">insert\_records\_random\_track\_length</a>: This key-map pair is only valid for track data sets (an error is thrown otherwise). No nulls would be generated for nullable columns.

                      <ul>
                        <li> <a className="el" href="/content/api/cpp/namespacegpudb#a7212fd8f4d59b0a3e48df5a5e11af914">insert\_records\_random\_min</a>: Minimum possible length for generated series; default is 100 records per series. Must be an integral value within the range \[1, 500]. If both min and max are specified, min must be less than or equal to max. The minimum allowed value is 1. The maximum allowed value is 500. </li>
                        <li> <a className="el" href="/content/api/cpp/namespacegpudb#aa014ca0414df10ca93297b0356c99a3b">insert\_records\_random\_max</a>: Maximum possible length for generated series; default is 500 records per series. Must be an integral value within the range \[1, 500]. If both min and max are specified, max must be greater than or equal to min. The minimum allowed value is 1. The maximum allowed value is 500. </li>
                      </ul>
                    </li>
                  </ul>

                  The default value is an empty map.
                </td>
              </tr>
            </table>
          </div>
        </div>

        <p className="definition">Definition at line <a className="el" href="/content/api/cpp/insert__records__random_8h_source#l00374">374</a> of file <a className="el" href="/content/api/cpp/insert__records__random_8h_source">insert\_records\_random.h</a>.</p>
      </div>
    </div>

    <h2 className="groupheader">Member Data Documentation</h2>
    <h2 className="memtitle"><span className="permalink"><a href="#a6d9974782aec402964836e1a517296cc">◆ </a></span>count</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="memname">
          <tr>
            <td className="memname">int64\_t gpudb::InsertRecordsRandomRequest::count</td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>Number of records to generate. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cpp/insert__records__random_8h_source#l00393">393</a> of file <a className="el" href="/content/api/cpp/insert__records__random_8h_source">insert\_records\_random.h</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a36bbeaf2b31a82007b4e747c0843e40f">◆ </a></span>options</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="memname">
          <tr>
            <td className="memname">std::map\<std::string, std::map\<std::string, double> > gpudb::InsertRecordsRandomRequest::options</td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>Optional parameter to pass in specifications for the randomness of the values. </p>
        <p>This map is different from the <span className="em">options</span> parameter of most other endpoints in that it is a map of string to map of string to doubles, while most others are maps of string to string. In this map, the top level keys represent which column's parameters are being specified, while the internal keys represents which parameter is being specified. These parameters take on different meanings depending on the type of the column. </p>

        <ul>
          <li>
            <a className="el" href="/content/api/cpp/namespacegpudb#a3a47eb3c9717d32bdf6246b09d314b5e">insert\_records\_random\_seed</a>: If provided, the internal random number generator will be initialized with the given value. The minimum is 0. This allows for the same set of random numbers to be generated across invocation of this endpoint in case the user wants to repeat the test. Since <a className="el" href="#a36bbeaf2b31a82007b4e747c0843e40f">options</a>, is a map of maps, we need an internal map to provide the seed value. For example, to pass 100 as the seed value through this parameter, you need something equivalent to: 'options' = {"{"}'seed': {"{"} 'value': 100 {"}"} {"}"}.

            <ul>
              <li> <a className="el" href="/content/api/cpp/namespacegpudb#a14f89f731b7bebf0b3b4b0eb663d1aff">insert\_records\_random\_value</a>: The seed value to use. </li>
            </ul>
          </li>

          <li>
            <a className="el" href="/content/api/cpp/namespacegpudb#a61dab5043197b18dc5aa502b03a488ae">insert\_records\_random\_all</a>: This key indicates that the specifications relayed in the internal map are to be applied to all columns of the records.

            <ul>
              <li> <a className="el" href="/content/api/cpp/namespacegpudb#a7212fd8f4d59b0a3e48df5a5e11af914">insert\_records\_random\_min</a>: For numerical columns, the minimum of the generated values is set to this value. Default is -99999. For point, shape, and track columns, min for numeric 'x' and 'y' columns needs to be within \[-180, 180] and \[-90, 90], respectively. The default minimum possible values for these columns in such cases are -180.0 and -90.0. For the 'TIMESTAMP' column, the default minimum corresponds to Jan 1, 2010. For string columns, the minimum length of the randomly generated strings is set to this value (default is 0). If both minimum and maximum are provided, minimum must be less than or equal to max. If the min is outside the accepted ranges for strings columns and 'x' and 'y' columns for point/shape/track, then those parameters will not be set; however, an error will not be thrown in such a case. It is the responsibility of the user to use the <a className="el" href="/content/api/cpp/namespacegpudb#a61dab5043197b18dc5aa502b03a488ae">all</a> parameter judiciously. </li>
              <li> <a className="el" href="/content/api/cpp/namespacegpudb#aa014ca0414df10ca93297b0356c99a3b">insert\_records\_random\_max</a>: For numerical columns, the maximum of the generated values is set to this value. Default is 99999. For point, shape, and track columns, max for numeric 'x' and 'y' columns needs to be within \[-180, 180] and \[-90, 90], respectively. The default minimum possible values for these columns in such cases are 180.0 and 90.0. For string columns, the maximum length of the randomly generated strings. If both minimum and maximum are provided, <span className="em">max</span> must be greater than or equal to <span className="em">min</span>. If the <span className="em">max</span> is outside the accepted ranges for strings columns and 'x' and 'y' columns for point/shape/track, then those parameters will not be set; however, an error will not be thrown in such a case. It is the responsibility of the user to use the <a className="el" href="/content/api/cpp/namespacegpudb#a61dab5043197b18dc5aa502b03a488ae">all</a> parameter judiciously. </li>
              <li> <a className="el" href="/content/api/cpp/namespacegpudb#a573bb4a6db42fe84c90d6783ec3ce584">insert\_records\_random\_interval</a>: If specified, generate values for all columns evenly spaced with the given interval value. If a max value is specified for a given column the data is randomly generated between min and max and decimated down to the interval. If no max is provided the data is linearly generated starting at the minimum value (instead of generating random data). For non-decimated string-type columns the interval value is ignored. Instead the values are generated following the pattern: 'attrname\_creationIndex#', i.e. the column name suffixed with an underscore and a running counter (starting at 0). For string types with limited size (e.g. char4) the prefix is dropped. No nulls will be generated for nullable columns. </li>
              <li> <a className="el" href="/content/api/cpp/namespacegpudb#adc4e1a54ee77b5a6d4707127aca1e92d">insert\_records\_random\_null\_percentage</a>: If specified, then generate the given percentage of the count as nulls for all nullable columns. This option will be ignored for non-nullable columns. The value must be within the range \[0, 1.0]. The default value is 5% (0.05). </li>
              <li> <a className="el" href="/content/api/cpp/namespacegpudb#a49bcb2ef666ae4f8179ddfbf603817ce">insert\_records\_random\_cardinality</a>: If specified, limit the randomly generated values to a fixed set. Not allowed on a column with interval specified, and is not applicable to WKT or Track-specific columns. The value must be greater than 0. This option is disabled by default. </li>
            </ul>
          </li>

          <li>
            <a className="el" href="/content/api/cpp/namespacegpudb#a5078ef6cf8caab1135d620e1373eb288">insert\_records\_random\_attr\_name</a>: Use the desired column name in place of <a className="el" href="/content/api/cpp/namespacegpudb#a5078ef6cf8caab1135d620e1373eb288">attr\_name</a>, and set the following parameters for the column specified. This overrides any parameter set by <a className="el" href="/content/api/cpp/namespacegpudb#a61dab5043197b18dc5aa502b03a488ae">all</a>.

            <ul>
              <li> <a className="el" href="/content/api/cpp/namespacegpudb#a7212fd8f4d59b0a3e48df5a5e11af914">insert\_records\_random\_min</a>: For numerical columns, the minimum of the generated values is set to this value. Default is -99999. For point, shape, and track columns, min for numeric 'x' and 'y' columns needs to be within \[-180, 180] and \[-90, 90], respectively. The default minimum possible values for these columns in such cases are -180.0 and -90.0. For the 'TIMESTAMP' column, the default minimum corresponds to Jan 1, 2010. For string columns, the minimum length of the randomly generated strings is set to this value (default is 0). If both minimum and maximum are provided, minimum must be less than or equal to max. If the min is outside the accepted ranges for strings columns and 'x' and 'y' columns for point/shape/track, then those parameters will not be set; however, an error will not be thrown in such a case. It is the responsibility of the user to use the <a className="el" href="/content/api/cpp/namespacegpudb#a61dab5043197b18dc5aa502b03a488ae">all</a> parameter judiciously. </li>
              <li> <a className="el" href="/content/api/cpp/namespacegpudb#aa014ca0414df10ca93297b0356c99a3b">insert\_records\_random\_max</a>: For numerical columns, the maximum of the generated values is set to this value. Default is 99999. For point, shape, and track columns, max for numeric 'x' and 'y' columns needs to be within \[-180, 180] and \[-90, 90], respectively. The default minimum possible values for these columns in such cases are 180.0 and 90.0. For string columns, the maximum length of the randomly generated strings. If both minimum and maximum are provided, <span className="em">max</span> must be greater than or equal to <span className="em">min</span>. If the <span className="em">max</span> is outside the accepted ranges for strings columns and 'x' and 'y' columns for point/shape/track, then those parameters will not be set; however, an error will not be thrown in such a case. It is the responsibility of the user to use the <a className="el" href="/content/api/cpp/namespacegpudb#a61dab5043197b18dc5aa502b03a488ae">all</a> parameter judiciously. </li>
              <li> <a className="el" href="/content/api/cpp/namespacegpudb#a573bb4a6db42fe84c90d6783ec3ce584">insert\_records\_random\_interval</a>: If specified, generate values for all columns evenly spaced with the given interval value. If a max value is specified for a given column the data is randomly generated between min and max and decimated down to the interval. If no max is provided the data is linearly generated starting at the minimum value (instead of generating random data). For non-decimated string-type columns the interval value is ignored. Instead the values are generated following the pattern: 'attrname\_creationIndex#', i.e. the column name suffixed with an underscore and a running counter (starting at 0). For string types with limited size (e.g. char4) the prefix is dropped. No nulls will be generated for nullable columns. </li>
              <li> <a className="el" href="/content/api/cpp/namespacegpudb#adc4e1a54ee77b5a6d4707127aca1e92d">insert\_records\_random\_null\_percentage</a>: If specified and if this column is nullable, then generate the given percentage of the count as nulls. This option will result in an error if the column is not nullable. The value must be within the range \[0, 1.0]. The default value is 5% (0.05). </li>
              <li> <a className="el" href="/content/api/cpp/namespacegpudb#a49bcb2ef666ae4f8179ddfbf603817ce">insert\_records\_random\_cardinality</a>: If specified, limit the randomly generated values to a fixed set. Not allowed on a column with interval specified, and is not applicable to WKT or Track-specific columns. The value must be greater than 0. This option is disabled by default. </li>
            </ul>
          </li>

          <li>
            <a className="el" href="/content/api/cpp/namespacegpudb#a33761bebd725c71887ad15f1064d9cdd">insert\_records\_random\_track\_length</a>: This key-map pair is only valid for track data sets (an error is thrown otherwise). No nulls would be generated for nullable columns.

            <ul>
              <li> <a className="el" href="/content/api/cpp/namespacegpudb#a7212fd8f4d59b0a3e48df5a5e11af914">insert\_records\_random\_min</a>: Minimum possible length for generated series; default is 100 records per series. Must be an integral value within the range \[1, 500]. If both min and max are specified, min must be less than or equal to max. The minimum allowed value is 1. The maximum allowed value is 500. </li>
              <li> <a className="el" href="/content/api/cpp/namespacegpudb#aa014ca0414df10ca93297b0356c99a3b">insert\_records\_random\_max</a>: Maximum possible length for generated series; default is 500 records per series. Must be an integral value within the range \[1, 500]. If both min and max are specified, max must be greater than or equal to min. The minimum allowed value is 1. The maximum allowed value is 500. </li>
            </ul>
          </li>
        </ul>

        <p>The default value is an empty map. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cpp/insert__records__random_8h_source#l00602">602</a> of file <a className="el" href="/content/api/cpp/insert__records__random_8h_source">insert\_records\_random.h</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a944167345735a2cad3ecfbbb91adc756">◆ </a></span>tableName</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="memname">
          <tr>
            <td className="memname">std::string gpudb::InsertRecordsRandomRequest::tableName</td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>Table to which random records will be added, in \[ schema\_name. </p>
        <p>\ ]table\_name format, using standard <a href="/content/concepts/tables/#table-name-resolution" target="_top">name resolution rules</a>. Must be an existing table, not a view. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cpp/insert__records__random_8h_source#l00388">388</a> of file <a className="el" href="/content/api/cpp/insert__records__random_8h_source">insert\_records\_random.h</a>.</p>
      </div>
    </div>

    <hr />

    The documentation for this struct was generated from the following file:

    <ul>
      <li>gpudb/protocol/<a className="el" href="/content/api/cpp/insert__records__random_8h_source">insert\_records\_random.h</a></li>
    </ul>
  </div>
</div>