{"title":"DB Table Partitioner","nodeType":"Manipulator","id":"*NKuW-RponmBdKGHF","factoryName":"org.knime.database.node.manipulation.sampling.partition.DBPartitionNodeFactory","factoryId":"org.knime.database.node.manipulation.sampling.partition.DBPartitionNodeFactory","path":["DB","Query"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>This node split rows from a DB Data table. The dialog enables you to specify the number of rows to split and the splitting strategy.</p><p><b>The created partitions might overlap depending on the database and the selected sampling option.</b> KNIME is not storing the data of the first partition in any way but is executing the query that represents the first partition also as part of the query to retrieve the second partition. If the query that defines the first partition returns a different result for each execution the two partitions might overlap. This is most likely the case for random sampling without a fixed seed.</p>\n            \n        \n        ","shortDescription":"The input table is split into two partitions (i.e. row-wise), e.g. train and test data.","keywords":["DB Partitioning","sample","sampling","database","partition"],"deprecated":false,"streamable":true,"tags":["DB","Query","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAAOxAAADsQBlSsOGwAAABl0RVh0U29mdHdhcmUAd3d3Lmlua3NjYXBlLm9yZ5vuPBoAAAD0SURBVDiNpdExSgNRFIXhL+NzICDBWIkIdtpYuw5bV2DpdrQQxC2Iiu7AKe1iQASLKSSiREELeRa+mDBM1IkHbnO473/33Ms/NYcb7GALLfSbQmKlzhOo6tfVsA7wjDZiURSXZVmehBAG6GI19XSxUQW84xSbo8nKsowxxpjn+SB5C6kXljEMKf89rkfEWdTCGvZwhcUmO+jjbcJ8TcA/q0o9azj598M7HPhaTh14aoQl5BPUNuZDCA8xxv1er3dsvPnaK3xgPdV2qpUsyzLsdjqdHzMEPFW8R7z8Hn+saq7DKX7tDgJu0499XOAoARqdcmZ9ArDEeIqvE+eDAAAAAElFTkSuQmCC","views":[],"inPorts":[{"objectClass":"org.knime.database.port.DBDataPortObject","color":"66002d","dataType":"DB Data","optional":false,"name":"DB Data to sample","description":"DB Data to apply database sampling."}],"outPorts":[{"objectClass":"org.knime.database.port.DBDataPortObject","color":"66002d","dataType":"DB Data","optional":false,"name":"First DB Data partition (as defined in dialog)","description":"First DB Data partition with sampled rows."},{"objectClass":"org.knime.database.port.DBDataPortObject","color":"66002d","dataType":"DB Data","optional":false,"name":"Second DB Data partition (remaining rows)","description":"Second DB Data partition with sampled rows."}],"dynInPorts":[],"dynOutPorts":[],"additionalSiteInformation":{"url":"https://update.knime.com/analytics-platform/5.12","trusted":true,"enabledByDefault":true,"name":"KNIME Analytics Platform 5.12 Update Site","version":"5.12.0"},"dialog":[{"sectionName":"Options","fields":[{"name":"First partition type","description":"Defines how the size of the first partition is specified: as a percentage of total rows (relative) or as an absolute number of rows.","optional":false},{"name":"Relative size","description":"Specifies the percentage of rows from the input table to be included in the first partition. Must be between 0 and 100 (inclusive).","optional":false},{"name":"Number of rows","description":"Specifies the absolute number of rows to include in the first partition. If the input table contains fewer rows than specified, all rows are placed in the first table, and the second table will be empty.","optional":false},{"name":"Sampling strategy","description":"Determines how rows are selected for the first partition. Strategies include random, stratified, and first rows (sequential).\n<ul><li><b>Random</b> : Randomly selects rows from the input table if the connected database supports random sampling. <b>Note that this method might be very slow for large database tables</b> .</li><li><b>Stratified</b> : Preserves the distribution of values in the selected group column.</li><li><b>First rows</b> : Allows you to select the top-most rows of the input table. <b>Note that the order of the rows depends on the connected database.</b></li></ul>","optional":false},{"name":"Group column","description":"Specifies the column whose value distribution should be preserved in stratified sampling. Ensures both output tables reflect the same distribution of values.","optional":false},{"name":"Fixed random seed","description":"Optional seed value for random or stratified sampling. Using a seed ensures the same rows are selected each time the node is executed. Without a seed, a different random selection will occur each time.","optional":false}]}],"links":[],"kudos":[],"kudosCount":0,"bundleInformation":{"bundleVersion":"5.12.0.v202606171318","bundleName":"KNIME database nodes","bundleSymbolicName":"org.knime.database.nodes","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.database","featureName":"KNIME Database","featureVersion":"5.12.0.v202606171318","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*0mIkLShcIfCXS7Y-"},"frequentSuccessors":[{"id":"*LRLx-cdMiV7H2TRq","factoryName":"org.knime.database.node.io.reader.DBReaderNodeFactory","probability":1.0}]}