[jira] [Updated] (DRILL-7815) 1.18 cannot connect to Hive 2.3 with embedded metastore
[ https://issues.apache.org/jira/browse/DRILL-7815?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] luocong updated DRILL-7815: --- Description: Hi, I tested the compatibility of the 1.18 RC. As a result, Drill 1.18 can still connect to HDFS 2.6 (Based CDH 5.13), but cannot connect to Hive 2.3. The metadata of Hive 3.1 required by Drill 1.18 has changed a lot. This is the official upgrade script([https://github.com/apache/hive/blob/master/standalone-metastore/metastore-server/src/main/sql/mysql/upgrade-2.3.0-to-3.0.0.mysql.sql]). Here are the errors thrown by trying to connect to Hive 2.3 with embedded metastore. And then I also test the remote metastore, can be created successfully, but don't show anything after "show databases". {code:java} Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'CTLG_NAME' in 'field list' at sun.reflect.GeneratedConstructorAccessor368.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) {code} was: Hi, I tested the compatibility of the 1.18 RC. As a result, Drill 1.18 can still connect to HDFS 2.6 (Based CDH 5.13), but cannot connect to Hive 2.3. The metadata of Hive 3.1 required by Drill 1.18 has changed a lot. This is the official upgrade script([https://github.com/apache/hive/blob/master/standalone-metastore/metastore-server/src/main/sql/mysql/upgrade-2.3.0-to-3.0.0.mysql.sql]). Here are the errors thrown by trying to connect to Hive 2.3 with embedded metastore. And then I also test the remote metastore, can be created successfully, but don't show anything after "show dadabases". {code:java} Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'CTLG_NAME' in 'field list' at sun.reflect.GeneratedConstructorAccessor368.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) {code} > 1.18 cannot connect to Hive 2.3 with embedded metastore > --- > > Key: DRILL-7815 > URL: https://issues.apache.org/jira/browse/DRILL-7815 > Project: Apache Drill > Issue Type: Bug > Components: Storage - Hive >Affects Versions: 1.18.0 > Environment: Hive 2.3.7 >Reporter: luocong >Priority: Major > > Hi, I tested the compatibility of the 1.18 RC. As a result, Drill 1.18 can > still connect to HDFS 2.6 (Based CDH 5.13), but cannot connect to Hive 2.3. > The metadata of Hive 3.1 required by Drill 1.18 has changed a lot. This is > the official upgrade > script([https://github.com/apache/hive/blob/master/standalone-metastore/metastore-server/src/main/sql/mysql/upgrade-2.3.0-to-3.0.0.mysql.sql]). > Here are the errors thrown by trying to connect to Hive 2.3 with embedded > metastore. And then I also test the remote metastore, can be created > successfully, but don't show anything after "show databases". > {code:java} > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown > column 'CTLG_NAME' in 'field list' > at sun.reflect.GeneratedConstructorAccessor368.newInstance(Unknown > Source) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:423) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) > {code} > > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (DRILL-7815) 1.18 cannot connect to Hive 2.3 with embedded metastore
luocong created DRILL-7815: -- Summary: 1.18 cannot connect to Hive 2.3 with embedded metastore Key: DRILL-7815 URL: https://issues.apache.org/jira/browse/DRILL-7815 Project: Apache Drill Issue Type: Bug Components: Storage - Hive Affects Versions: 1.18.0 Environment: Hive 2.3.7 Reporter: luocong Hi, I tested the compatibility of the 1.18 RC. As a result, Drill 1.18 can still connect to HDFS 2.6 (Based CDH 5.13), but cannot connect to Hive 2.3. The metadata of Hive 3.1 required by Drill 1.18 has changed a lot. This is the official upgrade script([https://github.com/apache/hive/blob/master/standalone-metastore/metastore-server/src/main/sql/mysql/upgrade-2.3.0-to-3.0.0.mysql.sql]). Here are the errors thrown by trying to connect to Hive 2.3 with embedded metastore. And then I also test the remote metastore, can be created successfully, but don't show anything after "show dadabases". {code:java} Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'CTLG_NAME' in 'field list' at sun.reflect.GeneratedConstructorAccessor368.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (DRILL-7745) Add storage plugin for IPFS
[ https://issues.apache.org/jira/browse/DRILL-7745?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17242948#comment-17242948 ] ASF GitHub Bot commented on DRILL-7745: --- dbw9580 commented on pull request #2084: URL: https://github.com/apache/drill/pull/2084#issuecomment-737693796 > @dbw9580 > Hi there! I hope all is well. Are you still interested in completing this PR? Yes. I'm currently busy with other projects, and haven't had time to look further into this. I remember we were having some discussions about the way this plugin interacts with the Drill coordinator that needs a major design reconsideration. When I can spare more time on this, I will continue where I left off. This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org > Add storage plugin for IPFS > --- > > Key: DRILL-7745 > URL: https://issues.apache.org/jira/browse/DRILL-7745 > Project: Apache Drill > Issue Type: New Feature > Components: Storage - Other >Affects Versions: 1.18.0 >Reporter: Bowen Ding >Assignee: Bowen Ding >Priority: Major > > See introduction here: [https://github.com/bdchain/Minerva] > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (DRILL-7814) Add Limit Pushdown to MongoDB Storage Plugin
[ https://issues.apache.org/jira/browse/DRILL-7814?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17242917#comment-17242917 ] ASF GitHub Bot commented on DRILL-7814: --- cgivre opened a new pull request #2120: URL: https://github.com/apache/drill/pull/2120 # [DRILL-7814](https://issues.apache.org/jira/browse/DRILL-7814): Add Limit Pushdown to MongoDB Storage Plugin ## Description This PR adds a limit pushdown capability to the MongoDB storage plugin. ## Documentation No user visible changes ## Testing Added new class of unit tests for the pushdown. This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org > Add Limit Pushdown to MongoDB Storage Plugin > > > Key: DRILL-7814 > URL: https://issues.apache.org/jira/browse/DRILL-7814 > Project: Apache Drill > Issue Type: Improvement > Components: Storage - MongoDB >Affects Versions: 1.17.0 >Reporter: Charles Givre >Assignee: Charles Givre >Priority: Major > Fix For: 1.19.0 > > > Drill's MongoDB plugin does not push limits down to Mongo. This PR adds this > capability. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (DRILL-7814) Add Limit Pushdown to MongoDB Storage Plugin
Charles Givre created DRILL-7814: Summary: Add Limit Pushdown to MongoDB Storage Plugin Key: DRILL-7814 URL: https://issues.apache.org/jira/browse/DRILL-7814 Project: Apache Drill Issue Type: Improvement Components: Storage - MongoDB Affects Versions: 1.17.0 Reporter: Charles Givre Assignee: Charles Givre Fix For: 1.19.0 Drill's MongoDB plugin does not push limits down to Mongo. This PR adds this capability. -- This message was sent by Atlassian Jira (v8.3.4#803005)