[DRILL-1188] AssertionError while running TPC-H query against hive datasource

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.5.0
• Component/s: Functions - Hive
• Assignee: Ramana Inukonda Nagaraj
• Reporter: Zhiyong Liu
• Created: 24/Jul/14 18:00
• Updated: 11/Aug/14 22:14
• Resolved: 11/Aug/14 21:53

Description

git.commit.id.abbrev=e5c2da0
git.commit.id=e5c2da0eb95df1a93d4ad909d5553757201dc903

0: jdbc:drill:schema=dfs.TpcHMulti> use hive;
----------------------+

ok

summary

----------------------+

true	Default schema changed to 'hive'

----------------------+
1 row selected (0.325 seconds)
0: jdbc:drill:schema=dfs.TpcHMulti> select
. . . . . . . . . . . . . . . . . > 100.00 * sum(case
. . . . . . . . . . . . . . . . . > when p.p_type like 'PROMO%'
. . . . . . . . . . . . . . . . . > then l.l_extendedprice * (1 - l.l_discount)
. . . . . . . . . . . . . . . . . > else 0
. . . . . . . . . . . . . . . . . > end) / sum(l.l_extendedprice * (1 - l.l_discount)) as promo_revenue
. . . . . . . . . . . . . . . . . > from
. . . . . . . . . . . . . . . . . > lineitem l,
. . . . . . . . . . . . . . . . . > part p
. . . . . . . . . . . . . . . . . > where
. . . . . . . . . . . . . . . . . > l.l_partkey = p.p_partkey
. . . . . . . . . . . . . . . . . > and l.l_shipdate >= date '1994-08-01'
. . . . . . . . . . . . . . . . . > and l.l_shipdate < date '1994-08-01' + interval '1' month;
Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "7aa9bffb-38a5-41aa-9e84-1fde3a2e7735"
endpoint {
address: "perfnode104.perf.lab"
user_port: 31010
control_port: 31011
data_port: 31012
}
error_type: 0
message: "Failure while running fragment. < AssertionError"
]
Error: exception while executing query (state=,code=0)