Querying non-existant table

[sebastian]

Querying the NAV_TENANT data source, there have been queries issued against a non-existent table!

Like:

                select
                    grouping_id(
                        date_trunc('year', dropoff_datetime),
date_trunc('quarter', dropoff_datetime),
date_trunc('month', dropoff_datetime),
date_trunc('day', dropoff_datetime),
date_trunc('hour', dropoff_datetime),
date_trunc('minute', dropoff_datetime),
date_trunc('second', dropoff_datetime)
                    ),
                    date_trunc('year', dropoff_datetime),
date_trunc('quarter', dropoff_datetime),
date_trunc('month', dropoff_datetime),
date_trunc('day', dropoff_datetime),
date_trunc('hour', dropoff_datetime),
date_trunc('minute', dropoff_datetime),
date_trunc('second', dropoff_datetime),
                    count(*),
                    count_noise(*)
                from year
                group by grouping sets (2, 3, 4, 5, 6, 7, 8)

where year is not at all a table.

All errors here

[dandanlen]

I found the year table, it's in the taxi_year dataset...

So it's somehow issuing queries against the wrong dataset.

[dandanlen]

Closing this issue since

• I never managed to reproduce it.
• I haven't seen it recur despite the extra logging we have added since the issue was first raised.