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)
