Hi all,
my HadoopDB cluster is ready now but I have problems with the
SMS planner (patched hive).
For example here a query from the tpc-h benchmark:
SELECT l_orderkey, o_orderdate, o_shippriority,
SUM(l_extendedprice * (1 - l_discount)) AS revenue
FROM h_customer, h_order, h_lineitem
WHERE c_mktsegment = 'BUILDING' AND c_custkey = o_custkey
AND l_orderkey = o_orderkey AND o_orderdate < '1995-03-15'
AND l_shipdate > '1995-03-15'
GROUP BY l_orderkey, o_orderdate, o_shippriority
ORDER BY revenue DESC, o_orderdate LIMIT 10;
I got it from the "HadoopDB in Action" paper.
Hive prints out:
FAILED: Parse Error: line 3:15 mismatched input ',' expecting EOF
I guess Hive cannot handle multiple tables but how should I test it ?
How did you test tpc-h ?
I am using hadoop ver 0.19.1 and hive from svn trunk/
Thank you very much
Greetings
Alexander
|
