[Hadoopdb-general] SQL queries

[Alexander R. <ale...@fu...>]

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