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

Unable to query on hdfs after moving to 0.9.0 version

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.9.0
    • Fix Version/s: 1.0.0
    • Component/s: Storage - Other
    • Labels:
      None

      Description

      I recently moved from drill 0.8.0 to 0.9.0. Since then,I am unable to query on json files present in hadoop file system( queries working fine on other storage plugins cp and dfs)

      I had registered a storage plugin named hadoop in drill. I had all my files in /user/hadoop in hdfs.

      When I query "use hadoop;" it returns "true". But from drill when I query "show files in hadoop.`/user/hadoop/`;" gives me following error

      Query failed: SYSTEM ERROR: Failure handling SQL.
      Error: exception while executing query: Failure while executing query. (state=,code=0)

      And when I do query "select * from hadoop.`/user/hadoop/donuts.json`;" gives me the following error

      Query failed: PARSE ERROR: From line 1, column 15 to line 1, column 20: Table 'hadoop./home/hadoop/donuts.json' not found

      Same queries worked fine when I use apache drill 0.8.0.

      So are there any extra things I should configure in drill 0.9.0 or is it a bug?

        Attachments

        1. DRILL-3037-1.patch
          10 kB
          Venki Korukanti

          Activity

            People

            • Assignee:
              vkorukanti Venki Korukanti
              Reporter:
              Sharath Sharath Akinapally
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: