When running the following query, where the field "dummy" doesn't exist:

select o_orderkey, o_custkey from `tpch0.01/orders` order by dummy limit 5;
I get the following result:

> +------------+------------+
> | o_orderkey | o_custkey  |
> +------------+------------+
> | 2          | 781        |
> | 3          | 1234       |
> | 4          | 1369       |
> | 5          | 445        |
> | 1          | 370        |
> +------------+------------+

Is this a bug ? shouldn't the query fail instead ?

If the user makes a mistake and writes a wrong field name, the query will
still run and the user may not notice the results are actually not sorted
properly.

Thanks!


-- 

Abdelhakim Deneche

Software Engineer

  <http://www.mapr.com/>


Now Available - Free Hadoop On-Demand Training
<http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available>

Reply via email to