Re: Strange behavior with JOIN against correlated subquery

Hi Andy, When you have an array at the top level of your file, Drill treats the members as top-level tuples. Lateral is for the case where the data contains nested tuples. Try removing the LATERAL keyword. Thanks, - Paul On Thursday, January 23, 2020, 6:24:37 AM PST, Andy Grove

[GitHub] [drill] cgivre opened a new pull request #1960: DRILL-7550: Add Storage Plugin for Cassandra

cgivre opened a new pull request #1960: DRILL-7550: Add Storage Plugin for Cassandra URL: https://github.com/apache/drill/pull/1960 # [DRILL-7550](https://issues.apache.org/jira/browse/DRILL-7550): Add Storage Plugin for Cassandra ## Description This storage plugin enables

[jira] [Created] (DRILL-7550) Add Storage Plugin for Cassandra

Charles Givre created DRILL-7550: Summary: Add Storage Plugin for Cassandra Key: DRILL-7550 URL: https://issues.apache.org/jira/browse/DRILL-7550 Project: Apache Drill Issue Type: New

[DISCUSS]: Storage Plugins with Calcite Adapters

Hello all, I wanted to continue the discussion around storage plugins. Firstly, I'm really glad that Paul has developed the Base Storage plugin PR as that can greatly simplify one of the most complex issues around storage plugins: filter pushdowns. With that said, I've been working on a

Re: Thanks for the commits!

You are welcome :) > On Jan 23, 2020, at 7:04 PM, Charles Givre wrote: > > Hey Arina, > Thanks for the bulk commit. A lot of good stuff was committed, especially > the improvements to the JDBC storage plugin. > -- C >

Thanks for the commits!

Hey Arina, Thanks for the bulk commit. A lot of good stuff was committed, especially the improvements to the JDBC storage plugin. -- C

[jira] [Created] (DRILL-7549) Fix validation error when querying absent folder in embedded mode

Arina Ielchiieva created DRILL-7549: --- Summary: Fix validation error when querying absent folder in embedded mode Key: DRILL-7549 URL: https://issues.apache.org/jira/browse/DRILL-7549 Project:

[jira] [Resolved] (DRILL-7466) Configurable number of connection in JDBC storage connection pool

[ https://issues.apache.org/jira/browse/DRILL-7466?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Arina Ielchiieva resolved DRILL-7466. - Resolution: Fixed Merged into master with commit id

[jira] [Resolved] (DRILL-6738) validationQuery option for JDBC storage plugin

[ https://issues.apache.org/jira/browse/DRILL-6738?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Arina Ielchiieva resolved DRILL-6738. - Resolution: Fixed Merged into master with commit id

[jira] [Resolved] (DRILL-7398) dfs avro file support to treat non existent fields as null

[ https://issues.apache.org/jira/browse/DRILL-7398?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Arina Ielchiieva resolved DRILL-7398. - Resolution: Fixed Merged into master with commit id

[GitHub] [drill] asfgit closed pull request #1957: DRILL-7530: Fix class names in loggers

asfgit closed pull request #1957: DRILL-7530: Fix class names in loggers URL: https://github.com/apache/drill/pull/1957 This is an automated message from the Apache Git Service. To respond to the message, please log on to

[GitHub] [drill] asfgit closed pull request #1958: DRILL-7527: DROP METADATA doesn't work with table name starting with '/' inside workspace

asfgit closed pull request #1958: DRILL-7527: DROP METADATA doesn't work with table name starting with '/' inside workspace URL: https://github.com/apache/drill/pull/1958 This is an automated message from the Apache Git

[GitHub] [drill] asfgit closed pull request #1956: DRILL-7467: Jdbc plugin enhancements and fixes

asfgit closed pull request #1956: DRILL-7467: Jdbc plugin enhancements and fixes URL: https://github.com/apache/drill/pull/1956 This is an automated message from the Apache Git Service. To respond to the message, please log

[GitHub] [drill] asfgit closed pull request #1955: DRILL-7491: Incorrect count() returned for complex types in parquet

asfgit closed pull request #1955: DRILL-7491: Incorrect count() returned for complex types in parquet URL: https://github.com/apache/drill/pull/1955 This is an automated message from the Apache Git Service. To respond to

[GitHub] [drill] asfgit closed pull request #1948: DRILL-7506: Simplify code gen error handling

asfgit closed pull request #1948: DRILL-7506: Simplify code gen error handling URL: https://github.com/apache/drill/pull/1948 This is an automated message from the Apache Git Service. To respond to the message, please log on

[GitHub] [drill] asfgit closed pull request #1778: DRILL-7233: Format Plugin for HDF5

asfgit closed pull request #1778: DRILL-7233: Format Plugin for HDF5 URL: https://github.com/apache/drill/pull/1778 This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub

[GitHub] [drill] asfgit closed pull request #1951: DRILL-7454: Convert Avro to EVF

asfgit closed pull request #1951: DRILL-7454: Convert Avro to EVF URL: https://github.com/apache/drill/pull/1951 This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub

Jenkins build is back to normal : drill-scm #1105

See

Strange behavior with JOIN against correlated subquery

I have the following JSON file containing CPU metrics for multiple hosts. [ {"measurement": "cpu", "hostname": "host_0", "usage_irq": 63.6499207106198313, "timestamp_ns": 14516064000}, {"measurement": "cpu", "hostname": "host_0", "usage_irq": 58.0710619831364992, "timestamp_ns":

Build failed in Jenkins: drill-scm #1104

See Changes: -- Started by an SCM change Running as SYSTEM [EnvInject] - Loading node environment variables. Building remotely on H40 (ubuntu xenial) in workspace

[GitHub] [drill] arina-ielchiieva commented on issue #1959: DRILL-7548: Updating Environment.md to Skip Tests

arina-ielchiieva commented on issue #1959: DRILL-7548: Updating Environment.md to Skip Tests URL: https://github.com/apache/drill/pull/1959#issuecomment-577698562 +1 This is an automated message from the Apache Git Service.

[GitHub] [drill] arina-ielchiieva merged pull request #1959: DRILL-7548: Updating Environment.md to Skip Tests

arina-ielchiieva merged pull request #1959: DRILL-7548: Updating Environment.md to Skip Tests URL: https://github.com/apache/drill/pull/1959 This is an automated message from the Apache Git Service. To respond to the

Re: Slack Channel

+1 for asking to send to the Apache Drill mailing list. The advantage of mailing list usage is that its history of replies is preserved and may be found in mailing list archives or through googling, so it becomes possible for others with the same problem to find the solution or refer such users