>1. Is there a unique key for the query log? The log I am refering to is the wdqs_extract table from the hive database wmf. We would like to be able to permanently link our own >computed data with the log entry we computed it from.
The answer is no, there is not, other than one you can calculate with the data available.
>
3. Is there any other database system besides hive installed on the server?Ahemm.. hive is not a database but I imagine if you are asking whether you need to write hive-friendly sql to access data? The answer is yes, you have to. You are talking to hadoop with SQL that is going to serialize itself into java code and return you the data you are interested in.
Beeline or hive should work.