[DRILL-5736] SYSTEM ERROR: NullPointerException when selecting 88 subdirectories including 88 parquet files(132MB)

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.11.0
• Component/s: Functions - Drill
• Labels: multiple nullpointerexception parquet

Environment

java version "1.8.0_40"
Java(TM) SE Runtime Environment (build 1.8.0_40-b26)
Java HotSpot(TM) 64-Bit Server VM (build 25.40-b25, mixed mode)

System Software Overview:

System Version: OS X 10.11.4 (15E65)
Kernel Version: Darwin 15.4.0
Boot Volume: Macintosh HD
Boot Mode: Normal
Computer Name: smallworld的MacBook Pro
User Name: smallworld (smallworld)
Secure Virtual Memory: Enabled
System Integrity Protection: Enabled
Time since boot: 1:38

• Assignee: Unassigned
• Reporter: Chris
• Created: 22/Aug/17 05:34
• Updated: 22/Aug/17 05:53

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