Describe the bug
To Reproduce
CREATE EXTERNAL TABLE csv (price INT)
STORED AS CSV
LOCATION './tests/example.csv';
./tests/example.csv:
CREATE EXTERNAL TABLE example (price INT)
STORED AS CSV
LOCATION './tests/example.csv';
> select * from example where 1=2 ;
+-------+
| price |
+-------+
| 1 |
| 2 |
| 3 |
+-------+
Expected behavior
Should return an empty result set. When inspecting the optimized plan, the filter clause is removed (without changing the rest of the plan).
Additional context
The problem goes away when removing FilterPushDown so this is likely the offender