[DRILL-871] Drill fails to detect errors in queries

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Fix Version/s: 0.4.0
• Component/s: Functions - Hive
• Assignee: Unassigned
• Reporter: Zhiyong Liu
• Created: 30/May/14 17:53
• Updated: 31/Jul/14 06:33
• Resolved: 30/May/14 18:47

Description

Accidentally had a typo in a query, such as

select o.O_TOTALPRICE, c.C_NAME
from orders o, customer c
where o.C_CUSTKEY = c.C_CUSTKEY and o.O_TOTALPRICE > 400000.00
order by o.O_TOTALPRICE;

The typo is o.C_CUSTKEY, which should be o.O_CUSTKEY. Drill executes the query with no error detected:

0: jdbc:drill:schema=dfs.TpcHMulti> select o.O_TOTALPRICE, c.C_NAME
. . . . . . . . . . . . . . . . . > from orders o, customer c
. . . . . . . . . . . . . . . . . > where o.C_CUSTKEY = c.C_CUSTKEY and o.O_TOTALPRICE > 400000.00
. . . . . . . . . . . . . . . . . > order by o.O_TOTALPRICE;
--

--
--
No rows selected (1.161 seconds)