datafusion icon indicating copy to clipboard operation
datafusion copied to clipboard

CLI unable to execute queries with range(..) function

Open Omega359 opened this issue 10 months ago • 1 comments

Describe the bug

Noticed when attempting to reproduce #9755 the initial query in that issue does not work when run against current main branch:

❯ docker build -f datafusion-cli/Dockerfile . --tag datafusion-cli
...
❯ docker run -it -v /tmp:/data datafusion-cli
DataFusion CLI v37.1.0
> CREATE
OR REPLACE TABLE pricing AS
SELECT
    t,
    RANDOM() as v
FROM
    range(
        '2022-01-01' :: TIMESTAMP,
        '2023-01-01' :: TIMESTAMP,
        INTERVAL 1 DAY
    ) ts(t);
Error during planning: table function 'range' not found

To Reproduce

Build and start CLI, run query.

Expected behavior

Query should succeed.

Additional context

No response

Omega359 avatar Apr 22 '24 14:04 Omega359

I think it is a related issue with https://github.com/apache/datafusion/issues/10069#issue-2241483049 and if it is necessary to register range as a default table function, I would like to do that

Lordworms avatar Apr 23 '24 14:04 Lordworms