You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Peter Edike <pe...@interswitchgroup.com> on 2018/04/27 12:20:22 UTC
Exception While Querying Decimal Fields in Apache Drill
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
________________________________
Re: Exception While Querying Decimal Fields in Apache Drill
Posted by Vova Vysotskyi <vv...@gmail.com>.
Thanks for the stack trace, it helped to find the root cause of this
problem.
Decimal values in parquet table are stored using BINARY primitive type, but
currently, Drill does not support decimals stored as binary.
The good news is that it will be fixed in DRILL-6094.
Kind regards,
Volodymyr Vysotskyi
пн, 30 квіт. 2018 о 11:44 Peter Edike <pe...@interswitchgroup.com>
пише:
>
>
> 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.AbstractRecordB
RE: Exception While Querying Decimal Fields in Apache Drill
Posted by Peter Edike <pe...@interswitchgroup.com>.
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 <vv...@gmail.com>
Sent: Monday, April 30, 2018 9:37 AM
To: user@drill.apache.org
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 <pe...@interswitchgroup.com>
пише:
> 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 <vv...@gmail.com>
> Sent: Friday, April 27, 2018 5:29 PM
> To: user@drill.apache.org
> 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
> <pe...@interswitchgroup.com>
> пише:
>
> >
> >
> > Drill Version 1.12.0
> >
> >
> >
> > planner.enable_decimal_data_type is set to true on the system.
> >
> >
> >
> > --peter
> >
> >
> >
> >
> >
> > -----Original Message-----
> >
> > From: Andries Engelbrecht <ae...@mapr.com>
> >
> > Sent: Friday, April 27, 2018 3:41 PM
> >
> > To: user@drill.apache.org
> >
> > 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"
> > <pe...@interswitchgroup.com>
> > 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 <ae...@mapr.com>
> >
> > Sent: Friday, April 27, 2018 3:07 PM
> >
> > To: user@drill.apache.org
> >
> > 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"
> > <pe...@interswitchgroup.com>
> > 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
> >
> > ________________________________
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
Re: Exception While Querying Decimal Fields in Apache Drill
Posted by Vova Vysotskyi <vv...@gmail.com>.
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 <pe...@interswitchgroup.com>
пише:
> 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.checkAndThrowException(Unknown
> Source)
> at
> com.mapr.drill.drill.dataengine.DRQryResultListener.getNextBatch(Unknown
> Source)
> at
> com.mapr.drill.drill.dataengine.DRJDBCResultSet.doLoadRecordBatchData(Unknown
> Source)
> at
> com.mapr.drill.drill.dataengine.DRJDBCResultSet.doMoveToNextRow(Unknown
> 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 <vv...@gmail.com>
> Sent: Friday, April 27, 2018 5:29 PM
> To: user@drill.apache.org
> 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 <pe...@interswitchgroup.com>
> пише:
>
> >
> >
> > Drill Version 1.12.0
> >
> >
> >
> > planner.enable_decimal_data_type is set to true on the system.
> >
> >
> >
> > --peter
> >
> >
> >
> >
> >
> > -----Original Message-----
> >
> > From: Andries Engelbrecht <ae...@mapr.com>
> >
> > Sent: Friday, April 27, 2018 3:41 PM
> >
> > To: user@drill.apache.org
> >
> > 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" <pe...@interswitchgroup.com>
> > 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 <ae...@mapr.com>
> >
> > Sent: Friday, April 27, 2018 3:07 PM
> >
> > To: user@drill.apache.org
> >
> > 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"
> > <pe...@interswitchgroup.com>
> > 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
> >
> > ________________________________
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
RE: Exception While Querying Decimal Fields in Apache Drill
Posted by Peter Edike <pe...@interswitchgroup.com>.
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.checkAndThrowException(Unknown Source)
at com.mapr.drill.drill.dataengine.DRQryResultListener.getNextBatch(Unknown Source)
at com.mapr.drill.drill.dataengine.DRJDBCResultSet.doLoadRecordBatchData(Unknown Source)
at com.mapr.drill.drill.dataengine.DRJDBCResultSet.doMoveToNextRow(Unknown 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 <vv...@gmail.com>
Sent: Friday, April 27, 2018 5:29 PM
To: user@drill.apache.org
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 <pe...@interswitchgroup.com>
пише:
>
>
> Drill Version 1.12.0
>
>
>
> planner.enable_decimal_data_type is set to true on the system.
>
>
>
> --peter
>
>
>
>
>
> -----Original Message-----
>
> From: Andries Engelbrecht <ae...@mapr.com>
>
> Sent: Friday, April 27, 2018 3:41 PM
>
> To: user@drill.apache.org
>
> 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" <pe...@interswitchgroup.com>
> 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 <ae...@mapr.com>
>
> Sent: Friday, April 27, 2018 3:07 PM
>
> To: user@drill.apache.org
>
> 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"
> <pe...@interswitchgroup.com>
> 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
>
> ________________________________
>
>
>
>
>
>
>
>
>
>
>
Re: Exception While Querying Decimal Fields in Apache Drill
Posted by Vova Vysotskyi <vv...@gmail.com>.
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 <pe...@interswitchgroup.com>
пише:
>
>
> Drill Version 1.12.0
>
>
>
> planner.enable_decimal_data_type is set to true on the system.
>
>
>
> --peter
>
>
>
>
>
> -----Original Message-----
>
> From: Andries Engelbrecht <ae...@mapr.com>
>
> Sent: Friday, April 27, 2018 3:41 PM
>
> To: user@drill.apache.org
>
> 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" <pe...@interswitchgroup.com>
> 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 <ae...@mapr.com>
>
> Sent: Friday, April 27, 2018 3:07 PM
>
> To: user@drill.apache.org
>
> 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" <pe...@interswitchgroup.com>
> 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
>
> ________________________________
>
>
>
>
>
>
>
>
>
>
>
RE: Exception While Querying Decimal Fields in Apache Drill
Posted by Peter Edike <pe...@interswitchgroup.com>.
Drill Version 1.12.0
planner.enable_decimal_data_type is set to true on the system.
--peter
-----Original Message-----
From: Andries Engelbrecht <ae...@mapr.com>
Sent: Friday, April 27, 2018 3:41 PM
To: user@drill.apache.org
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" <pe...@interswitchgroup.com> 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 <ae...@mapr.com>
Sent: Friday, April 27, 2018 3:07 PM
To: user@drill.apache.org
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" <pe...@interswitchgroup.com> 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
________________________________
Re: Exception While Querying Decimal Fields in Apache Drill
Posted by Andries Engelbrecht <ae...@mapr.com>.
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" <pe...@interswitchgroup.com> 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 <ae...@mapr.com>
Sent: Friday, April 27, 2018 3:07 PM
To: user@drill.apache.org
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" <pe...@interswitchgroup.com> 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
________________________________
RE: Exception While Querying Decimal Fields in Apache Drill
Posted by Peter Edike <pe...@interswitchgroup.com>.
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 <ae...@mapr.com>
Sent: Friday, April 27, 2018 3:07 PM
To: user@drill.apache.org
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" <pe...@interswitchgroup.com> 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
________________________________
Re: Exception While Querying Decimal Fields in Apache Drill
Posted by Andries Engelbrecht <ae...@mapr.com>.
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" <pe...@interswitchgroup.com> 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
________________________________