take more time filter from 3 crore records in hive table compare to mysql(Approx 3 GB Size) : I am working with `hive` table to execute one of sql to fetch some records from 3 crore records but it is taking more time to execute with map reduce process (300 seconds) and `mysql` fetch this information in less 1 seconds. Could you suggest me why `hive` take more time or any other way to fetch quick response.

As I am using `Ambari` Cluster with `Tez` engine. Could you guide me for this. As I am confusing for moving database on `hadoop`. Let me know your concerns.

Thanks in advance.