adragomir commented on issue #75:
URL: https://github.com/apache/datafusion-ray/issues/75#issuecomment-2701854253
@robtandy HTH, if not, I can start working on a full test case tomorrow,
harder to extract minimal query and setup.
Table schema would look like (duckdb syntax to get a parquet file):
```
CREATE OR REPLACE TABLE midvalues(
timestamp TIMESTAMP_S, -- 0
web STRUCT(
webPageDetails STRUCT(
pageViews STRUCT(value INT8)
)
),
endUserIDs STRUCT(
_experience STRUCT(
mcid STRUCT(
id VARCHAR,
extra1 VARCHAR
),
aaid STRUCT(
id VARCHAR,
extra1 VARCHAR
)
)
)
);
COPY midvalues TO 'midvalues.parquet' (FORMAT PARQUET);
```
SQL query:
```
SELECT
timestamp,
web.webPageDetails.pageViews.value AS pageview,
endUserIDs._experience.mcid.id AS mcid,
endUserIDs._experience.aaid.id AS aaid
FROM
midvalues
WHERE
timestamp >= TO_TIMESTAMP('2025-01-15')
AND timestamp < TO_TIMESTAMP('2025-01-16')
```
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
