lenahi

S3 Select columns query of index AS clause doesn't work

4

Sample input csv file: c1|c2|c3 1|2|3 1||3 Summary: Cant get expected output with S3 index columns query. Please help look at below test, and guide me how to run the...

Lab Configuration: drill version: 1.21.1 drill postgres storage plugin configuration: ``` { "type": "jdbc", "driver": "org.postgresql.Driver", "url": "jdbc:postgresql://:/data", "credentialsProvider": { "credentialsProviderType": "VaultCredentialsProvider", "secretPath": "drill/test_postgres", "propertyNames": { "username": "usernameSecret", "password": "passwordSecret"...

**Lab Configuration:** Drill query files in Minio bucket "test". drill version: 1.21.1 minio verison: RELEASE.2023-01-25T00-19-54Z drill storage configuration: ``` { "type": "file", "connection": "s3a://test", "config": { "fs.s3a.endpoint": "http://nginx:9000", "fs.s3a.connection.ssl.enabled": "false",...

Can we have a api to separate the complex multi-table join query to sub-queries?

4

For a simple join query blow: q = "SELECT Orders.OrderID, Customers.CustomerName FROM Orders INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID;" we hope it can separate something similar: "Orders": "SELECT OrderID,...