Harini K.K. created DRILL-8477: ---------------------------------- Summary: Unable to read a binary column in snowflake database Key: DRILL-8477 URL: https://issues.apache.org/jira/browse/DRILL-8477 Project: Apache Drill Issue Type: Bug Components: Execution - Data Types Affects Versions: 1.20.3 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. !image-2024-01-10-20-52-27-574.png|width=481,height=148! Please provide a solution how to use binary datatype Reporter: Harini K.K. Attachments: image-2024-01-10-20-32-01-413.png, image-2024-01-10-20-51-44-252.png, image-2024-01-10-20-52-27-574.png 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. !image-2024-01-10-20-32-01-413.png|width=509,height=177! This is how the data look in the table. -- This message was sent by Atlassian Jira (v8.20.10#820010)