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

Can not do select with two fields (field and nested field)

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 0.5.0
    • Fix Version/s: Future
    • Component/s: Client - ODBC
    • Labels:
    • Environment:

      MapR SendBox for Drill, Drill Explorer (ODBC)

      Description

      When I try to do a select in json file from Drill explorer:
      If I select one field, then the result is OK
      If I select two fields (field and its nested field) I get an error:

      ERROR [HY000] [MapR][Drill] (1040) Drill failed to execute the query: select t.user_info, t.user_info.device from `dfs`.`data`.`./nested/clicks/clicks.json` t

      [30024]Query execution error. Details:[
      Failure while running fragment. null [d8a551f4-281b-46a1-891e-037e7b46ff2b]
      ]

      I tested this query in SQLLine and it works fine:

      0: jdbc:drill:zk=localhost:5181> select t.user_info, t.user_info.device from `dfs`.`data`.`./nested/clicks/clicks.json` t limit 10 ;
      ----------------------+

      user_info EXPR$1

      ----------------------+

      {"cust_id":22526,"device":"IOS5","state":"il"} IOS5
      {"cust_id":16368,"device":"AOS4.2","state":"nc"} AOS4.2
      {"cust_id":21449,"device":"IOS6","state":"oh"} IOS6
      {"cust_id":20323,"device":"IOS5","state":"oh"} IOS5
      {"cust_id":15360,"device":"IOS5","state":"ca"} IOS5
      {"cust_id":15957,"device":"IOS7","state":"sc"} IOS7
      {"cust_id":20677,"device":"IOS7","state":"ny"} IOS7
      {"cust_id":23599,"device":"IOS5","state":"ri"} IOS5
      {"cust_id":16122,"device":"IOS6","state":"fl"} IOS6
      {"cust_id":15342,"device":"IOS5","state":"ms"} IOS5

      ----------------------+
      10 rows selected (1.13 seconds)

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              mtouk Iftissen
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: