getdozer / getdozer/dozer

Invalid source table in Table Operator TTL

Open
#1,980 0 comments 0 reactions 2 assignees Claimed by @chubei View on GitHub
bug sql
Dominant language
Rust
Stars
1.6k
Forks
145
PR merge metrics
No merged PRs in 30d

Description

This statement:

```
SELECT
PULocationID, DOLocationID,
pu_zones.Zone as PULocationName,
do_zones.Zone as DOLocationName,
AVG(fare_amount) as avg_amount
INTO avg_fares
FROM TTL(TUMBLE(trips, tpep_pickup_datetime, '1 HOUR'), window_end, '1 HOUR')
INNER JOIN zones pu_zones ON trips.PULocationID = pu_zones.LocationID
INNER JOIN zones do_zones ON trips.DOLocationID = do_zones.LocationID
WHERE PULocationID = 123
GROUP BY PULocationID, DOLocationID;
```

generates the above error

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.