[jira] [Created] (DRILL-8477) Unable to read a binary column in snowflake database
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)
[jira] [Commented] (DRILL-8188) Convert HDF5 format to EVF2
[ https://issues.apache.org/jira/browse/DRILL-8188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17805188#comment-17805188 ] ASF GitHub Bot commented on DRILL-8188: --- cgivre commented on PR #2515: URL: https://github.com/apache/drill/pull/2515#issuecomment-1885044910 @jnturton I did as you suggested. Would you mind please taking a look? > Convert HDF5 format to EVF2 > --- > > Key: DRILL-8188 > URL: https://issues.apache.org/jira/browse/DRILL-8188 > Project: Apache Drill > Issue Type: Improvement >Affects Versions: 1.20.0 >Reporter: Cong Luo >Assignee: Cong Luo >Priority: Major > > Use EVF V2 instead of old V1. > Also, fixed a few bugs in V2 framework. -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (DRILL-8475) The binary version License and NOTICE do not comply with the corresponding terms.
[ https://issues.apache.org/jira/browse/DRILL-8475?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17805065#comment-17805065 ] Calvin Kirs commented on DRILL-8475: We have some shaded JARs, such as drill-hive-exec-shaded, and I believe you missed its dependencies. > The binary version License and NOTICE do not comply with the corresponding > terms. > - > > Key: DRILL-8475 > URL: https://issues.apache.org/jira/browse/DRILL-8475 > Project: Apache Drill > Issue Type: Bug >Affects Versions: 1.21.1 >Reporter: Calvin Kirs >Assignee: James Turton >Priority: Blocker > Fix For: 1.21.2 > > Attachments: drill-dep-list.txt > > > I checked the latest released version, and it does not follow the > corresponding rules[1]. This is very important and I hope it will be taken > seriously by the PMC team. I'd be happy to do it if needed. > [1] [https://infra.apache.org/licensing-howto.html#binary] > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (DRILL-8475) The binary version License and NOTICE do not comply with the corresponding terms.
[ https://issues.apache.org/jira/browse/DRILL-8475?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Turton updated DRILL-8475: Attachment: drill-dep-list.txt > The binary version License and NOTICE do not comply with the corresponding > terms. > - > > Key: DRILL-8475 > URL: https://issues.apache.org/jira/browse/DRILL-8475 > Project: Apache Drill > Issue Type: Bug >Affects Versions: 1.21.1 >Reporter: Calvin Kirs >Assignee: James Turton >Priority: Blocker > Fix For: 1.21.2 > > Attachments: drill-dep-list.txt > > > I checked the latest released version, and it does not follow the > corresponding rules[1]. This is very important and I hope it will be taken > seriously by the PMC team. I'd be happy to do it if needed. > [1] [https://infra.apache.org/licensing-howto.html#binary] > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (DRILL-8475) The binary version License and NOTICE do not comply with the corresponding terms.
[ https://issues.apache.org/jira/browse/DRILL-8475?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17805061#comment-17805061 ] James Turton commented on DRILL-8475: - I've attached a sorted and deduplicated list of dependency module names taken from Drill's distribution module. > The binary version License and NOTICE do not comply with the corresponding > terms. > - > > Key: DRILL-8475 > URL: https://issues.apache.org/jira/browse/DRILL-8475 > Project: Apache Drill > Issue Type: Bug >Affects Versions: 1.21.1 >Reporter: Calvin Kirs >Assignee: James Turton >Priority: Blocker > Fix For: 1.21.2 > > Attachments: drill-dep-list.txt > > > I checked the latest released version, and it does not follow the > corresponding rules[1]. This is very important and I hope it will be taken > seriously by the PMC team. I'd be happy to do it if needed. > [1] [https://infra.apache.org/licensing-howto.html#binary] > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Comment Edited] (DRILL-8475) The binary version License and NOTICE do not comply with the corresponding terms.
[ https://issues.apache.org/jira/browse/DRILL-8475?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17805061#comment-17805061 ] James Turton edited comment on DRILL-8475 at 1/10/24 10:36 AM: --- I've attached a sorted and deduplicated list of 482 dependency module names taken from Drill's distribution module. was (Author: dzamo): I've attached a sorted and deduplicated list of dependency module names taken from Drill's distribution module. > The binary version License and NOTICE do not comply with the corresponding > terms. > - > > Key: DRILL-8475 > URL: https://issues.apache.org/jira/browse/DRILL-8475 > Project: Apache Drill > Issue Type: Bug >Affects Versions: 1.21.1 >Reporter: Calvin Kirs >Assignee: James Turton >Priority: Blocker > Fix For: 1.21.2 > > Attachments: drill-dep-list.txt > > > I checked the latest released version, and it does not follow the > corresponding rules[1]. This is very important and I hope it will be taken > seriously by the PMC team. I'd be happy to do it if needed. > [1] [https://infra.apache.org/licensing-howto.html#binary] > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
