mcvsubbu commented on a change in pull request #3975: ReadTheDocs documentation for Table Configs, Monitoring, and Deployment URL: https://github.com/apache/incubator-pinot/pull/3975#discussion_r267899010
########## File path: docs/tableconfig_schema.rst ########## @@ -0,0 +1,204 @@ +.. +.. Licensed to the Apache Software Foundation (ASF) under one +.. or more contributor license agreements. See the NOTICE file +.. distributed with this work for additional information +.. regarding copyright ownership. The ASF licenses this file +.. to you under the Apache License, Version 2.0 (the +.. "License"); you may not use this file except in compliance +.. with the License. You may obtain a copy of the License at +.. +.. http://www.apache.org/licenses/LICENSE-2.0 +.. +.. Unless required by applicable law or agreed to in writing, +.. software distributed under the License is distributed on an +.. "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY +.. KIND, either express or implied. See the License for the +.. specific language governing permissions and limitations +.. under the License. +.. + +Table Config +============ + +Table Config +------------- + +Introduction +~~~~~~~~~~~~ + +Using tables is how Pinot serves and organizes data. There are many settings in the table config which will influence how Pinot operates. The first and most significant distinction is using an offline versus a realtime table. + +An offline table in Pinot is used to host data which might be periodically uploaded - daily, weekly, etc. A realtime table, however, is used to consume data from incoming data streams and serve this data in a near-realtime manner. This might also be referred to as nearline or just plain 'realtime'. + +In this section a sample table configuration will be shown and all sections will be explained and if applicable have appropriate sections linked to for further explanation of those corresponding Pinot features. + +Sample table config and descriptions +~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + +A sample table config is shown below which has sub-sections collasped. The sub sections will be described individually in following sections. + +The ``tableName`` should only contain alpha-numeric characters, hyphens ('-'), or underscores ('_'). Though using a double-underscore ('__') is not allowed and reserved for other features within Pinot. + +The ``tableType`` will indicate the type of the table, ``OFFLINE`` or ``REALTIME``. There are some settings specific to each type. This differentiation will be called out below as options are explained. + +.. code-block:: none + + { + "tableName": "myPinotTable", + "tableType": "REALTIME" + "segmentsConfig": {}, + "tableIndexConfig": {}, + "tenants": {}, + "routing": {}, + "task": {}, + "metadata": {} + } + +Segments Config Section +~~~~~~~~~~~~~~~~~~~~~~~ + +The ``segmentsConfig`` section has information about configuring the following: + +* Segment Retention - with the ``retentionTimeUnit`` and ``retentionTimeValue`` options. + + * Allowed values: + + * ``retentionTimeUnit`` - ``DAYS`` + * ``retentionTimeValue`` - Positive integers + +* ``segmentPushFrequency`` - to indicate how frequently segments are uploaded. + + * Allowed values - ``daily``, ``hourly`` + +* ``segmentPushType`` - Indicates the type of push to the table. + + * Allowed values - ``APPEND`` means new data will be pushed and appended to the current data in the table, all realtime tables *must* be ``APPEND``. ``REFRESH`` will refresh the entire dataset contained within the table. + +* ``replication`` - Number of replicas of data in a table, used for offline tables only. + + * Allowed values - Positive integers + +* ``replicasPerPartition`` - Number of of data in a table, used for offline tables only. + + * Allowed values - Positive integers + +* ``schemaName`` - Name of the schema that's been uploaded to the controller + + * Allowed values - String + +* Time column - using ``timeColumnName`` and ``timeType``, this must match what's configured in the preceeding schema + + * Allowed values - String, this must match the ``timeFieldSpec`` section in the schema + +* Segment assignment strategy - Described more on the page `Customizing Pinot <customizations.html#segment-assignment-strategies>`_ + + +.. code-block:: none + + "segmentsConfig": { + "retentionTimeUnit": "DAYS", + "retentionTimeValue": "5", + "segmentPushFrequency": "daily", + "segmentPushType": "APPEND", + "replication": "3", + "replicasPerPartition": "3", + "schemaName": "myPinotSchmea", + "timeColumnName": "daysSinceEpoch", + "timeType": "DAYS", + "segmentAssignmentStrategy": "BalanceNumSegmentAssignmentStrategy" + }, + +Table Index Config Section +~~~~~~~~~~~~~~~~~~~~~~~~~~ + +The ``tableIndexConfig`` section has information about how to configure: + +* ``invertedIndexColumns`` - Indicates a list of real column names as specified in the schema to create inverted indexes for. More info on indexes can be found on the `Index Techniques <index_techniques.html>`_ page. + + * Allowed values - String; string must match the column name in the corresponding schema + +* ``noDictionaryColumns`` - Indicates a list of real column names as specified in the schema. Column names present will **not** have a dictionary created. More info on indexes can be found on the `Index Techniques <index_techniques.html>`_ page. + + * Allowed values - String; string must match the column name in the corresponding schema + +* ``sortedColumn`` - Indicates a list of real column names as specified in the schema. Data should be sorted based on the column names provided. More info on indexes can be found on the `Index Techniques <index_techniques.html>`_ page. + + * Allowed values - String; string must match the column name in the corresponding schema + +* ``aggregateMetrics`` - Switch for the aggregate metrics feature. This feature will aggregate realtime stream data as it is consumed, where applicable, in order to reduce segment sizes. This feature is only available on REALTIME tables. + + * Allowed values - ``true`` to enable, ``false`` to disable. + +* ``segmentPartitionConfig`` - Cofigures the Data Partitioning Strategy. Further documentation on this feather available in the `Data Partitioning Strategies <customizations.html#data-partitioning-strategies>`_ section. +* ``loadMode`` - indicates how data will be loaded on pinot-server. either ``"MMAP"`` or ``"HEAP"`` can be configured. + + * Allowed values: + + * ``MMAP`` - Configures pinot-server to load data segments to off-heap memory. + * ``HEAP`` - Configures pinot-server to load data directly into heap memory. Review comment: Unfortunate misnomer of HEAP. It actually loads segment into direct memory, not heap memory ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For additional commands, e-mail: commits-h...@pinot.apache.org