egasimov opened a new issue, #2936:
URL: https://github.com/apache/drill/issues/2936
Hello Drill community,
Recently, we have discovered apache drill and started to make some
experiments on reading files and run the filter kinda queries over dataset.
So, my scenario is as follows:
I have a parquet file whose contents as follows:(customers with the
purchased items)
When to try to find the customers who purchased the following items whose
product_id is from the given list (777,888)
The following query sent to drill server:
```
{
"queryType": "SQL",
"query": "SELECT * FROM dfs.root.`/datas3/customers/*` d WHERE EXISTS (
SELECT 1 FROM UNNEST(d.purchased_items) AS s WHERE s.item_id in (777))"
}
```
Getting the following error:
**VALIDATION ERROR:** From line 1, column 118 to line 1, column 124: Column
'item_id' not found in table 's'
**Additional Context**
- Apache drill version: 1.21.2
- Test data
```
[
{
"customer_id": 1000001,
"customer_name": "John Doe",
"purchased_items" : [
{
"item_id": 2000001,
"item_class": "A",
"product_id" : 777,
"created_at": "2024-06-12T11:36:37.751Z"
},
{
"item_id":2000002,
"item_class": "B",
"product_id" : 888,
"created_at": "2024-06-12T11:46:37.751Z"
},
{
"item_id":2000003,
"item_class": "C",
"product_id" : 999,
"created_at": "2024-06-12T11:46:37.751Z"
}
]
}
]
```
--
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.
To unsubscribe, e-mail: dev-unsubscr...@drill.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
