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

SYSTEM ERROR: NullPointerException when selecting 88 subdirectories including 88 parquet files(132MB)

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.11.0
    • Fix Version/s: None
    • Component/s: Functions - Drill
    • Environment:

      Description

      1. Parquet file structure to be queried. There're three directories /reports1, /reports2, and /reports1and2, as png files attached.
      --------------------------------------------------------------------------------------------------------
      /reports1 (36 subdirectories and 36 parquet files included.)

      __report1/0_0_0.parquet (1.5MB)
      __report2/0_0_0.parquet (1.5MB)
      ...
      __report36/0_0_0.parquet (1.5MB)

      /reports2 (50 subdirectories and 50 parquet files included.)

      __report37/0_0_0.parquet (1.5MB)
      __report38/0_0_0.parquet (1.5MB)
      ...
      __report88/0_0_0.parquet (1.5MB)

      /reports1and2 88 subdirectories and 88 parquet files merged above.

      __report1/0_0_0.parquet (1.5MB)
      __report2/0_0_0.parquet (1.5MB)
      ...
      __report88/0_0_0.parquet (1.5MB)

      2. Error when doing SELECT query.
      2.1 SELECT reports1, it is ok.
      0: jdbc:drill:zk=local> SELECT snp_id from db.`reports1/report_HCB*`;
      61,994 rows selected (0.744 seconds)

      2.2 SELECT reports2, it is ok.
      0: jdbc:drill:zk=local> SELECT snp_id from db.`reports2/report_HCB*`;
      85,452 rows selected (0.743 seconds)

      2.3 SELECT reports1and2, errors occur.
      0: jdbc:drill:zk=local> SELECT snp_id from db.`reports1and2/report_HCB*`;
      Error: SYSTEM ERROR: NullPointerException

      Fragment 1:1

      [Error Id: 54595882-3767-4b0a-91c4-671b16b86fdf on 192.168.0.13:31010] (state=,code=0)

      3. Error log

      See attached error_log20170822.txt

        Attachments

        1. error_log20170822.txt
          74 kB
          Chris
        2. report1_ok.png
          30 kB
          Chris
        3. report1and2_error.png
          47 kB
          Chris
        4. report1and2_struct.png
          155 kB
          Chris
        5. report2_ok.png
          23 kB
          Chris

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              xinqianli Chris
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: