Hi
Here is the stacktrace on the server side
error_type: SYSTEM
message: "SYSTEM ERROR: ClassCastException:
org.apache.drill.exec.vector.NullableDecimal28SparseVector cannot be cast to
org.apache.drill.exec.vector.VariableWidthVector\n\nFragment 2:8\n\n[Error Id:
b144b650-99c3-4305-880f-d3a6794a2eab on BGDTEST3.INTERSWITCH.COM:31010]"
exception {
exception_class:
"org.apache.drill.common.exceptions.DrillRuntimeException"
message: "Error in parquet record reader.\nMessage: Failure in setting up
reader\nParquet Metadata: ParquetMetaData{FileMetaData{schema: message
postillion_data_schema_generator.postillion_super_switch_schema {\n optional
int64 post_tran_id;\n optional int64 post_tran_cust_id;\n optional int32
settle_entity_id;\n optional int32 batch_nr;\n optional int64
prev_post_tran_id;\n optional int64 next_post_tran_id;\n optional binary
sink_node_name (UTF8);\n optional binary tran_postilion_originated
(DECIMAL(1,0));\n optional binary tran_completed (DECIMAL(1,0));\n optional
binary message_type (UTF8);\n optional binary tran_type (UTF8);\n optional
int64 tran_nr;\n optional binary system_trace_audit_nr (UTF8);\n optional
binary rsp_code_req (UTF8);\n optional binary rsp_code_rsp (UTF8);\n optional
binary abort_rsp_code (UTF8);\n optional binary auth_id_rsp (UTF8);\n
optional binary auth_type (DECIMAL(1,0));\n optional binary auth_reason
(DECIMAL(1,0));\n optional binary retention_data (UTF8);\n optional binary
acquiring_inst_id_code (UTF8);\n optional binary message_reason_code (UTF8);\n
optional binary sponsor_bank (UTF8);\n optional binary retrieval_reference_nr
(UTF8);\n optional int64 datetime_tran_gmt (TIMESTAMP_MILLIS);\n optional
int64 datetime_tran_local (TIMESTAMP_MILLIS);\n optional int64 datetime_req
(TIMESTAMP_MILLIS);\n optional int64 datetime_rsp (TIMESTAMP_MILLIS);\n
optional int64 realtime_business_date (TIMESTAMP_MILLIS);\n optional int64
recon_business_date (TIMESTAMP_MILLIS);\n optional binary from_account_type
(UTF8);\n optional binary to_account_type (UTF8);\n optional binary
from_account_id (UTF8);\n optional binary to_account_id (UTF8);\n optional
binary tran_amount_req (DECIMAL(16,0));\n optional binary tran_amount_rsp
(DECIMAL(16,0));\n optional binary settle_amount_impact (DECIMAL(16,0));\n
optional binary tran_cash_req (DECIMAL(16,0));\n optional binary tran_cash_rsp
(DECIMAL(16,0));\n optional binary tran_currency_code (UTF8);\n optional
binary tran_tran_fee_req (DECIMAL(16,0));\n optional binary tran_tran_fee_rsp
(DECIMAL(16,0));\n optional binary tran_tran_fee_currency_code (UTF8);\n
optional binary tran_proc_fee_req (DECIMAL(16,0));\n optional binary
tran_proc_fee_rsp (DECIMAL(16,0));\n optional binary
tran_proc_fee_currency_code (UTF8);\n optional binary settle_amount_req
(DECIMAL(16,0));\n optional binary settle_amount_rsp (DECIMAL(16,0));\n
optional binary settle_cash_req (DECIMAL(16,0));\n optional binary
settle_cash_rsp (DECIMAL(16,0));\n optional binary settle_tran_fee_req
(DECIMAL(16,0));\n optional binary settle_tran_fee_rsp (DECIMAL(16,0));\n
optional binary settle_proc_fee_req (DECIMAL(16,0));\n optional binary
settle_proc_fee_rsp (DECIMAL(16,0));\n optional binary settle_currency_code
(UTF8);\n optional binary icc_data_req (UTF8);\n optional binary icc_data_rsp
(UTF8);\n optional binary pos_entry_mode (UTF8);\n optional binary
pos_condition_code (UTF8);\n optional binary additional_rsp_data (UTF8);\n
optional binary structured_data_req (UTF8);\n optional binary
structured_data_rsp (UTF8);\n optional binary tran_reversed (UTF8);\n
optional binary prev_tran_approved (DECIMAL(1,0));\n optional binary
issuer_network_id (UTF8);\n optional binary acquirer_network_id (UTF8);\n
optional binary extended_tran_type (UTF8);\n optional binary ucaf_data
(UTF8);\n optional binary from_account_type_qualifier (UTF8);\n optional
binary to_account_type_qualifier (UTF8);\n optional binary bank_details
(UTF8);\n optional binary payee (UTF8);\n optional binary
card_verification_result (UTF8);\n optional int32 online_system_id;\n
optional int32 participant_id;\n optional int32 opp_participant_id;\n
optional binary receiving_inst_id_code (UTF8);\n optional int32
routing_type;\n optional binary pt_pos_operating_environment (UTF8);\n
optional binary pt_pos_card_input_mode (UTF8);\n optional binary
pt_pos_cardholder_auth_method (UTF8);\n optional binary
pt_pos_pin_capture_ability (UTF8);\n optional binary pt_pos_terminal_operator
(UTF8);\n optional binary source_node_key (UTF8);\n optional int32
proc_online_system_id;\n optional int32 from_account_id_cs;\n optional int32
to_account_id_cs;\n optional binary pos_geographic_data (UTF8);\n optional
binary payer_account_id (UTF8);\n optional binary cvv_available_at_auth
(UTF8);\n optional binary cvv2_available_at_auth (UTF8);\n optional int64
Expr1;\n optional binary source_node_name (UTF8);\n optional int32
draft_capture;\n optional binary pan (UTF8);\n optional binary card_seq_nr
(UTF8);\n optional binary expiry_date (UTF8);\n optional binary
service_restriction_code (UTF8);\n optional binary terminal_id (UTF8);\n
optional binary terminal_owner (UTF8);\n optional binary card_acceptor_id_code
(UTF8);\n optional binary mapped_card_acceptor_id_code (UTF8);\n optional
binary merchant_type (UTF8);\n optional binary card_acceptor_name_loc
(UTF8);\n optional binary address_verification_data (UTF8);\n optional binary
address_verification_result (UTF8);\n optional binary check_data (UTF8);\n
optional binary totals_group (UTF8);\n optional binary card_product (UTF8);\n
optional binary pos_card_data_input_ability (UTF8);\n optional binary
pos_cardholder_auth_ability (UTF8);\n optional binary pos_card_capture_ability
(UTF8);\n optional binary pos_operating_environment (UTF8);\n optional binary
pos_cardholder_present (UTF8);\n optional binary pos_card_present (UTF8);\n
optional binary pos_card_data_input_mode (UTF8);\n optional binary
pos_cardholder_auth_method (UTF8);\n optional binary
pos_cardholder_auth_entity (UTF8);\n optional binary
pos_card_data_output_ability (UTF8);\n optional binary
pos_terminal_output_ability (UTF8);\n optional binary pos_pin_capture_ability
(UTF8);\n optional binary pos_terminal_operator (UTF8);\n optional binary
pos_terminal_type (UTF8);\n optional int32 pan_search;\n optional binary
pan_encrypted (UTF8);\n optional binary pan_reference (UTF8);\n optional
int32 card_acceptor_id_code_cs;\n}\n, metadata:
{parquet.avro.schema={\"type\":\"record\",\"name\":\"postillion_super_switch_schema\",\"namespace\":\"postillion_data_schema_generator\",\"doc\":\"Schema
For Postillion
Records\",\"fields\":[{\"name\":\"post_tran_id\",\"type\":[\"null\",\"long\"],\"default\":null},{\"name\":\"post_tran_cust_id\",\"type\":[\"null\",\"long\"],\"default\":null},{\"name\":\"settle_entity_id\",\"type\":[\"null\",\"int\"],\"default\":null},{\"name\":\"batch_nr\",\"type\":[\"null\",\"int\"],\"default\":null},{\"name\":\"prev_post_tran_id\",\"type\":[\"null\",\"long\"],\"default\":null},{\"name\":\"next_post_tran_id\",\"type\":[\"null\",\"long\"],\"default\":null},{\"name\":\"sink_node_name\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"tran_postilion_originated\",\"type\":[\"null\",{\"type\":\"bytes\",\"logicalType\":\"decimal\",\"precision\":1,\"scale\":0}],\"default\":null},{\"name\":\"tran_completed\",\"type\":[\"null\",{\"type\":\"bytes\",\"logicalType\":\"decimal\",\"precision\":1,\"scale\":0}],\"default\":null},{\"name\":\"message_type\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"tran_type\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"tran_nr\",\"type\":[\"null\",\"long\"],\"default\":null},{\"name\":\"system_trace_audit_nr\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"rsp_code_req\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"rsp_code_rsp\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"abort_rsp_code\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"auth_id_rsp\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"auth_type\",\"type\":[\"null\",{\"type\":\"bytes\",\"logicalType\":\"decimal\",\"precision\":1,\"scale\":0}],\"default\":null},{\"name\":\"auth_reason\",\"type\":[\"null\",{\"type\":\"bytes\",\"logicalType\":\"decimal\",\"precision\":1,\"scale\":0}],\"default\":null},{\"name\":\"retention_data\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"acquiring_inst_id_code\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"message_reason_code\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"sponsor_bank\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"retrieval_reference_nr\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"datetime_tran_gmt\",\"type\":[\"null\",{\"type\":\"long\",\"logicalType\":\"timestamp-millis\"}],\"default\":null},{\"name\":\"datetime_tran_local\",\"type\":[\"null\",{\"type\":\"long\",\"logicalType\":\"timestamp-millis\"}],\"default\":null},{\"name\":\"datetime_req\",\"type\":[\"null\",{\"type\":\"long\",\"logicalType\":\"timestamp-millis\"}],\"default\":null},{\"name\":\"datetime_rsp\",\"type\":[\"null\",{\"type\":\"long\",\"logicalType\":\"timestamp-millis\"}],\"default\":null},{\"name\":\"realtime_business_date\",\"type\":[\"null\",{\"type\":\"long\",\"logicalType\":\"timestamp-millis\"}],\"default\":null},{\"name\":\"recon_business_date\",\"type\":[\"null\",{\"type\":\"long\",\"logicalType\":\"timestamp-millis\"}],\"default\":null},{\"name\":\"from_account_type\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"to_account_type\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"from_account_id\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"to_account_id\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"tran_amount_req\",\"type\":[\"null\",{\"type\":\"bytes\",\"logicalType\":\"decimal\",\"precision\":16,\"scale\":0}],\"default\":null},{\"name\":\"tran_amount_rsp\",\"type\":[\"null\",{\"type\":\"bytes\",\"logicalType\":\"decimal\",\"precision\":16,\"scale\":0}],\"default\":null},{\"name\":\"settle_amount_impact\",\"type\":[\"null\",{\"type\":\"bytes\",\"logicalType\":\"decimal\",\"precision\":16,\"scale\":0}],\"default\":null},{\"name\":\"tran_cash_req\",\"type\":[\"null\",{\"type\":\"bytes\",\"logicalType\":\"decimal\",\"precision\":16,\"scale\":0}],\"default\":null},{\"name\":\"tran_cash_rsp\",\"type\":[\"null\",{\"type\":\"bytes\",\"logicalType\":\"decimal\",\"precision\":16,\"scale\":0}],\"default\":null},{\"name\":\"tran_currency_code\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"tran_tran_fee_req\",\"type\":[\"null\",{\"type\":\"bytes\",\"logicalType\":\"decimal\",\"precision\":16,\"scale\":0}],\"default\":null},{\"name\":\"tran_tran_fee_rsp\",\"type\":[\"null\",{\"type\":\"bytes\",\"logicalType\":\"decimal\",\"precision\":16,\"scale\":0}],\"default\":null},{\"name\":\"tran_tran_fee_currency_code\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"tran_proc_fee_req\",\"type\":[\"null\",{\"type\":\"bytes\",\"logicalType\":\"decimal\",\"precision\":16,\"scale\":0}],\"default\":null},{\"name\":\"tran_proc_fee_rsp\",\"type\":[\"null\",{\"type\":\"bytes\",\"logicalType\":\"decimal\",\"precision\":16,\"scale\":0}],\"default\":null},{\"name\":\"tran_proc_fee_currency_code\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"settle_amount_req\",\"type\":[\"null\",{\"type\":\"bytes\",\"logicalType\":\"decimal\",\"precision\":16,\"scale\":0}],\"default\":null},{\"name\":\"settle_amount_rsp\",\"type\":[\"null\",{\"type\":\"bytes\",\"logicalType\":\"decimal\",\"precision\":16,\"scale\":0}],\"default\":null},{\"name\":\"settle_cash_req\",\"type\":[\"null\",{\"type\":\"bytes\",\"logicalType\":\"decimal\",\"precision\":16,\"scale\":0}],\"default\":null},{\"name\":\"settle_cash_rsp\",\"type\":[\"null\",{\"type\":\"bytes\",\"logicalType\":\"decimal\",\"precision\":16,\"scale\":0}],\"default\":null},{\"name\":\"settle_tran_fee_req\",\"type\":[\"null\",{\"type\":\"bytes\",\"logicalType\":\"decimal\",\"precision\":16,\"scale\":0}],\"default\":null},{\"name\":\"settle_tran_fee_rsp\",\"type\":[\"null\",{\"type\":\"bytes\",\"logicalType\":\"decimal\",\"precision\":16,\"scale\":0}],\"default\":null},{\"name\":\"settle_proc_fee_req\",\"type\":[\"null\",{\"type\":\"bytes\",\"logicalType\":\"decimal\",\"precision\":16,\"scale\":0}],\"default\":null},{\"name\":\"settle_proc_fee_rsp\",\"type\":[\"null\",{\"type\":\"bytes\",\"logicalType\":\"decimal\",\"precision\":16,\"scale\":0}],\"default\":null},{\"name\":\"settle_currency_code\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"icc_data_req\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"icc_data_rsp\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"pos_entry_mode\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"pos_condition_code\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"additional_rsp_data\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"structured_data_req\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"structured_data_rsp\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"tran_reversed\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"prev_tran_approved\",\"type\":[\"null\",{\"type\":\"bytes\",\"logicalType\":\"decimal\",\"precision\":1,\"scale\":0}],\"default\":null},{\"name\":\"issuer_network_id\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"acquirer_network_id\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"extended_tran_type\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"ucaf_data\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"from_account_type_qualifier\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"to_account_type_qualifier\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"bank_details\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"payee\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"card_verification_result\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"online_system_id\",\"type\":[\"null\",\"int\"],\"default\":null},{\"name\":\"participant_id\",\"type\":[\"null\",\"int\"],\"default\":null},{\"name\":\"opp_participant_id\",\"type\":[\"null\",\"int\"],\"default\":null},{\"name\":\"receiving_inst_id_code\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"routing_type\",\"type\":[\"null\",\"int\"],\"default\":null},{\"name\":\"pt_pos_operating_environment\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"pt_pos_card_input_mode\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"pt_pos_cardholder_auth_method\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"pt_pos_pin_capture_ability\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"pt_pos_terminal_operator\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"source_node_key\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"proc_online_system_id\",\"type\":[\"null\",\"int\"],\"default\":null},{\"name\":\"from_account_id_cs\",\"type\":[\"null\",\"int\"],\"default\":null},{\"name\":\"to_account_id_cs\",\"type\":[\"null\",\"int\"],\"default\":null},{\"name\":\"pos_geographic_data\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"payer_account_id\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"cvv_available_at_auth\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"cvv2_available_at_auth\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"Expr1\",\"type\":[\"null\",\"long\"],\"default\":null},{\"name\":\"source_node_name\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"draft_capture\",\"type\":[\"null\",\"int\"],\"default\":null},{\"name\":\"pan\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"card_seq_nr\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"expiry_date\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"service_restriction_code\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"terminal_id\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"terminal_owner\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"card_acceptor_id_code\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"mapped_card_acceptor_id_code\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"merchant_type\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"card_acceptor_name_loc\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"address_verification_data\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"address_verification_result\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"check_data\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"totals_group\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"card_product\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"pos_card_data_input_ability\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"pos_cardholder_auth_ability\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"pos_card_capture_ability\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"pos_operating_environment\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"pos_cardholder_present\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"pos_card_present\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"pos_card_data_input_mode\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"pos_cardholder_auth_method\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"pos_cardholder_auth_entity\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"pos_card_data_output_ability\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"pos_terminal_output_ability\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"pos_pin_capture_ability\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"pos_terminal_operator\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"pos_terminal_type\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"pan_search\",\"type\":[\"null\",\"int\"],\"default\":null},{\"name\":\"pan_encrypted\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"pan_reference\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"card_acceptor_id_code_cs\",\"type\":[\"null\",\"int\"],\"default\":null}]}}},
blocks: [BlockMetaData{201242, 390831772 [ColumnMetaData{SNAPPY [post_tran_id]
INT64 [PLAIN, BIT_PACKED, RLE], 4}, ColumnMetaData{SNAPPY [post_tran_cust_id]
INT64 [PLAIN, BIT_PACKED, RLE], 809044}, ColumnMetaData{SNAPPY
[settle_entity_id] INT32 [PLAIN_DICTIONARY, BIT_PACKED, RLE], 1548568},
ColumnMetaData{SNAPPY [batch_nr] INT32 [PLAIN_DICTIONARY, BIT_PACKED, RLE],
1751012}, ColumnMetaData{SNAPPY [prev_post_tran_id] INT64 [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 1793896}, ColumnMetaData{SNAPPY [next_post_tran_id] INT64
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 1815087}, ColumnMetaData{SNAPPY
[sink_node_name] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 1843167},
ColumnMetaData{SNAPPY [tran_postilion_originated] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 2020759}, ColumnMetaData{SNAPPY [tran_completed] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 2046694}, ColumnMetaData{SNAPPY
[message_type] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 2046757},
ColumnMetaData{SNAPPY [tran_type] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
2080697}, ColumnMetaData{SNAPPY [tran_nr] INT64 [PLAIN, BIT_PACKED, RLE],
2170196}, ColumnMetaData{SNAPPY [system_trace_audit_nr] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 2910433}, ColumnMetaData{SNAPPY
[rsp_code_req] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 3586041},
ColumnMetaData{SNAPPY [rsp_code_rsp] BINARY [PLAIN_DICTIONARY, BIT_PACKED,
RLE], 3590301}, ColumnMetaData{SNAPPY [abort_rsp_code] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 3645196}, ColumnMetaData{SNAPPY
[auth_id_rsp] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 3645422},
ColumnMetaData{SNAPPY [auth_type] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
4193054}, ColumnMetaData{SNAPPY [auth_reason] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 4229217}, ColumnMetaData{SNAPPY [retention_data] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 4269816}, ColumnMetaData{SNAPPY
[acquiring_inst_id_code] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 4278454},
ColumnMetaData{SNAPPY [message_reason_code] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 4430219}, ColumnMetaData{SNAPPY [sponsor_bank] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 4452290}, ColumnMetaData{SNAPPY
[retrieval_reference_nr] BINARY [PLAIN_DICTIONARY, PLAIN, BIT_PACKED, RLE],
4542585}, ColumnMetaData{SNAPPY [datetime_tran_gmt] INT64 [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 5694340}, ColumnMetaData{SNAPPY [datetime_tran_local] INT64
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 6159949}, ColumnMetaData{SNAPPY
[datetime_req] INT64 [PLAIN, BIT_PACKED, RLE], 6592927}, ColumnMetaData{SNAPPY
[datetime_rsp] INT64 [PLAIN, BIT_PACKED, RLE], 7412242}, ColumnMetaData{SNAPPY
[realtime_business_date] INT64 [PLAIN_DICTIONARY, BIT_PACKED, RLE], 8181077},
ColumnMetaData{SNAPPY [recon_business_date] INT64 [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 8190233}, ColumnMetaData{SNAPPY [from_account_type] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 8199389}, ColumnMetaData{SNAPPY
[to_account_type] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 8249473},
ColumnMetaData{SNAPPY [from_account_id] BINARY [PLAIN_DICTIONARY, BIT_PACKED,
RLE], 8287589}, ColumnMetaData{SNAPPY [to_account_id] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 9295975}, ColumnMetaData{SNAPPY
[tran_amount_req] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 9437696},
ColumnMetaData{SNAPPY [tran_amount_rsp] BINARY [PLAIN_DICTIONARY, BIT_PACKED,
RLE], 9723913}, ColumnMetaData{SNAPPY [settle_amount_impact] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 9995831}, ColumnMetaData{SNAPPY
[tran_cash_req] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 10271557},
ColumnMetaData{SNAPPY [tran_cash_rsp] BINARY [PLAIN_DICTIONARY, BIT_PACKED,
RLE], 10359560}, ColumnMetaData{SNAPPY [tran_currency_code] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 10440855}, ColumnMetaData{SNAPPY
[tran_tran_fee_req] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 10441679},
ColumnMetaData{SNAPPY [tran_tran_fee_rsp] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 10508097}, ColumnMetaData{SNAPPY
[tran_tran_fee_currency_code] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
10569370}, ColumnMetaData{SNAPPY [tran_proc_fee_req] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 10570194}, ColumnMetaData{SNAPPY [tran_proc_fee_rsp] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 10570257}, ColumnMetaData{SNAPPY
[tran_proc_fee_currency_code] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
10570320}, ColumnMetaData{SNAPPY [settle_amount_req] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 10571144}, ColumnMetaData{SNAPPY [settle_amount_rsp] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 10857364}, ColumnMetaData{SNAPPY
[settle_cash_req] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 11129282},
ColumnMetaData{SNAPPY [settle_cash_rsp] BINARY [PLAIN_DICTIONARY, BIT_PACKED,
RLE], 11217276}, ColumnMetaData{SNAPPY [settle_tran_fee_req] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 11298571}, ColumnMetaData{SNAPPY
[settle_tran_fee_rsp] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 11364986},
ColumnMetaData{SNAPPY [settle_proc_fee_req] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 11426259}, ColumnMetaData{SNAPPY [settle_proc_fee_rsp] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 11426322}, ColumnMetaData{SNAPPY
[settle_currency_code] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 11426385},
ColumnMetaData{SNAPPY [icc_data_req] BINARY [PLAIN_DICTIONARY, PLAIN,
BIT_PACKED, RLE], 11427214}, ColumnMetaData{SNAPPY [icc_data_rsp] BINARY
[PLAIN_DICTIONARY, PLAIN, BIT_PACKED, RLE], 26518941}, ColumnMetaData{SNAPPY
[pos_entry_mode] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 30534208},
ColumnMetaData{SNAPPY [pos_condition_code] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 30590166}, ColumnMetaData{SNAPPY [additional_rsp_data] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 30637680}, ColumnMetaData{SNAPPY
[structured_data_req] BINARY [PLAIN_DICTIONARY, PLAIN, BIT_PACKED, RLE],
30648755}, ColumnMetaData{SNAPPY [structured_data_rsp] BINARY
[PLAIN_DICTIONARY, PLAIN, BIT_PACKED, RLE], 52283822}, ColumnMetaData{SNAPPY
[tran_reversed] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 56471047},
ColumnMetaData{SNAPPY [prev_tran_approved] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 56476906}, ColumnMetaData{SNAPPY [issuer_network_id] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 56478722}, ColumnMetaData{SNAPPY
[acquirer_network_id] BINARY [PLAIN, BIT_PACKED, RLE], 56488186},
ColumnMetaData{SNAPPY [extended_tran_type] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 56488221}, ColumnMetaData{SNAPPY [ucaf_data] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 56537184}, ColumnMetaData{SNAPPY
[from_account_type_qualifier] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
56553417}, ColumnMetaData{SNAPPY [to_account_type_qualifier] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 56554148}, ColumnMetaData{SNAPPY
[bank_details] BINARY [PLAIN_DICTIONARY, PLAIN, BIT_PACKED, RLE], 56554851},
ColumnMetaData{SNAPPY [payee] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
56937031}, ColumnMetaData{SNAPPY [card_verification_result] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 57301733}, ColumnMetaData{SNAPPY
[online_system_id] INT32 [PLAIN_DICTIONARY, BIT_PACKED, RLE], 57353524},
ColumnMetaData{SNAPPY [participant_id] INT32 [PLAIN, BIT_PACKED, RLE],
57353652}, ColumnMetaData{SNAPPY [opp_participant_id] INT32 [PLAIN,
BIT_PACKED, RLE], 57353687}, ColumnMetaData{SNAPPY [receiving_inst_id_code]
BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 57353722}, ColumnMetaData{SNAPPY
[routing_type] INT32 [PLAIN, BIT_PACKED, RLE], 57412965},
ColumnMetaData{SNAPPY [pt_pos_operating_environment] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 57413000}, ColumnMetaData{SNAPPY [pt_pos_card_input_mode]
BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 57487229}, ColumnMetaData{SNAPPY
[pt_pos_cardholder_auth_method] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
57546228}, ColumnMetaData{SNAPPY [pt_pos_pin_capture_ability] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 57593437}, ColumnMetaData{SNAPPY
[pt_pos_terminal_operator] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
57655016}, ColumnMetaData{SNAPPY [source_node_key] BINARY [PLAIN_DICTIONARY,
PLAIN, BIT_PACKED, RLE], 57705855}, ColumnMetaData{SNAPPY
[proc_online_system_id] INT32 [PLAIN_DICTIONARY, BIT_PACKED, RLE], 60196708},
ColumnMetaData{SNAPPY [from_account_id_cs] INT32 [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 60196836}, ColumnMetaData{SNAPPY [to_account_id_cs] INT32
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 60836161}, ColumnMetaData{SNAPPY
[pos_geographic_data] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 60938316},
ColumnMetaData{SNAPPY [payer_account_id] BINARY [PLAIN_DICTIONARY, BIT_PACKED,
RLE], 61038748}, ColumnMetaData{SNAPPY [cvv_available_at_auth] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 61090238}, ColumnMetaData{SNAPPY
[cvv2_available_at_auth] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
61118701}, ColumnMetaData{SNAPPY [Expr1] INT64 [PLAIN, BIT_PACKED, RLE],
61146623}, ColumnMetaData{SNAPPY [source_node_name] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 61886147}, ColumnMetaData{SNAPPY [draft_capture] INT32
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 62063374}, ColumnMetaData{SNAPPY [pan]
BINARY [PLAIN_DICTIONARY, PLAIN, BIT_PACKED, RLE], 62063442},
ColumnMetaData{SNAPPY [card_seq_nr] BINARY [PLAIN_DICTIONARY, BIT_PACKED,
RLE], 62877776}, ColumnMetaData{SNAPPY [expiry_date] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 62953509}, ColumnMetaData{SNAPPY [service_restriction_code]
BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 63130555}, ColumnMetaData{SNAPPY
[terminal_id] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 63204670},
ColumnMetaData{SNAPPY [terminal_owner] BINARY [PLAIN_DICTIONARY, BIT_PACKED,
RLE], 63707720}, ColumnMetaData{SNAPPY [card_acceptor_id_code] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 63806530}, ColumnMetaData{SNAPPY
[mapped_card_acceptor_id_code] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
64321730}, ColumnMetaData{SNAPPY [merchant_type] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 64836999}, ColumnMetaData{SNAPPY [card_acceptor_name_loc]
BINARY [PLAIN_DICTIONARY, PLAIN, BIT_PACKED, RLE], 64985089},
ColumnMetaData{SNAPPY [address_verification_data] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 67712030}, ColumnMetaData{SNAPPY
[address_verification_result] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
67718569}, ColumnMetaData{SNAPPY [check_data] BINARY [PLAIN, BIT_PACKED, RLE],
67725108}, ColumnMetaData{SNAPPY [totals_group] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 67725143}, ColumnMetaData{SNAPPY [card_product] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 67902704}, ColumnMetaData{SNAPPY
[pos_card_data_input_ability] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
68090795}, ColumnMetaData{SNAPPY [pos_cardholder_auth_ability] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 68146727}, ColumnMetaData{SNAPPY
[pos_card_capture_ability] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
68193601}, ColumnMetaData{SNAPPY [pos_operating_environment] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 68220478}, ColumnMetaData{SNAPPY
[pos_cardholder_present] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
68294707}, ColumnMetaData{SNAPPY [pos_card_present] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 68341958}, ColumnMetaData{SNAPPY [pos_card_data_input_mode]
BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 68370435}, ColumnMetaData{SNAPPY
[pos_cardholder_auth_method] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
68429434}, ColumnMetaData{SNAPPY [pos_cardholder_auth_entity] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 68476643}, ColumnMetaData{SNAPPY
[pos_card_data_output_ability] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
68548437}, ColumnMetaData{SNAPPY [pos_terminal_output_ability] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 68597898}, ColumnMetaData{SNAPPY
[pos_pin_capture_ability] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
68644913}, ColumnMetaData{SNAPPY [pos_terminal_operator] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 68706492}, ColumnMetaData{SNAPPY
[pos_terminal_type] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 68757331},
ColumnMetaData{SNAPPY [pan_search] INT32 [PLAIN_DICTIONARY, BIT_PACKED, RLE],
68832334}, ColumnMetaData{SNAPPY [pan_encrypted] BINARY [PLAIN_DICTIONARY,
PLAIN, BIT_PACKED, RLE], 69224991}, ColumnMetaData{SNAPPY [pan_reference]
BINARY [PLAIN_DICTIONARY, PLAIN, BIT_PACKED, RLE], 70980051},
ColumnMetaData{SNAPPY [card_acceptor_id_code_cs] INT32 [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 75536315}]}, BlockMetaData{253602, 466628801
[ColumnMetaData{SNAPPY [post_tran_id] INT64 [PLAIN, BIT_PACKED, RLE],
75949384}, ColumnMetaData{SNAPPY [post_tran_cust_id] INT64 [PLAIN, BIT_PACKED,
RLE], 76968681}, ColumnMetaData{SNAPPY [settle_entity_id] INT32
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 77900833}, ColumnMetaData{SNAPPY
[batch_nr] INT32 [PLAIN_DICTIONARY, BIT_PACKED, RLE], 78155811},
ColumnMetaData{SNAPPY [prev_post_tran_id] INT64 [PLAIN_DICTIONARY, BIT_PACKED,
RLE], 78198480}, ColumnMetaData{SNAPPY [next_post_tran_id] INT64
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 78239553}, ColumnMetaData{SNAPPY
[sink_node_name] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 78292345},
ColumnMetaData{SNAPPY [tran_postilion_originated] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 78515888}, ColumnMetaData{SNAPPY [tran_completed] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 78548595}, ColumnMetaData{SNAPPY
[message_type] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 78548701},
ColumnMetaData{SNAPPY [tran_type] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
78590669}, ColumnMetaData{SNAPPY [tran_nr] INT64 [PLAIN, BIT_PACKED, RLE],
78700903}, ColumnMetaData{SNAPPY [system_trace_audit_nr] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 79634251}, ColumnMetaData{SNAPPY
[rsp_code_req] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 80495548},
ColumnMetaData{SNAPPY [rsp_code_rsp] BINARY [PLAIN_DICTIONARY, BIT_PACKED,
RLE], 80502561}, ColumnMetaData{SNAPPY [abort_rsp_code] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 80581613}, ColumnMetaData{SNAPPY
[auth_id_rsp] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 80581974},
ColumnMetaData{SNAPPY [auth_type] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
81250767}, ColumnMetaData{SNAPPY [auth_reason] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 81297416}, ColumnMetaData{SNAPPY [retention_data] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 81351647}, ColumnMetaData{SNAPPY
[acquiring_inst_id_code] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
81360510}, ColumnMetaData{SNAPPY [message_reason_code] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 81551669}, ColumnMetaData{SNAPPY
[sponsor_bank] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 81582920},
ColumnMetaData{SNAPPY [retrieval_reference_nr] BINARY [PLAIN_DICTIONARY,
PLAIN, BIT_PACKED, RLE], 81689713}, ColumnMetaData{SNAPPY [datetime_tran_gmt]
INT64 [PLAIN_DICTIONARY, BIT_PACKED, RLE], 83137920}, ColumnMetaData{SNAPPY
[datetime_tran_local] INT64 [PLAIN_DICTIONARY, BIT_PACKED, RLE], 83776829},
ColumnMetaData{SNAPPY [datetime_req] INT64 [PLAIN, BIT_PACKED, RLE],
84387849}, ColumnMetaData{SNAPPY [datetime_rsp] INT64 [PLAIN, BIT_PACKED,
RLE], 85432012}, ColumnMetaData{SNAPPY [realtime_business_date] INT64
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 86413161}, ColumnMetaData{SNAPPY
[recon_business_date] INT64 [PLAIN_DICTIONARY, BIT_PACKED, RLE], 86414857},
ColumnMetaData{SNAPPY [from_account_type] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 86416553}, ColumnMetaData{SNAPPY [to_account_type] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 86496204}, ColumnMetaData{SNAPPY
[from_account_id] BINARY [PLAIN_DICTIONARY, PLAIN, BIT_PACKED, RLE],
86543880}, ColumnMetaData{SNAPPY [to_account_id] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 87879090}, ColumnMetaData{SNAPPY [tran_amount_req] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 88065864}, ColumnMetaData{SNAPPY
[tran_amount_rsp] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 88444414},
ColumnMetaData{SNAPPY [settle_amount_impact] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 88786230}, ColumnMetaData{SNAPPY [tran_cash_req] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 89144843}, ColumnMetaData{SNAPPY
[tran_cash_rsp] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 89246897},
ColumnMetaData{SNAPPY [tran_currency_code] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 89338616}, ColumnMetaData{SNAPPY [tran_tran_fee_req] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 89339466}, ColumnMetaData{SNAPPY
[tran_tran_fee_rsp] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 89424325},
ColumnMetaData{SNAPPY [tran_tran_fee_currency_code] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 89501966}, ColumnMetaData{SNAPPY [tran_proc_fee_req] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 89502816}, ColumnMetaData{SNAPPY
[tran_proc_fee_rsp] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 89502922},
ColumnMetaData{SNAPPY [tran_proc_fee_currency_code] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 89503028}, ColumnMetaData{SNAPPY [settle_amount_req] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 89503878}, ColumnMetaData{SNAPPY
[settle_amount_rsp] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 89882315},
ColumnMetaData{SNAPPY [settle_cash_req] BINARY [PLAIN_DICTIONARY, BIT_PACKED,
RLE], 90224131}, ColumnMetaData{SNAPPY [settle_cash_rsp] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 90326155}, ColumnMetaData{SNAPPY
[settle_tran_fee_req] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 90417874},
ColumnMetaData{SNAPPY [settle_tran_fee_rsp] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 90502740}, ColumnMetaData{SNAPPY [settle_proc_fee_req] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 90580381}, ColumnMetaData{SNAPPY
[settle_proc_fee_rsp] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 90580487},
ColumnMetaData{SNAPPY [settle_currency_code] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 90580593}, ColumnMetaData{SNAPPY [icc_data_req] BINARY
[PLAIN_DICTIONARY, PLAIN, BIT_PACKED, RLE], 90581464}, ColumnMetaData{SNAPPY
[icc_data_rsp] BINARY [PLAIN_DICTIONARY, PLAIN, BIT_PACKED, RLE], 109552128},
ColumnMetaData{SNAPPY [pos_entry_mode] BINARY [PLAIN_DICTIONARY, BIT_PACKED,
RLE], 114484939}, ColumnMetaData{SNAPPY [pos_condition_code] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 114550156}, ColumnMetaData{SNAPPY
[additional_rsp_data] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 114609555},
ColumnMetaData{SNAPPY [structured_data_req] BINARY [PLAIN_DICTIONARY, PLAIN,
BIT_PACKED, RLE], 114623125}, ColumnMetaData{SNAPPY [structured_data_rsp]
BINARY [PLAIN_DICTIONARY, PLAIN, BIT_PACKED, RLE], 138086532},
ColumnMetaData{SNAPPY [tran_reversed] BINARY [PLAIN_DICTIONARY, BIT_PACKED,
RLE], 142638837}, ColumnMetaData{SNAPPY [prev_tran_approved] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 142647897}, ColumnMetaData{SNAPPY
[issuer_network_id] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 142650650},
ColumnMetaData{SNAPPY [acquirer_network_id] BINARY [PLAIN, BIT_PACKED, RLE],
142663555}, ColumnMetaData{SNAPPY [extended_tran_type] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 142663590}, ColumnMetaData{SNAPPY
[ucaf_data] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 142721767},
ColumnMetaData{SNAPPY [from_account_type_qualifier] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 142743521}, ColumnMetaData{SNAPPY [to_account_type_qualifier]
BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 142744111}, ColumnMetaData{SNAPPY
[bank_details] BINARY [PLAIN_DICTIONARY, PLAIN, BIT_PACKED, RLE], 142744679},
ColumnMetaData{SNAPPY [payee] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
143235435}, ColumnMetaData{SNAPPY [card_verification_result] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 143657037}, ColumnMetaData{SNAPPY
[online_system_id] INT32 [PLAIN_DICTIONARY, BIT_PACKED, RLE], 143723623},
ColumnMetaData{SNAPPY [participant_id] INT32 [PLAIN, BIT_PACKED, RLE],
143723714}, ColumnMetaData{SNAPPY [opp_participant_id] INT32 [PLAIN,
BIT_PACKED, RLE], 143723749}, ColumnMetaData{SNAPPY [receiving_inst_id_code]
BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 143723784}, ColumnMetaData{SNAPPY
[routing_type] INT32 [PLAIN, BIT_PACKED, RLE], 143791969},
ColumnMetaData{SNAPPY [pt_pos_operating_environment] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 143792004}, ColumnMetaData{SNAPPY [pt_pos_card_input_mode]
BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 143886050}, ColumnMetaData{SNAPPY
[pt_pos_cardholder_auth_method] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
143959762}, ColumnMetaData{SNAPPY [pt_pos_pin_capture_ability] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 144029290}, ColumnMetaData{SNAPPY
[pt_pos_terminal_operator] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
144106280}, ColumnMetaData{SNAPPY [source_node_key] BINARY [PLAIN_DICTIONARY,
PLAIN, BIT_PACKED, RLE], 144170354}, ColumnMetaData{SNAPPY
[proc_online_system_id] INT32 [PLAIN_DICTIONARY, BIT_PACKED, RLE], 147256120},
ColumnMetaData{SNAPPY [from_account_id_cs] INT32 [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 147256211}, ColumnMetaData{SNAPPY [to_account_id_cs] INT32
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 148084203}, ColumnMetaData{SNAPPY
[pos_geographic_data] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 148220217},
ColumnMetaData{SNAPPY [payer_account_id] BINARY [PLAIN_DICTIONARY, BIT_PACKED,
RLE], 148338244}, ColumnMetaData{SNAPPY [cvv_available_at_auth] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 148415722}, ColumnMetaData{SNAPPY
[cvv2_available_at_auth] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
148452121}, ColumnMetaData{SNAPPY [Expr1] INT64 [PLAIN, BIT_PACKED, RLE],
148488303}, ColumnMetaData{SNAPPY [source_node_name] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 149420455}, ColumnMetaData{SNAPPY [draft_capture] INT32
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 149643646}, ColumnMetaData{SNAPPY [pan]
BINARY [PLAIN_DICTIONARY, PLAIN, BIT_PACKED, RLE], 149643714},
ColumnMetaData{SNAPPY [card_seq_nr] BINARY [PLAIN_DICTIONARY, BIT_PACKED,
RLE], 150956329}, ColumnMetaData{SNAPPY [expiry_date] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 151051761}, ColumnMetaData{SNAPPY
[service_restriction_code] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
151274756}, ColumnMetaData{SNAPPY [terminal_id] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 151369557}, ColumnMetaData{SNAPPY [terminal_owner] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 151983465}, ColumnMetaData{SNAPPY
[card_acceptor_id_code] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
152099691}, ColumnMetaData{SNAPPY [mapped_card_acceptor_id_code] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 152728738}, ColumnMetaData{SNAPPY
[merchant_type] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 153357747},
ColumnMetaData{SNAPPY [card_acceptor_name_loc] BINARY [PLAIN_DICTIONARY,
PLAIN, BIT_PACKED, RLE], 153554601}, ColumnMetaData{SNAPPY
[address_verification_data] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
157247675}, ColumnMetaData{SNAPPY [address_verification_result] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 157254267}, ColumnMetaData{SNAPPY
[check_data] BINARY [PLAIN, BIT_PACKED, RLE], 157260885},
ColumnMetaData{SNAPPY [totals_group] BINARY [PLAIN_DICTIONARY, BIT_PACKED,
RLE], 157260920}, ColumnMetaData{SNAPPY [card_product] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 157484243}, ColumnMetaData{SNAPPY
[pos_card_data_input_ability] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
157722226}, ColumnMetaData{SNAPPY [pos_cardholder_auth_ability] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 157792644}, ColumnMetaData{SNAPPY
[pos_card_capture_ability] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
157851670}, ColumnMetaData{SNAPPY [pos_operating_environment] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 157886076}, ColumnMetaData{SNAPPY
[pos_cardholder_present] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
157980122}, ColumnMetaData{SNAPPY [pos_card_present] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 158039281}, ColumnMetaData{SNAPPY [pos_card_data_input_mode]
BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 158075676}, ColumnMetaData{SNAPPY
[pos_cardholder_auth_method] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
158149388}, ColumnMetaData{SNAPPY [pos_cardholder_auth_entity] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 158218916}, ColumnMetaData{SNAPPY
[pos_card_data_output_ability] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
158310591}, ColumnMetaData{SNAPPY [pos_terminal_output_ability] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 158372871}, ColumnMetaData{SNAPPY
[pos_pin_capture_ability] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
158431930}, ColumnMetaData{SNAPPY [pos_terminal_operator] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 158508920}, ColumnMetaData{SNAPPY
[pos_terminal_type] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 158572994},
ColumnMetaData{SNAPPY [pan_search] INT32 [PLAIN_DICTIONARY, BIT_PACKED, RLE],
158667600}, ColumnMetaData{SNAPPY [pan_encrypted] BINARY [PLAIN_DICTIONARY,
PLAIN, BIT_PACKED, RLE], 159151872}, ColumnMetaData{SNAPPY [pan_reference]
BINARY [PLAIN_DICTIONARY, PLAIN, BIT_PACKED, RLE], 161436998},
ColumnMetaData{SNAPPY [card_acceptor_id_code_cs] INT32 [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 167306573}]}, BlockMetaData{45156, 89699553
[ColumnMetaData{SNAPPY [post_tran_id] INT64 [PLAIN, BIT_PACKED, RLE],
167845349}, ColumnMetaData{SNAPPY [post_tran_cust_id] INT64 [PLAIN,
BIT_PACKED, RLE], 168026960}, ColumnMetaData{SNAPPY [settle_entity_id] INT32
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 168192759}, ColumnMetaData{SNAPPY
[batch_nr] INT32 [PLAIN_DICTIONARY, BIT_PACKED, RLE], 168238759},
ColumnMetaData{SNAPPY [prev_post_tran_id] INT64 [PLAIN_DICTIONARY, BIT_PACKED,
RLE], 168246435}, ColumnMetaData{SNAPPY [next_post_tran_id] INT64
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 168260008}, ColumnMetaData{SNAPPY
[sink_node_name] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 168275663},
ColumnMetaData{SNAPPY [tran_postilion_originated] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 168316080}, ColumnMetaData{SNAPPY [tran_completed] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 168321969}, ColumnMetaData{SNAPPY
[message_type] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 168322032},
ColumnMetaData{SNAPPY [tran_type] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
168331634}, ColumnMetaData{SNAPPY [tran_nr] INT64 [PLAIN, BIT_PACKED, RLE],
168353012}, ColumnMetaData{SNAPPY [system_trace_audit_nr] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 168519083}, ColumnMetaData{SNAPPY
[rsp_code_req] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 168687947},
ColumnMetaData{SNAPPY [rsp_code_rsp] BINARY [PLAIN_DICTIONARY, BIT_PACKED,
RLE], 168690145}, ColumnMetaData{SNAPPY [abort_rsp_code] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 168704226}, ColumnMetaData{SNAPPY
[auth_id_rsp] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 168704409},
ColumnMetaData{SNAPPY [auth_type] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
168827203}, ColumnMetaData{SNAPPY [auth_reason] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 168836662}, ColumnMetaData{SNAPPY [retention_data] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 168848042}, ColumnMetaData{SNAPPY
[acquiring_inst_id_code] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
168849866}, ColumnMetaData{SNAPPY [message_reason_code] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 168884192}, ColumnMetaData{SNAPPY
[sponsor_bank] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 168890497},
ColumnMetaData{SNAPPY [retrieval_reference_nr] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 168914056}, ColumnMetaData{SNAPPY [datetime_tran_gmt] INT64
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 169180763}, ColumnMetaData{SNAPPY
[datetime_tran_local] INT64 [PLAIN_DICTIONARY, BIT_PACKED, RLE], 169279913},
ColumnMetaData{SNAPPY [datetime_req] INT64 [PLAIN, BIT_PACKED, RLE],
169381533}, ColumnMetaData{SNAPPY [datetime_rsp] INT64 [PLAIN, BIT_PACKED,
RLE], 169563833}, ColumnMetaData{SNAPPY [realtime_business_date] INT64
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 169733308}, ColumnMetaData{SNAPPY
[recon_business_date] INT64 [PLAIN_DICTIONARY, BIT_PACKED, RLE], 169733388},
ColumnMetaData{SNAPPY [from_account_type] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 169733468}, ColumnMetaData{SNAPPY [to_account_type] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 169747338}, ColumnMetaData{SNAPPY
[from_account_id] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 169756024},
ColumnMetaData{SNAPPY [to_account_id] BINARY [PLAIN_DICTIONARY, BIT_PACKED,
RLE], 170001969}, ColumnMetaData{SNAPPY [tran_amount_req] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 170036872}, ColumnMetaData{SNAPPY
[tran_amount_rsp] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 170101075},
ColumnMetaData{SNAPPY [settle_amount_impact] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 170160835}, ColumnMetaData{SNAPPY [tran_cash_req] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 170221511}, ColumnMetaData{SNAPPY
[tran_cash_rsp] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 170243319},
ColumnMetaData{SNAPPY [tran_currency_code] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 170262666}, ColumnMetaData{SNAPPY [tran_tran_fee_req] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 170262858}, ColumnMetaData{SNAPPY
[tran_tran_fee_rsp] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 170278325},
ColumnMetaData{SNAPPY [tran_tran_fee_currency_code] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 170291960}, ColumnMetaData{SNAPPY [tran_proc_fee_req] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 170292152}, ColumnMetaData{SNAPPY
[tran_proc_fee_rsp] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 170292215},
ColumnMetaData{SNAPPY [tran_proc_fee_currency_code] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 170292278}, ColumnMetaData{SNAPPY [settle_amount_req] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 170292470}, ColumnMetaData{SNAPPY
[settle_amount_rsp] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 170356674},
ColumnMetaData{SNAPPY [settle_cash_req] BINARY [PLAIN_DICTIONARY, BIT_PACKED,
RLE], 170416434}, ColumnMetaData{SNAPPY [settle_cash_rsp] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 170438246}, ColumnMetaData{SNAPPY
[settle_tran_fee_req] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 170457593},
ColumnMetaData{SNAPPY [settle_tran_fee_rsp] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 170473060}, ColumnMetaData{SNAPPY [settle_proc_fee_req]
BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 170486695}, ColumnMetaData{SNAPPY
[settle_proc_fee_rsp] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 170486758},
ColumnMetaData{SNAPPY [settle_currency_code] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 170486821}, ColumnMetaData{SNAPPY [icc_data_req] BINARY
[PLAIN_DICTIONARY, PLAIN, BIT_PACKED, RLE], 170487030}, ColumnMetaData{SNAPPY
[icc_data_rsp] BINARY [PLAIN_DICTIONARY, PLAIN, BIT_PACKED, RLE], 174193788},
ColumnMetaData{SNAPPY [pos_entry_mode] BINARY [PLAIN_DICTIONARY, BIT_PACKED,
RLE], 175096527}, ColumnMetaData{SNAPPY [pos_condition_code] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 175108214}, ColumnMetaData{SNAPPY
[additional_rsp_data] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 175118228},
ColumnMetaData{SNAPPY [structured_data_req] BINARY [PLAIN_DICTIONARY, PLAIN,
BIT_PACKED, RLE], 175120792}, ColumnMetaData{SNAPPY [structured_data_rsp]
BINARY [PLAIN_DICTIONARY, PLAIN, BIT_PACKED, RLE], 180125743},
ColumnMetaData{SNAPPY [tran_reversed] BINARY [PLAIN_DICTIONARY, BIT_PACKED,
RLE], 180950115}, ColumnMetaData{SNAPPY [prev_tran_approved] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 180952601}, ColumnMetaData{SNAPPY
[issuer_network_id] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 180953193},
ColumnMetaData{SNAPPY [acquirer_network_id] BINARY [PLAIN, BIT_PACKED, RLE],
180955148}, ColumnMetaData{SNAPPY [extended_tran_type] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 180955183}, ColumnMetaData{SNAPPY
[ucaf_data] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 180966616},
ColumnMetaData{SNAPPY [from_account_type_qualifier] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 180969883}, ColumnMetaData{SNAPPY [to_account_type_qualifier]
BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 180970106}, ColumnMetaData{SNAPPY
[bank_details] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 180970317},
ColumnMetaData{SNAPPY [payee] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
181035839}, ColumnMetaData{SNAPPY [card_verification_result] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 181109395}, ColumnMetaData{SNAPPY
[online_system_id] INT32 [PLAIN_DICTIONARY, BIT_PACKED, RLE], 181120639},
ColumnMetaData{SNAPPY [participant_id] INT32 [PLAIN, BIT_PACKED, RLE],
181120707}, ColumnMetaData{SNAPPY [opp_participant_id] INT32 [PLAIN,
BIT_PACKED, RLE], 181120742}, ColumnMetaData{SNAPPY [receiving_inst_id_code]
BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 181120777}, ColumnMetaData{SNAPPY
[routing_type] INT32 [PLAIN, BIT_PACKED, RLE], 181133967},
ColumnMetaData{SNAPPY [pt_pos_operating_environment] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 181134002}, ColumnMetaData{SNAPPY [pt_pos_card_input_mode]
BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 181150441}, ColumnMetaData{SNAPPY
[pt_pos_cardholder_auth_method] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
181160695}, ColumnMetaData{SNAPPY [pt_pos_pin_capture_ability] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 181170679}, ColumnMetaData{SNAPPY
[pt_pos_terminal_operator] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
181183791}, ColumnMetaData{SNAPPY [source_node_key] BINARY [PLAIN_DICTIONARY,
PLAIN, BIT_PACKED, RLE], 181195263}, ColumnMetaData{SNAPPY
[proc_online_system_id] INT32 [PLAIN_DICTIONARY, BIT_PACKED, RLE], 181760209},
ColumnMetaData{SNAPPY [from_account_id_cs] INT32 [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 181760277}, ColumnMetaData{SNAPPY [to_account_id_cs] INT32
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 181907712}, ColumnMetaData{SNAPPY
[pos_geographic_data] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 181930751},
ColumnMetaData{SNAPPY [payer_account_id] BINARY [PLAIN_DICTIONARY, BIT_PACKED,
RLE], 181957349}, ColumnMetaData{SNAPPY [cvv_available_at_auth] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 181966740}, ColumnMetaData{SNAPPY
[cvv2_available_at_auth] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
181973470}, ColumnMetaData{SNAPPY [Expr1] INT64 [PLAIN, BIT_PACKED, RLE],
181979456}, ColumnMetaData{SNAPPY [source_node_name] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 182145255}, ColumnMetaData{SNAPPY [draft_capture] INT32
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 182185457}, ColumnMetaData{SNAPPY [pan]
BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 182185525}, ColumnMetaData{SNAPPY
[card_seq_nr] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 182389225},
ColumnMetaData{SNAPPY [expiry_date] BINARY [PLAIN_DICTIONARY, BIT_PACKED,
RLE], 182407968}, ColumnMetaData{SNAPPY [service_restriction_code] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 182448013}, ColumnMetaData{SNAPPY
[terminal_id] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 182465619},
ColumnMetaData{SNAPPY [terminal_owner] BINARY [PLAIN_DICTIONARY, BIT_PACKED,
RLE], 182611199}, ColumnMetaData{SNAPPY [card_acceptor_id_code] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 182637004}, ColumnMetaData{SNAPPY
[mapped_card_acceptor_id_code] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
182791164}, ColumnMetaData{SNAPPY [merchant_type] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 182945339}, ColumnMetaData{SNAPPY [card_acceptor_name_loc]
BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 182976414}, ColumnMetaData{SNAPPY
[address_verification_data] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
183370503}, ColumnMetaData{SNAPPY [address_verification_result] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 183372023}, ColumnMetaData{SNAPPY
[check_data] BINARY [PLAIN, BIT_PACKED, RLE], 183373532},
ColumnMetaData{SNAPPY [totals_group] BINARY [PLAIN_DICTIONARY, BIT_PACKED,
RLE], 183373567}, ColumnMetaData{SNAPPY [card_product] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 183413612}, ColumnMetaData{SNAPPY
[pos_card_data_input_ability] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
183454148}, ColumnMetaData{SNAPPY [pos_cardholder_auth_ability] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 183465892}, ColumnMetaData{SNAPPY
[pos_card_capture_ability] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
183475873}, ColumnMetaData{SNAPPY [pos_operating_environment] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 183482087}, ColumnMetaData{SNAPPY
[pos_cardholder_present] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
183498526}, ColumnMetaData{SNAPPY [pos_card_present] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 183508489}, ColumnMetaData{SNAPPY [pos_card_data_input_mode]
BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 183515192}, ColumnMetaData{SNAPPY
[pos_cardholder_auth_method] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
183525446}, ColumnMetaData{SNAPPY [pos_cardholder_auth_entity] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 183535430}, ColumnMetaData{SNAPPY
[pos_card_data_output_ability] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
183551232}, ColumnMetaData{SNAPPY [pos_terminal_output_ability] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 183562073}, ColumnMetaData{SNAPPY
[pos_pin_capture_ability] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE],
183572065}, ColumnMetaData{SNAPPY [pos_terminal_operator] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 183585177}, ColumnMetaData{SNAPPY
[pos_terminal_type] BINARY [PLAIN_DICTIONARY, BIT_PACKED, RLE], 183596649},
ColumnMetaData{SNAPPY [pan_search] INT32 [PLAIN_DICTIONARY, BIT_PACKED, RLE],
183613315}, ColumnMetaData{SNAPPY [pan_encrypted] BINARY [PLAIN_DICTIONARY,
BIT_PACKED, RLE], 183725641}, ColumnMetaData{SNAPPY [pan_reference] BINARY
[PLAIN_DICTIONARY, BIT_PACKED, RLE], 184085207}, ColumnMetaData{SNAPPY
[card_acceptor_id_code_cs] INT32 [PLAIN_DICTIONARY, BIT_PACKED, RLE],
184890454}]}]}"
stack_trace {
class_name:
"org.apache.drill.exec.store.parquet.columnreaders.ParquetRecordReader"
file_name: "ParquetRecordReader.java"
line_number: 275
method_name: "handleException"
is_native_method: false
}
stack_trace {
class_name:
"org.apache.drill.exec.store.parquet.columnreaders.ParquetRecordReader"
file_name: "ParquetRecordReader.java"
line_number: 259
method_name: "setup"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.physical.impl.ScanBatch"
file_name: "ScanBatch.java"
line_number: 325
method_name: "getNextReaderIfHas"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.physical.impl.ScanBatch"
file_name: "ScanBatch.java"
line_number: 220
method_name: "internalNext"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.physical.impl.ScanBatch"
file_name: "ScanBatch.java"
line_number: 271
method_name: "next"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractRecordBatch"
file_name: "AbstractRecordBatch.java"
line_number: 119
method_name: "next"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractRecordBatch"
file_name: "AbstractRecordBatch.java"
line_number: 109
method_name: "next"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractSingleRecordBatch"
file_name: "AbstractSingleRecordBatch.java"
line_number: 51
method_name: "innerNext"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractRecordBatch"
file_name: "AbstractRecordBatch.java"
line_number: 164
method_name: "next"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractRecordBatch"
file_name: "AbstractRecordBatch.java"
line_number: 119
method_name: "next"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractRecordBatch"
file_name: "AbstractRecordBatch.java"
line_number: 109
method_name: "next"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractSingleRecordBatch"
file_name: "AbstractSingleRecordBatch.java"
line_number: 51
method_name: "innerNext"
is_native_method: false
}
stack_trace {
class_name:
"org.apache.drill.exec.physical.impl.svremover.RemovingRecordBatch"
file_name: "RemovingRecordBatch.java"
line_number: 93
method_name: "innerNext"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractRecordBatch"
file_name: "AbstractRecordBatch.java"
line_number: 164
method_name: "next"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractRecordBatch"
file_name: "AbstractRecordBatch.java"
line_number: 119
method_name: "next"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractRecordBatch"
file_name: "AbstractRecordBatch.java"
line_number: 109
method_name: "next"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractSingleRecordBatch"
file_name: "AbstractSingleRecordBatch.java"
line_number: 51
method_name: "innerNext"
is_native_method: false
}
stack_trace {
class_name:
"org.apache.drill.exec.physical.impl.project.ProjectRecordBatch"
file_name: "ProjectRecordBatch.java"
line_number: 134
method_name: "innerNext"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractRecordBatch"
file_name: "AbstractRecordBatch.java"
line_number: 164
method_name: "next"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractRecordBatch"
file_name: "AbstractRecordBatch.java"
line_number: 119
method_name: "next"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractRecordBatch"
file_name: "AbstractRecordBatch.java"
line_number: 109
method_name: "next"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.physical.impl.aggregate.HashAggBatch"
file_name: "HashAggBatch.java"
line_number: 119
method_name: "buildSchema"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractRecordBatch"
file_name: "AbstractRecordBatch.java"
line_number: 144
method_name: "next"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractRecordBatch"
file_name: "AbstractRecordBatch.java"
line_number: 119
method_name: "next"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractRecordBatch"
file_name: "AbstractRecordBatch.java"
line_number: 109
method_name: "next"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractSingleRecordBatch"
file_name: "AbstractSingleRecordBatch.java"
line_number: 51
method_name: "innerNext"
is_native_method: false
}
stack_trace {
class_name:
"org.apache.drill.exec.physical.impl.project.ProjectRecordBatch"
file_name: "ProjectRecordBatch.java"
line_number: 134
method_name: "innerNext"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractRecordBatch"
file_name: "AbstractRecordBatch.java"
line_number: 164
method_name: "next"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.physical.impl.BaseRootExec"
file_name: "BaseRootExec.java"
line_number: 105
method_name: "next"
is_native_method: false
}
stack_trace {
class_name:
"org.apache.drill.exec.physical.impl.SingleSenderCreator$SingleSenderRootExec"
file_name: "SingleSenderCreator.java"
line_number: 92
method_name: "innerNext"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.physical.impl.BaseRootExec"
file_name: "BaseRootExec.java"
line_number: 95
method_name: "next"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.work.fragment.FragmentExecutor$1"
file_name: "FragmentExecutor.java"
line_number: 234
method_name: "run"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.work.fragment.FragmentExecutor$1"
file_name: "FragmentExecutor.java"
line_number: 227
method_name: "run"
is_native_method: false
}
stack_trace {
class_name: "..."
line_number: 0
method_name: "..."
is_native_method: false
}
stack_trace {
class_name: "org.apache.hadoop.security.UserGroupInformation"
file_name: "UserGroupInformation.java"
line_number: 1595
method_name: "doAs"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.work.fragment.FragmentExecutor"
file_name: "FragmentExecutor.java"
line_number: 227
method_name: "run"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.common.SelfCleaningRunnable"
file_name: "SelfCleaningRunnable.java"
line_number: 38
method_name: "run"
is_native_method: false
}
stack_trace {
class_name: "..."
line_number: 0
method_name: "..."
is_native_method: false
}
cause {
exception_class: "java.lang.ClassCastException"
message: "org.apache.drill.exec.vector.NullableDecimal28SparseVector
cannot be cast to org.apache.drill.exec.vector.VariableWidthVector"
stack_trace {
class_name:
"org.apache.drill.exec.store.parquet.columnreaders.VarLengthValuesColumn"
file_name: "VarLengthValuesColumn.java"
line_number: 52
method_name: "<init>"
is_native_method: false
}
stack_trace {
class_name:
"org.apache.drill.exec.store.parquet.columnreaders.NullableVarLengthValuesColumn"
file_name: "NullableVarLengthValuesColumn.java"
line_number: 39
method_name: "<init>"
is_native_method: false
}
stack_trace {
class_name:
"org.apache.drill.exec.store.parquet.columnreaders.VarLengthColumnReaders$NullableDecimal28Column"
file_name: "VarLengthColumnReaders.java"
line_number: 99
method_name: "<init>"
is_native_method: false
}
stack_trace {
class_name:
"org.apache.drill.exec.store.parquet.columnreaders.ColumnReaderFactory"
file_name: "ColumnReaderFactory.java"
line_number: 243
method_name: "getReader"
is_native_method: false
}
stack_trace {
class_name:
"org.apache.drill.exec.store.parquet.columnreaders.ParquetColumnMetadata"
file_name: "ParquetColumnMetadata.java"
line_number: 151
method_name: "makeVariableWidthReader"
is_native_method: false
}
stack_trace {
class_name:
"org.apache.drill.exec.store.parquet.columnreaders.ReadState"
file_name: "ReadState.java"
line_number: 100
method_name: "buildReader"
is_native_method: false
}
stack_trace {
class_name:
"org.apache.drill.exec.store.parquet.columnreaders.ParquetRecordReader"
file_name: "ParquetRecordReader.java"
line_number: 257
method_name: "setup"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.physical.impl.ScanBatch"
file_name: "ScanBatch.java"
line_number: 325
method_name: "getNextReaderIfHas"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.physical.impl.ScanBatch"
file_name: "ScanBatch.java"
line_number: 220
method_name: "internalNext"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.physical.impl.ScanBatch"
file_name: "ScanBatch.java"
line_number: 271
method_name: "next"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractRecordBatch"
file_name: "AbstractRecordBatch.java"
line_number: 119
method_name: "next"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractRecordBatch"
file_name: "AbstractRecordBatch.java"
line_number: 109
method_name: "next"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractSingleRecordBatch"
file_name: "AbstractSingleRecordBatch.java"
line_number: 51
method_name: "innerNext"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractRecordBatch"
file_name: "AbstractRecordBatch.java"
line_number: 164
method_name: "next"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractRecordBatch"
file_name: "AbstractRecordBatch.java"
line_number: 119
method_name: "next"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractRecordBatch"
file_name: "AbstractRecordBatch.java"
line_number: 109
method_name: "next"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractSingleRecordBatch"
file_name: "AbstractSingleRecordBatch.java"
line_number: 51
method_name: "innerNext"
is_native_method: false
}
stack_trace {
class_name:
"org.apache.drill.exec.physical.impl.svremover.RemovingRecordBatch"
file_name: "RemovingRecordBatch.java"
line_number: 93
method_name: "innerNext"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractRecordBatch"
file_name: "AbstractRecordBatch.java"
line_number: 164
method_name: "next"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractRecordBatch"
file_name: "AbstractRecordBatch.java"
line_number: 119
method_name: "next"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractRecordBatch"
file_name: "AbstractRecordBatch.java"
line_number: 109
method_name: "next"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractSingleRecordBatch"
file_name: "AbstractSingleRecordBatch.java"
line_number: 51
method_name: "innerNext"
is_native_method: false
}
stack_trace {
class_name:
"org.apache.drill.exec.physical.impl.project.ProjectRecordBatch"
file_name: "ProjectRecordBatch.java"
line_number: 134
method_name: "innerNext"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractRecordBatch"
file_name: "AbstractRecordBatch.java"
line_number: 164
method_name: "next"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractRecordBatch"
file_name: "AbstractRecordBatch.java"
line_number: 119
method_name: "next"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractRecordBatch"
file_name: "AbstractRecordBatch.java"
line_number: 109
method_name: "next"
is_native_method: false
}
stack_trace {
class_name:
"org.apache.drill.exec.physical.impl.aggregate.HashAggBatch"
file_name: "HashAggBatch.java"
line_number: 119
method_name: "buildSchema"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractRecordBatch"
file_name: "AbstractRecordBatch.java"
line_number: 144
method_name: "next"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractRecordBatch"
file_name: "AbstractRecordBatch.java"
line_number: 119
method_name: "next"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractRecordBatch"
file_name: "AbstractRecordBatch.java"
line_number: 109
method_name: "next"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractSingleRecordBatch"
file_name: "AbstractSingleRecordBatch.java"
line_number: 51
method_name: "innerNext"
is_native_method: false
}
stack_trace {
class_name:
"org.apache.drill.exec.physical.impl.project.ProjectRecordBatch"
file_name: "ProjectRecordBatch.java"
line_number: 134
method_name: "innerNext"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.record.AbstractRecordBatch"
file_name: "AbstractRecordBatch.java"
line_number: 164
method_name: "next"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.physical.impl.BaseRootExec"
file_name: "BaseRootExec.java"
line_number: 105
method_name: "next"
is_native_method: false
}
stack_trace {
class_name:
"org.apache.drill.exec.physical.impl.SingleSenderCreator$SingleSenderRootExec"
file_name: "SingleSenderCreator.java"
line_number: 92
method_name: "innerNext"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.physical.impl.BaseRootExec"
file_name: "BaseRootExec.java"
line_number: 95
method_name: "next"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.work.fragment.FragmentExecutor$1"
file_name: "FragmentExecutor.java"
line_number: 234
method_name: "run"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.work.fragment.FragmentExecutor$1"
file_name: "FragmentExecutor.java"
line_number: 227
method_name: "run"
is_native_method: false
}
stack_trace {
class_name: "..."
line_number: 0
method_name: "..."
is_native_method: false
}
stack_trace {
class_name: "org.apache.hadoop.security.UserGroupInformation"
file_name: "UserGroupInformation.java"
line_number: 1595
method_name: "doAs"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.exec.work.fragment.FragmentExecutor"
file_name: "FragmentExecutor.java"
line_number: 227
method_name: "run"
is_native_method: false
}
stack_trace {
class_name: "org.apache.drill.common.SelfCleaningRunnable"
file_name: "SelfCleaningRunnable.java"
line_number: 38
method_name: "run"
is_native_method: false
}
stack_trace {
class_name: "..."
line_number: 0
method_name: "..."
is_native_method: false
}
}
}
}
This message has been marked as CONFIDENTIAL on Monday, April 30, 2018 @
9:43:47 AM
-----Original Message-----
From: Vova Vysotskyi <[email protected]>
Sent: Monday, April 30, 2018 9:37 AM
To: [email protected]
Subject: Re: Exception While Querying Decimal Fields in Apache Drill
This part of the stack trace connected with the client side, could you please
share a stack trace that corresponds to the error on the server side?
Kind regards,
Volodymyr Vysotskyi
пн, 30 квіт. 2018 о 10:44 Peter Edike <[email protected]>
пише:
> Hi,
>
> Stacktrace as requested
>
> java.sql.SQLException: [MapR][DrillJDBCDriver](500165) Query execution
> error. Details: SYSTEM ERROR: ClassCastException:
> org.apache.drill.exec.vector.NullableDecimal28SparseVector cannot be
> cast to org.apache.drill.exec.vector.VariableWidthVector
> Fragment 2:18
> [Error Id: dba9df08-fb1d-4bd2-93e6-d08fb6f79ff1 on
> BGDTEST3.INTERSWITCH.COM:31010].
> at
> com.mapr.drill.drill.dataengine.DRQryResultListener.checkAndThrowExcep
> tion(Unknown
> Source)
> at
> com.mapr.drill.drill.dataengine.DRQryResultListener.getNextBatch(Unkno
> wn
> Source)
> at
> com.mapr.drill.drill.dataengine.DRJDBCResultSet.doLoadRecordBatchData(
> Unknown
> Source)
> at
> com.mapr.drill.drill.dataengine.DRJDBCResultSet.doMoveToNextRow(Unknow
> n
> Source)
> at
> com.mapr.drill.drill.dataengine.DRJDBCQueryExecutor.execute(Unknown Source)
> at
> com.mapr.drill.jdbc.common.SStatement.executeNoParams(Unknown
> Source)
> at com.mapr.drill.jdbc.common.SStatement.execute(Unknown Source)
> at
> org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291)
> at
> org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291)
> at
> org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(JDBCInterpreter.java:581)
> at
> org.apache.zeppelin.jdbc.JDBCInterpreter.interpret(JDBCInterpreter.java:692)
> at
> org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:97)
> at
> org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:498)
> at org.apache.zeppelin.scheduler.Job.run(Job.java:175)
> at
> org.apache.zeppelin.scheduler.ParallelScheduler$JobRunner.run(ParallelScheduler.java:162)
> at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> at
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
> at
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.
> java:624) Caused by:
> com.mapr.drill.support.exceptions.GeneralException:
> [MapR][DrillJDBCDriver](500165) Query execution error. Details: SYSTEM
> ERROR: ClassCastException:
> org.apache.drill.exec.vector.NullableDecimal28SparseVector cannot be
> cast to org.apache.drill.exec.vector.VariableWidthVector
> Fragment 2:18
> [Error Id: dba9df08-fb1d-4bd2-93e6-d08fb6f79ff1 on
> BGDTEST3.INTERSWITCH.COM:31010].
> ... 21 more
>
>
> This message has been marked as CONFIDENTIAL on Monday, April 30, 2018
> @
> 8:44:22 AM
>
> -----Original Message-----
> From: Vova Vysotskyi <[email protected]>
> Sent: Friday, April 27, 2018 5:29 PM
> To: [email protected]
> Subject: Re: Exception While Querying Decimal Fields in Apache Drill
>
> Hi Peter,
>
> Could you please also share a stacktrace?
>
> Does the specified table
> contain pan, terminal_id, source_node_name, tran_completed,
> tran_reversed and tran_type columns? If it contains them, which types do they
> have?
>
> Kind regards,
> Volodymyr Vysotskyi
>
>
> пт, 27 квіт. 2018 о 17:47 Peter Edike
> <[email protected]>
> пише:
>
> >
> >
> > Drill Version 1.12.0
> >
> >
> >
> > planner.enable_decimal_data_type is set to true on the system.
> >
> >
> >
> > --peter
> >
> >
> >
> >
> >
> > -----Original Message-----
> >
> > From: Andries Engelbrecht <[email protected]>
> >
> > Sent: Friday, April 27, 2018 3:41 PM
> >
> > To: [email protected]
> >
> > Subject: Re: Exception While Querying Decimal Fields in Apache Drill
> >
> >
> >
> > What version of Drill are you using?
> >
> > Also is planner.enable_decimal_data_type set to true on the system?
> >
> >
> >
> > --Andries
> >
> >
> >
> > On 4/27/18, 7:24 AM, "Peter Edike"
> > <[email protected]>
> > wrote:
> >
> >
> >
> > Tried That, It did not work. Still Fails with the exception. Let
> > me even add that even if the query is a simple select ....from
> > statement, as long any of the fields is decimal type, the statement
> > will fail with the stated exception
> >
> >
> >
> > Please Help.... a lot depends on this
> >
> >
> >
> > Best regards,
> >
> > Peter Edike
> >
> >
> >
> > This message has been marked as CONFIDENTIAL on Friday, April
> > 27,
> > 2018 @ 3:24:36 PM
> >
> >
> >
> > -----Original Message-----
> >
> > From: Andries Engelbrecht <[email protected]>
> >
> > Sent: Friday, April 27, 2018 3:07 PM
> >
> > To: [email protected]
> >
> > Subject: Re: Exception While Querying Decimal Fields in Apache
> > Drill
> >
> >
> >
> > Perhaps try to convert the predicate and select operations
> > involving the decimal types to float or similar.
> >
> >
> >
> > i.e tran_completed = 1.0 and ((cast(SETTLE_AMOUNT_IMPACT as double)
> > *(-1.0))/100.0)
> >
> >
> >
> > Alternatively you may have to cast the decimals as float, but
> > that will be more cumbersome.
> >
> >
> >
> > --Andries
> >
> >
> >
> > On 4/27/18, 5:18 AM, "Peter Edike"
> > <[email protected]>
> > wrote:
> >
> >
> >
> > I am trying to run the following query in apache drill, I am
> > querying data stored in parquet files using the following query
> >
> >
> >
> >
> >
> > select pan, count(*) as number_of_transactions ,
> >
> > terminal_id,SUM((cast(SETTLE_AMOUNT_IMPACT as double)
> > *-1)/100) AS settle_amount_impact
> >
> >
> >
> >
> >
> > from
> > dfs.`/iswdata/storage/products/superswitch/parquet/transactions`
> >
> >
> >
> > where pan like '506126%' and terminal_id like '1%' and
> >
> > sink_node_name like ('SWTDB%')
> >
> > and source_node_name not like ('SWTDBLsrc')
> >
> > and tran_completed=1
> >
> > and tran_reversed = 0
> >
> > and tran_postilion_originated = 1
> >
> > AND tran_type = '01'
> >
> > --and pan like '506126%0011'
> >
> > group by pan,terminal_id
> >
> >
> >
> > The Schema for the data I am querying is as follows
> >
> >
> >
> >
> >
> > post_tran_id LONG
> >
> >
> >
> > post_tran_cust_id :LONG
> >
> >
> >
> > settle_entity_id :INTEGER
> >
> >
> >
> > batch_nr : INTEGER
> >
> >
> >
> > prev_post_tran_id : LONG
> >
> >
> >
> > next_post_tran_id : LONG
> >
> >
> >
> > sink_node_name : STRING
> >
> >
> >
> > tran_postilion_originated : DECIMAL
> >
> >
> >
> > tran_completed : DECIMAL
> >
> >
> >
> > tran_amount_req : DECIMAL
> >
> >
> >
> > tran_amount_rsp : DECIMAL
> >
> >
> >
> > settle_amount_impact : DECIMAL
> >
> >
> >
> > tran_cash_req : DECIMAL
> >
> >
> >
> > tran_cash_rsp : DECIMAL
> >
> >
> >
> > tran_currency_code : STRING
> >
> >
> >
> > tran_tran_fee_req : DECIMAL
> >
> >
> >
> > tran_tran_fee_rsp : DECIMAL
> >
> >
> >
> > tran_tran_fee_currency_code : STRING
> >
> >
> >
> > tran_proc_fee_req : DECIMAL
> >
> >
> >
> > tran_proc_fee_rsp : DECIMAL
> >
> >
> >
> > tran_proc_fee_currency_code : STRING
> >
> >
> >
> > settle_amount_req : DECIMAL
> >
> >
> >
> > settle_amount_rsp : DECIMAL
> >
> >
> >
> > settle_cash_req : DECIMAL
> >
> >
> >
> > settle_cash_rsp : DECIMAL
> >
> >
> >
> > settle_tran_fee_req : DECIMAL
> >
> >
> >
> > settle_tran_fee_rsp : DECIMAL
> >
> >
> >
> > settle_proc_fee_req : DECIMAL
> >
> >
> >
> > settle_proc_fee_rsp : DECIMAL
> >
> >
> >
> > settle_currency_code : STRING
> >
> >
> >
> > However When I run the query against the dataset, I get the
> > following exception
> >
> >
> >
> >
> >
> > SYSTEM ERROR: ClassCastException:
> > org.apache.drill.exec.vector.NullableDecimal28SparseVector cannot be
> > cast to org.apache.drill.exec.vector.VariableWidthVector
> >
> >
> >
> >
> >
> > More so, the same error occurs when I include a decimal
> > field in the select clause. Please, is there something I am missing
> > or doing wrong, Any pointer will be deeply appreciated
> >
> >
> >
> > Kind Regards
> >
> >
> >
> > Peter
> >
> > ________________________________
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
