drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sudheesh Katkam (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-1188) AssertionError while running TPC-H query against hive datasource
Date Mon, 11 Aug 2014 21:54:20 GMT

    [ https://issues.apache.org/jira/browse/DRILL-1188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14093384#comment-14093384
] 

Sudheesh Katkam commented on DRILL-1188:
----------------------------------------

No feedback.  Assume resolved.

> AssertionError while running TPC-H 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
>            Assignee: Ramana Inukonda Nagaraj
>             Fix For: 0.5.0
>
>         Attachments: 14.p, DRILL-1188.log
>
>
> 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)



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

Mime
View raw message