[DRILL-6178] Drill does not project extra columns in some cases

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.12.0
• Component/s: Execution - Relational Operators
• Assignee: Pritesh Maker
• Reporter: Robert Hou
• Created: 22/Feb/18 03:48
• Updated: 22/Feb/18 04:56

Description

Drill is supposed to project extra columns as null columns.  This table has 10 columns.  The extra columns are shown as null:

0: jdbc:drill:zk=10.10.104.85:5181> select columns[0], columns[3], columns[4], columns[5], columns[6], columns[7], columns[8], columns[9], columns[10], columns[11], columns[12], columns[13], columns[14], columns[15] from `resource-manager/1.tbl`;
+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+----------+----------+----------+----------+
| EXPR$0 | EXPR$1 | EXPR$2 | EXPR$3 | EXPR$4 | EXPR$5 | EXPR$6 | EXPR$7 | EXPR$8 | EXPR$9 | EXPR$10 | EXPR$11 | EXPR$12 | EXPR$13 |
+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+----------+----------+----------+----------+
| 1 | | null | null | null | null | -61 | -255.0 | null | null | null | null | null | null |
+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+----------+----------+----------+----------+

 

If I run the same query against a table with 10 rows and 10 columns (attached to the Jira), only the 10 columns are shown.

 

select columns[0], columns[1], columns[2], columns[3], columns[4], columns[5], columns[6], columns[7], columns[8], columns[9], columns[10], columns[11], columns[12], columns[13], columns[14], columns[15] from `10.tbl`

 

 

 5kwidecolumns_500k.tbl