On this page

    Example: Operator Type Mapping

    This section provides sample code used for the Analyzing Profiles examples.

    See Example: Number of Rows and Example: Amount of Consumed Memory for the examples that use this sample mapping information.

    To use the following sample operator type mapping:

    1. Create a file called operator_type.json.
    2. Add the following sample field values (NAME and ID) to the JSON file.

    Note:
    You can simply use cat > operator_type.json and copy/paste the field values.

    {"NAME":"SINGLE_SENDER","ID":0}
    {"NAME":"BROADCAST_SENDER","ID":1}
    {"NAME":"FILTER","ID":2}
    {"NAME":"HASH_AGGREGATE","ID":3}
    {"NAME":"HASH_JOIN","ID":4}
    {"NAME":"MERGE_JOIN","ID":5}
    {"NAME":"HASH_PARTITION_SENDER","ID":6}
    {"NAME":"LIMIT","ID":7}
    {"NAME":"MERGING_RECEIVER","ID":8}
    {"NAME":"ORDERED_PARTITION_SENDER","ID":9}
    {"NAME":"PROJECT","ID":10}
    {"NAME":"UNORDERED_RECEIVER","ID":11}
    {"NAME":"RANGE_SENDER","ID":12}
    {"NAME":"SCREEN","ID":13}
    {"NAME":"SELECTION_VECTOR_REMOVER","ID":14}
    {"NAME":"STREAMING_AGGREGATE","ID":15}
    {"NAME":"TOP_N_SORT","ID":16}
    {"NAME":"EXTERNAL_SORT","ID":17}
    {"NAME":"TRACE","ID":18}
    {"NAME":"UNION","ID":19}
    {"NAME":"OLD_SORT","ID":20}
    {"NAME":"PARQUET_ROW_GROUP_SCAN","ID":21}
    {"NAME":"HIVE_SUB_SCAN","ID":22}
    {"NAME":"SYSTEM_TABLE_SCAN","ID":23}
    {"NAME":"MOCK_SUB_SCAN","ID":24}
    {"NAME":"PARQUET_WRITER","ID":25}
    {"NAME":"DIRECT_SUB_SCAN","ID":26}
    {"NAME":"TEXT_WRITER","ID":27}
    {"NAME":"TEXT_SUB_SCAN","ID":28}
    {"NAME":"JSON_SUB_SCAN","ID":29}
    {"NAME":"INFO_SCHEMA_SUB_SCAN","ID":30}
    {"NAME":"COMPLEX_TO_JSON","ID":31}
    {"NAME":"PRODUCER_CONSUMER","ID":32}
    {"NAME":"HBASE_SUB_SCAN","ID":33}
    {"NAME":"WINDOW","ID":34}
    {"NAME":"NESTED_LOOP_JOIN","ID":35}
    {"NAME":"AVRO_SUB_SCAN","ID":36}
    {"NAME":"MONGO_SUB_SCAN","ID":37}
    {"NAME":"ELASTICSEARCH_SUB_SCAN","ID":38}
    {"NAME":"ELASTICSEARCH_AGGREGATOR_SUB_SCAN","ID":39}
    {"NAME":"FLATTEN","ID":40}
    {"NAME":"EXCEL_SUB_SCAN","ID":41}
    {"NAME":"ARROW_SUB_SCAN","ID":42}
    {"NAME":"ARROW_WRITER","ID":43}
    {"NAME":"JSON_WRITER","ID":44}
    {"NAME":"VALUES_READER","ID":45}
    {"NAME":"CONVERT_FROM_JSON","ID":46}
    {"NAME":"JDBC_SUB_SCAN","ID":47}
    {"NAME":"DICTIONARY_LOOKUP","ID":48}
    {"NAME":"WRITER_COMMITTER","ID":49}
    {"NAME":"ROUND_ROBIN_SENDER","ID":50}
    

    For More Information