Zhiyong Liu created DRILL-1188:
----------------------------------
Summary: AssertionError while running tech query against hive
datasource
Key: DRILL-1188
URL: https://issues.apache.org/jira/browse/DRILL-1188
Project: Apache Drill
Issue Type: Bug
Components: Functions - Hive
Environment: 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)
Reporter: Zhiyong Liu
--
This message was sent by Atlassian JIRA
(v6.2#6252)
