Yes, you can. In fact many people use sqoop and hive for exactly what you have told.
In my project what I m doing is loading the historical data from my RDBMS which was SQL, move it to HDFS. I had hive external tables defined for this path. This allowed me to run hive queries to do transformations. Also, we used to write mapreduce programs on top of these data to come up with various analysis.