[DRILL-8477] Unable to read a binary column in snowflake database

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.20.3
• Component/s: Execution - Data Types

Environment

When I am trying to query the same in drill using the below mentioned query

select * from snowflake_new_01.JUMBO_TEST.JUMBO.ACCOUNT_TEST_1

The result is null even if the data is present in the database please refer above picture.

Please provide a solution how to use binary datatype

• Assignee: Unassigned
• Reporter: Harini K.K.
• Created: 10/Jan/24 15:26
• Updated: 10/Jan/24 15:26

Description

Trying to execute a table in snowflake db through where the table contains a column of type binary(16). 

create or replace TABLE JUMBO_TEST.JUMBO.ACCOUNT_TEST_1 ( ACCOUNT_HK BINARY(16) NOT NULL, PORTF_LIST VARCHAR(16777216) NOT NULL COLLATE 'utf8_general_ci', LDTS TIMESTAMP_LTZ(9), RECSRC VARCHAR(16777216) COLLATE 'utf8_general_ci', constraint LIST_UK unique (PORTF_LIST) rely , constraint PORTFOLIO_HK_UK unique (ACCOUNT_HK) rely );

Above is the definition  which I used to create the table.

This is how the data look in the table.