[DRILL-822] Conversion to relational algebra failed to preserve datatypes

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Component/s: Query Planning & Optimization
• Assignee: Aman Sinha
• Reporter: Zhiyong Liu
• Created: 22/May/14 23:48
• Updated: 21/Jul/14 03:15
• Resolved: 21/Jul/14 03:15

Description

Datasources: TPCH (10MB), three-way split parquet files
git.commit.id.abbrev=2fad21d
git.commit.id=2fad21d5a6ec43bb68fb989e48b6da180f23f73a

0: jdbc:drill:schema=dfs.TpcHMulti> select * from region order by r_regionkey;
Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "2f293a00-2cf6-4663-b961-7cde388efeb5"
endpoint {
address: "perfnode104.perf.lab"
user_port: 31010
control_port: 31011
data_port: 31012
}
error_type: 0
message: "Failure while setting up Foreman. < AssertionError:[ Internal error: Conversion to relational algebra failed to preserve datatypes:
validated type:
RecordType(ANY *) NOT NULL
converted type:
RecordType(ANY *, ANY r_regionkey) NOT NULL
rel:
ProjectRel(*=[$0], r_regionkey=[$1])
SortRel(sort0=[$1], dir0=[ASC])
ProjectRel(*=[$0], r_regionkey=[$1], r_regionkey0=[$1])
TableAccessRel(table=[[dfs, TpcHMulti, region]])
]"
]
Error: exception while executing query (state=,code=0)

Issue Links

• duplicates: DRILL-586 Order by on select * fails