hadoopdb-general — The go to list when no other lists make sense

[Hadoopdb-general] SimpleRandomReplicationFactorTwo

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

Hi all,

I have problems with the replication script and config generator.

When I execute

java -cp hadoopdb.jar
edu.yale.cs.hadoopdb.catalog.SimpleRandomReplicationFactorTwo
catalog.properties

the program is not terminating. It creates the dump_* and load_replica_*
scripts but not the HadoopDB.xml.

I attached my catalog.properties and the verbose output.

Thank you for help

Kind regards,
Alex

[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