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.

Sample field values for operator type mapping

{"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}