Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-871

Drill fails to detect errors in queries

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: None
    • Fix Version/s: 0.4.0
    • Component/s: Functions - Hive
    • Labels:
      None

      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)

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              zhiyongliu Zhiyong Liu
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: