Question: why hive query is slow?
Answer: Hive is for querying data that lives in Hadoop using SQL-like syntax. Data lives in Hadoop because it's not suitable for RDBMS -- too big, too complex to be reasonably queried, etc. Hive is convenient compared to writing MapReduce programs in Java, for example, so probably a bit slower than that, but likely not much.