Details
-
Improvement
-
Status: Resolved
-
Trivial
-
Resolution: Fixed
-
0.2-incubating
-
None
Description
Current implementation is
ResultSet res = tpch.execute("select 100 * sum(" + "case when p_type like 'PROMO%' then l_extendedprice else 0.0 end) / sum(l_extendedprice * (1 - l_discount)) " + "as promo_revenue from lineitem, part where l_partkey = p_partkey"); assertTrue(res.next()); assertEquals(33, res.getInt(1));
Changed implementation is
ResultSet res = tpch.execute("select 100 * sum(" + "case when p_type like 'PROMO%' then l_extendedprice else 0.0 end) / sum(l_extendedprice * (1 - l_discount)) " + "as promo_revenue from lineitem, part where l_partkey = p_partkey"); try { assertTrue(res.next()); assertEquals(33, res.getInt(1)); } finally { res.close(); }
Attachments
Issue Links
- relates to
-
TAJO-127 Implement Tajo Resource Manager
- Resolved