I have recently started looking into querying large sets of CSV data lying on HDFS using Hive and Impala. As I was expecting, I get better response time with Impala compared... more
I have recently started looking into querying large sets of CSV data lying on HDFS using Hive and Impala. As I was expecting, I get better response time with Impala compared to Hive for the queries I have used so far.
I am wondering if there are some types of queries/use cases that still need Hive and where Impala is not a good fit.
How does Impala provide faster query response compared to Hive for the same data on HDFS?
I am new to hive, and want to know if there is anyway to insert data into hive table like we do in SQL. I want to insert my data into hive likeINSERT INTO tablename VALUES... moreI am new to hive, and want to know if there is anyway to insert data into hive table like we do in SQL. I want to insert my data into hive likeINSERT INTO tablename VALUES (value1,value2..)I have read that you can load the data from a file to hive table or you can import data from one table to hive table but is there any way to append the data as in SQL?