You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Zhiyong Liu (JIRA)" <ji...@apache.org> on 2014/07/24 20:02:38 UTC

[jira] [Updated] (DRILL-1188) AssertionError while running tech query against hive datasource

     [ https://issues.apache.org/jira/browse/DRILL-1188?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Zhiyong Liu updated DRILL-1188:
-------------------------------

    Environment:     (was: 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))

> 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
>            Reporter: Zhiyong Liu
>




--
This message was sent by Atlassian JIRA
(v6.2#6252)