I have a star schema in Oracle database. I have couple of queries that are
being executed in the database and the end result is an aaggregated
data based on columns in the database
For better performance while execuitng these queries the possible solution
what I think is to index the data using Map Reduce(Hadoop) and retrieve
data using Hive queries.
Does Lucene provide better performance in this scenario
1. by indexing using Lucene instead of HAdoop M/R
2. Searching using Lucene search instead of Hive queries
if i am using lucene what do i do in case i am using HDFS for storing data.
can i use distributed lucene or katta